This topic describes the features and limitations related to collecting DBW logs.
Database Workshop (DBW) is a unified cloud management platform designed for multi-type database lifecycle management. The DBW instance list(new edition) provides centralized management for database instances including Cloud Database MySQL, Cloud Database veDB MySQL, Cache Database Redis, Document Database MongoDB, Cloud Database PostgreSQL, and Cloud Database SQL Server.
TLS supports delivering audit logs, error logs, and slow query logs from database instances in the same region to TLS for storage and analysis. The supported instances are as follows:
DBW log analysis feature configuration is as follows:
Enable DBW audit log collection
- For steps to create a DBW database instance, usage restrictions, prerequisites, and more, see Instance list management.
- Enable audit log collection.
- Log in to the DBW console and activate the database audit feature. For details, refer to the following link. Or, you can proceed to the next step. In the TLS console, follow the on-screen instructions to jump directly to the database audit page for the corresponding instance and manually enable the database audit feature.
- Select the region where log service is located from the top navigation bar.
- On the left navigation bar, select Common functions > Log collection.
- On the Collection of cloud service logs tab, click DBW database log to enter the DBW instance list page.
- In the Audit log column of the corresponding instance, click Open.
- After confirming the log storage region, project, and log topic, and setting the retention period, click OK.
Notice
If you have not enabled the log audit feature in the DBW Console, after clicking OK, follow the instructions on the screen and click Go to enable to go to the database audit page for the instance in the DBW Console and manually enable log audit.
- Storage region: Database instance region
- Project: rds-project-<accountID>-<regionID>
- Retention period: 30 days by default
Enable DBW error log collection
- For steps to create a DBW database instance, usage restrictions, prerequisites, and more, see Instance list management.
- Select the region where log service is located from the top navigation bar.
- On the left navigation bar, select Common functions > Log collection.
- On the Collection of cloud service logs tab, click DBW database log to enter the DBW instance list page.
- In the error log column of the corresponding instance, select Open.
- After confirming the log storage region, project, and log topic, and setting the retention period, click OK.
- Storage region: Database instance region
- Project: rds-project-<accountID>-<regionID>
- Retention period: 180 days by default
Enable DBW slow query log collection
- For steps to create a DBW database instance, usage restrictions, prerequisites, and more, see Instance list management.
- Select the region where log service is located from the top navigation bar.
- On the left navigation bar, select Common functions > Log collection.
- On the Collection of cloud service logs tab, click DBW database log to enter the DBW instance list page.
- In the Slow query log column for the corresponding instance, click Open.
- After confirming the log storage region, project, and log topic, and setting the retention period, click OK.
- Storage region: Database instance region
- Project: rds-project-<accountID>-<regionID>
- Retention period: 180 days by default