Integrate Alibaba Cloud ApsaraDB RDS-Cloud Monitor(CMS)-阿里云帮助中心

Prerequisites

To integrate metrics, you must activate Managed Service for Prometheus and Hybrid Cloud Monitoring.

Limitations

If you use a RAM user for the integration, you must grant the AliyunCloudMonitorFullAccess system policy and the AliyunLogArchiveRole role to the RAM user.
See MySQL Feature Overview, PostgreSQL Feature Overview, and SQL Server Feature Overview for the ApsaraDB RDS instance types that support the SQL Audit feature.
Error logs and slow query logs are supported only for MySQL and PostgreSQL instances.
If you stop collecting ApsaraDB RDS audit logs, you must manually disable SQL Explorer and Audit in the ApsaraDB RDS console.

Billing

Metric integration incurs fees for real-time export from Hybrid Cloud Monitoring and Managed Service for Prometheus. Second-level metric integration also incurs fees for second-level monitoring in Hybrid Cloud Monitoring.
SQL audit log collection requires the SQL Audit feature (PostgreSQL and SQL Server) or the SQL Explorer feature (MySQL), which incur separate charges. For more information, see Billing items.
Simple Log Service (SLS) charges apply for storage, read traffic, requests, data processing, and data shipping of collected ApsaraDB RDS logs. For more information, see Pay-as-you-go.

Procedure

Log on to the CloudMonitor 2.0 console. Select a workspace, and in the navigation pane, click Integration Center. Then, click ApsaraDB RDS.
Create or select a Policy name and select an Entity Scope.

Select the observable data to integrate, and then click OK.

Observable data	Configuration
ApsaraDB RDS metrics	Tag key: Specify instance tag keys to add to the metrics. The key-value pairs are automatically added as metric labels. Second-level monitoring: Integrates second-level metrics from the cloud service. Enabled by default.

After the integration, you can view entities and their observable data on the Entity Explorer or Database Observability page.

Storage policy

CloudMonitor automatically creates an SLS Logstore and a Prometheus instance to store the integrated data.

Type	Default storage location	Notes
Metrics	Prometheus instance: RegionShare:{{workspaceName}}:{{regionId}}	None
Audit logs	SLS Project: aliyun-product-data-{{userId}}-{{regionId}} SLS Logstore: rds_audit_log	None
Error and slow query logs	SLS Project: aliyun-product-data-{{userId}}-{{regionId}} SLS Logstore: slow_error_log	None
Error and slow query logs		None

Modify or delete an integration policy

To modify or delete an integration policy, go to the Integration Management page in the Integration Center. Find the policy, and then click Edit or Delete.