Database Autonomy Service (DAS) is a cloud service that uses machine learning and expert experience to automate perception, healing, optimization, operations and maintenance (O&M), and security for databases. It simplifies database management and eliminates service failures that may be caused by manual operations. This allows you to ensure the stability, security, and efficiency of your database service.

Feature description

In ApsaraDB RDS for MySQL, DAS provides the following features:

  • Use the diagnostics feature for an ApsaraDB RDS for MySQL instance

    You can diagnose your ApsaraDB RDS for MySQL instance and view the diagnosis results.

  • Autonomy center

    You can specify a time range and view events such as exception events, optimization events, and auto scaling events over the specified time range. If DAS detects exceptions on crucial metrics, it diagnoses the related sessions, SQL statements, and storage capacity to identify possible causes. DAS also provides optimization or mitigation suggestions. After you confirm the suggestions, DAS implements the suggestions to resolve the exceptions.

  • Session management

    You can view sessions, check session statistics, analyze SQL statements, and optimize the execution of SQL statements.

  • Real-time monitoring

    You can view the real-time information of your RDS instance, such as the queries per second (QPS), transactions per second (TPS), number of connections, and network traffic.

  • Storage analysis

    You can view the storage usage, storage usage trend, exception events, tablespaces, and data spaces of your RDS instance.

  • Capacity assessment

    You can view the capacity suggestions, performance capacity, storage usage, and remaining time of your RDS instance. In addition, this feature can use machine learning and capacity algorithms to predict storage usage.

  • Deadlock analysis
  • Use the performance insight feature for an ApsaraDB RDS for PostgreSQL instance

    You can evaluate the loads of your RDS instance and identify the root causes of performance issues. This allows you to improve the stability of your RDS instance.

  • Use the dashboard feature for an ApsaraDB RDS for MySQL instance

    You can view and compare performance trends, customize monitoring dashboards, view exception diagnosis results, and view instance topologies.

  • Use the slow query log analysis feature for an ApsaraDB RDS for MySQL instance

    You can view the trends and statistics of slow queries.

  • Full SQL statistics

    You can view and compare the number of execution times, execution duration, and execution duration distribution of each SQL statement over a specific time range. This allows you to identify problem SQL statements.

  • Report

    You can generate diagnosis reports or view automatically generated reports about instance health, alerts, and slow queries.

Authorization description

If you activate DAS for your RDS instance, you can attach the AliyunHDMReadOnlyAccess or AliyunHDMFullAccess policy to RAM users. AliyunHDMReadOnlyAccess: specifies the read-only permissions on DAS. AliyunHDMFullAccess: specifies read and write permissions on DAS. If you want to grant only the query permissions to a RAM user, you can attach the following policy to the RAM user:
{
           
            "Action": [
                "hdm:Get*",
                
                "hdm:Describe*",
                
                "hdm:Query*",
                
                "hdm:Support*"
            
            ],
            
                "Effect": "Allow",
            
                "Resource": "acs:rds:*:*:*"
        
}