This topic describes the database engines and features that are supported by Database Autonomy Service (DAS).

Supported databases in different environments

Environment Database type
Relational database NoSQL database
Alibaba Cloud database services
  • ApsaraDB RDS for MySQL and PolarDB for MySQL
  • ApsaraDB RDS for SQL Server
  • ApsaraDB RDS for PostgreSQL and PolarDB for PostgreSQL
  • PolarDB for Oracle
  • PolarDB-X 2.0
  • ApsaraDB for Redis
  • ApsaraDB for MongoDB
Self-managed databases that are deployed on Alibaba Cloud Elastic Compute Service (ECS) instances
  • MySQL
  • PostgreSQL
  • Redis
  • MongoDB
Databases from other cloud service providers or self-managed databases
  • MySQL
  • PostgreSQL
  • Redis
  • MongoDB

Features of relational databases

This section describes the symbols that are used in the tables in this topic.
  • ️✔️ indicates that the feature is supported.
  • ➖ indicates N/A.
  • ❌ indicates that the feature is not supported.
Note The Basic Edition instances of ApsaraDB RDS for MySQL and ApsaraDB RDS for PostgreSQL do not support the following features. You do not need to use the related user interfaces (UIs) in the console.
Feature ApsaraDB RDS for MySQL ApsaraDB RDS for SQL Server ApsaraDB RDS for PostgreSQL PolarDB for MySQL PolarDB for Oracle and PolarDB for PostgreSQL PolarDB-X 2.0 Self-managed MySQL database Self-managed PostgreSQL database
High-availability Edition Enterprise Edition Cluster Edition High-availability Edition Cluster Edition Archive Database Edition Single Node Edition Cluster Edition
Monitoring Performance trends ️✔️ ️️✔️ ️️✔️ ️️✔️ ️️✔️ ️️✔️ ️️✔️ ️️✔️ ️️✔️ ️️✔️ ️️✔️
Monitoring dashboards ️️✔️ ️️✔️ ️️✔️ ️️✔️ ️️✔️ ️️✔️ ️️✔️ ️️️✔️ ️️️️✔️
Performance insight ️️️✔️ ️️️️✔️ ️️️✔️ ️️️️✔️ ️️️️✔️ ️️️️✔️
Performance snapshots ️️️✔️ ️️️️✔️
Real-time monitoring ️️️✔️ ️️️️✔️ ️️️✔️ ️️️️✔️ ️️️️✔️ ️️️️✔️ ️️️️✔️ ️️️️✔️ ️️️️✔️ ️️️️✔️
Event Autonomy center ️️️✔️ ️️️️✔️ ️️️✔️ ️️️️✔️
Alert Configure an alert ️✔️ ️️✔️ ️️✔️ ️✔️ ️️✔️
Query governance Query governance ️✔️ ️️✔️ ️✔️ ️️✔️ ️️✔️ ️️✔️
Space Storage analysis ️✔️ ️️✔️ ️✔️ ️️✔️ ️️✔️ ️✔️ ️✔️ ️️✔️ ️️✔️ ️️✔️
Capacity assessment ️️✔️ ️️✔️
Session Session management ️✔️ ️️✔️ ️✔️ ️️✔️ ️️✔️ ️✔️ ️️✔️ ️️✔️ ️️✔️
10-second SQL analysis ️️✔️ ️️✔️ ️✔️ ️️✔️ ️️✔️
Deadlock analysis Deadlock analysis ️✔️ ️️✔️ ️✔️ ️️✔️ ️️✔️
Diagnostics Diagnostics ️✔️ ️️✔️ ️️✔️
Diagnostic reports ️✔️ ️️✔️ ️✔️ ️️✔️ ️️✔️
Performance trends ️✔️ ️️✔️ ️✔️ ️️✔️ ️️✔️ ️️✔️ ️️✔️ ️️✔️ ️️✔️
SQL optimization SQL optimization ️✔️ ️️✔️ ️️✔️ ️️✔️ ️️✔️ ️️✔️ ️️✔️
Slow SQL query Slow query log analysis ️✔️ ️️✔️ ️️✔️ ️️✔️ ️️✔️ ️️✔️ ️✔️ ️️✔️
Inspection and scoring Inspection and scoring ️✔️ ️️✔️ ️✔️ ️✔️ ️✔️ ️✔️
Autonomy service Event subscription service ️✔️ ️️✔️ ️✔️ ️️✔️
Automatic storage expansion ️✔️ ️️✔️
Automatic performance scaling ️✔️ ️️✔️ ️✔️ ️️✔️
Prediction-based auto scaling ️✔️ ️️✔️ ️✔️ ️️✔️ ️️✔️
Scheduled auto scaling ✔️ ️️✔️
Automatic scaling for local resources ️️✔️
24/7 anomaly detection ️✔️ ️️✔️ ️✔️ ️️✔️
Automatic SQL throttling ️✔️ ️️✔️ ️✔️ ️️✔️
Automatic SQL optimization ️✔️ ️️✔️ ️✔️ ️️✔️
Intelligent stress testing ️✔️ ️️✔️ ️✔️ ️️✔️
Automatic parameter tuning ️✔️ ️️✔️
Automatic tablespace fragment recycling ️✔️ ️️✔️
Abnormal SQL request identification ️✔️ ️️✔️
SQL Explorer and Audit Search ️✔️ ️️✔️ ️️✔️ ️️✔️ ️️✔️ ️️✔️ ️️✔️ ️️✔️
SQL Explorer ️✔️ ️️✔️ ️️✔️ ️️✔️ ️️✔️ ️️✔️ ️️✔️ ️️✔️
Security audit ️✔️ ️️✔️ ️✔️ ️️✔️ ️️✔️
Traffic playback and stress testing ️✔️ ️️✔️ ️✔️ ️️✔️ ️️✔️

Features of NoSQL databases

Feature Redis MongoDB Self-managed Redis database Self-managed MongoDB database
Enhanced Edition (Tair) and Community Edition Replica set and sharded cluster
Monitoring Performance trends ️✔️ ️️✔️ ️️✔️ ️️✔️
Monitoring dashboards ️️✔️ ️️✔️ ️️✔️ ️️✔️
Performance insight
Performance snapshots
Real-time monitoring ✔️ ️️✔️ ️️✔️ ️️✔️
Event Autonomy center ️️✔️
Alert Configure an alert ️✔️ ️️✔️ ️️✔️ ️️✔️
Query governance Query governance
Space Storage analysis
Capacity assessment
Session Instance sessions ️✔️ ️️✔️ ️️✔️ ️️✔️
10-second SQL analysis
Deadlock analysis Deadlock analysis
Diagnostics Diagnostics
Diagnostic reports ️✔️ ️️✔️
Performance trends ️✔️ ️️✔️
SQL optimization SQL optimization ✔️
Cache analysis Cache analysis ️️✔️
Slow query Slow query log analysis ️✔️ ️️✔️
Cache analysis Cache analysis ️️✔️
Latency insight Latency insight ️️✔️
Inspection and scoring Inspection and scoring ️️✔️
Autonomy service Event subscription service ️️✔️
Automatic storage expansion
Automatic performance scaling ✔️️️
Prediction-based auto scaling ️️✔️
Scheduled auto scaling ️️✔️
Automatic scaling for local resources
24/7 anomaly detection ️️✔️
Automatic SQL throttling
Automatic SQL optimization
Intelligent stress testing
Automatic parameter tuning
Automatic tablespace fragment recycling
Abnormal SQL request identification
SQL Explorer and Audit Search
SQL Explorer
Security audit
Traffic playback and stress testing