Database Autonomy Service:Enable autonomy features

Database Autonomy Service (DAS) provides 24/7 anomaly detection based on machine learning and fine-grained monitoring data. You can enable various autonomy features such as automatic SQL optimization, automatic SQL throttling, automatic storage expansion, and auto scaling of computing resources. These features support a closed-loop diagnostic process. This helps you detect anomalies, analyze root causes, mitigate loss or optimize performance, track effects, perform rollback operations, and add knowledge to the knowledge base. The effect of performance optimization can also be quantified. This way, DAS ensures the service continuity of databases. This topic describes how to enable the autonomy features of DAS for an ApsaraDB RDS for MySQL instance.

Enable autonomy features

1. Log on to the DAS console.

2. In the left-side navigation pane, click Instance Monitoring.

3. On the page that appears, find the database instance that you want to manage and click the instance ID. The instance details page appears.

4. In the left-side navigation pane, click Autonomy Center.

5. On the Autonomy Center page, click Autonomy Service Settings in the upper-right corner.

   

6. On the Autonomous Function Settings tab of the Autonomous Function Management panel, turn on Enable Autonomy Service.

7. On the Optimization and Throttling tab, enable autonomy features based on your business requirements.

   Note

   DAS provides varied autonomy features for different database engines. For more information, see Supported database engines and features.

   • If you select Auto Index Creation and Deletion and SQL Diagnostics and Automatic Index Creation, DAS performs automatic diagnostics on SQL statements, provides index optimization suggestions, and then creates indexes on your database instance based on the suggestions. For more information, see Automatic SQL optimization.

   • If you select Automatic Throttling and configure the relevant parameters, DAS triggers automatic SQL throttling if the conditions that you specify are met. For more information, see Configure automatic SQL throttling.

   • If you select Automatic Space Expansion and configure the relevant parameters, DAS automatically expands the storage space if the storage space is insufficient. For more information, see Automatic space expansion.

   • If you select Automatic Performance Scaling and configure the relevant parameters, DAS automatically scales up or down the database instance based on the average CPU utilization of the database instance. For more information, see Automatic performance scaling.

8. On the Auto Scaling tab, create a policy and configure the relevant parameters. After you apply the policy to the database instance, DAS provides suggestions for scaling up or down the database instance based on the policy and automatically scales up or down the database instance when the instance performance reaches the specified threshold. For more information, see Auto scaling.

   Note

   DAS provides varied auto scaling features for different database engines. For more information, see Supported database engines and features.

9. Click OK to save the configurations.

View the autonomy results

1. Log on to the DAS console.

2. In the left-side navigation pane, click Instance Monitoring.

3. On the page that appears, find the database instance that you want to manage and click the instance ID. The instance details page appears.

4. In the left-side navigation pane, click Autonomy Center.

5. On the Autonomy Center page, select a time range to view the events that occur within the specified time range.

   To view the details of an event, click Details in the Actions column of the event.