Supported database engines and DAS features - Database Autonomy Service

This topic describes the database engines that are supported by Database Autonomy Service (DAS) and the DAS features that are supported by different database engines. This helps you understand the features that can be used for your database instances and improves the efficiency and effectiveness of database O&M.

Supported databases in different environments

Environment	Database Type
Environment	Relational database	NoSQL database
Alibaba Cloud databases	ApsaraDB RDS for MySQL, PolarDB for MySQL, and ApsaraDB MyBase for MySQL ApsaraDB RDS for SQL Server and ApsaraDB MyBase for SQL Server ApsaraDB RDS for PostgreSQL and PolarDB for PostgreSQL PolarDB for PostgreSQL (Compatible with Oracle) databases PolarDB-X 2.0	Tair (Redis OSS-Compatible) 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 other self-managed databases	MySQL PostgreSQL	Redis MongoDB

Note

PolarDB-X 2.0 is a cloud-native distributed database service developed by Alibaba Cloud.

Features of ApsaraDB RDS instances

The following symbols are used in this section:

✔️ indicates that the feature is supported.
➖ indicates N/A.
❌ indicates that the feature is not supported.

Feature	ApsaraDB RDS for MySQL				ApsaraDB RDS for PostgreSQL		ApsaraDB RDS for SQL Server
Feature	Basic Edition	High-availability Edition	Enterprise Edition	Cluster Edition	Basic Edition	High-availability Edition	Basic Edition	High-availability Edition	Cluster Edition
Performance trends	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Monitoring dashboards	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Performance insight (new version)	❌	✔️	✔️	✔️	❌	❌	❌	❌	❌
Performance insight (original version)	❌	✔️	✔️	✔️	❌	✔️	❌	❌	❌
Real-time performance monitoring	✔️	✔️	✔️	✔️	✔️	✔️	❌	❌	❌
Autonomy center	✔️	✔️	✔️	✔️	✔️	✔️	❌	✔️	✔️
Alerting configuration	✔️	✔️	✔️	✔️	✔️	✔️	❌	❌	❌
Query governance	✔️	✔️	✔️	✔️	✔️	✔️	❌	❌	❌
Storage analysis	✔️	✔️	✔️	✔️	✔️	✔️	❌	❌	❌
Capacity assessment	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌
Session management	✔️	✔️	✔️	✔️	✔️	✔️	❌	❌	❌
10-second SQL analysis	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌
SQL throttling	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌
Lock analysis	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌
Diagnostics	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌
Diagnostic reports	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌
Parameter diagnostics	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌
SQL optimization	❌	✔️	✔️	✔️	❌	✔️	✔️	✔️	✔️
Slow query log analysis	❌	✔️	✔️	✔️	❌	✔️	✔️	✔️	✔️
Inspection and scoring	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌
Event subscription	✔️	✔️	✔️	✔️	✔️	✔️	❌	❌	❌
Automatic performance scaling	❌	✔️	✔️	❌	❌	❌	❌	❌	❌
Automatic space expansion	✔️	✔️	❌	✔️	➖	➖	✔️	✔️	✔️
Automatic storage expansion	➖	➖	❌	➖	✔️	✔️	➖	➖	➖
Prediction-based auto scaling	❌	✔️	✔️	✔️	❌	❌	❌	❌	❌
Scheduled auto scaling	❌	✔️	❌	❌	❌	❌	❌	❌	❌
Automatic scaling for local resources	❌	❌	❌	❌	❌	❌	❌	❌	❌
Automatic SQL throttling	❌	✔️	✔️	❌	❌	❌	❌	❌	❌
Automatic SQL optimization	❌	✔️	✔️	✔️	✔️	✔️	❌	❌	❌
Intelligent stress testing	✔️	✔️	✔️	❌	❌	❌	❌	❌	❌
Automatic tablespace fragment recycling	❌	✔️	✔️	✔️	❌	❌	❌	❌	❌
Search (Audit)	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
SQL Explorer	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
SQL Review	❌	✔️	✔️	✔️	❌	❌	❌	❌	❌
Security audit	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌
Traffic playback and stress testing	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌
Transaction analysis	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌
Quick transaction analysis	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌

Features of PolarDB clusters

The following symbols are used in this section:

✔️ indicates that the feature is supported.
➖ indicates N/A.
❌ indicates that the feature is not supported.

Feature	PolarDB for MySQL			PolarDB for PostgreSQL	PolarDB for PostgreSQL (Compatible with Oracle)	PolarDB-X 2.0
Feature	Cluster Edition	Single Node Edition	Multi-master Cluster (Database/Table) Edition	Enhanced Edition	Enhanced Edition	PolarDB-X 2.0
Performance trends	✔️	✔️	✔️	✔️	✔️	✔️
Monitoring dashboards	✔️	✔️	✔️	❌	❌	✔️
Performance insight (new version)	✔️	✔️	✔️	❌	❌	❌
Performance insight (original version)	✔️	✔️	✔️	✔️	✔️	❌
Real-time performance monitoring	✔️	✔️	✔️	✔️	✔️	✔️
Autonomy center	✔️	✔️	❌	❌	❌	❌
Alerting configuration	✔️	✔️	❌	❌	❌	✔️
Query governance	✔️	✔️	✔️	❌	❌	❌
Storage analysis	✔️	✔️	✔️	✔️	✔️	✔️
Capacity assessment	❌	❌	❌	❌	❌	❌
Session management	✔️	✔️	✔️	✔️	✔️	✔️
10-second SQL analysis	✔️	✔️	✔️	❌	❌	✔️
SQL throttling	✔️	✔️	✔️	❌	❌	❌
Lock analysis	✔️	✔️	✔️	❌	❌	❌
Diagnostics	❌	❌	❌	❌	❌	❌
Diagnostic reports	✔️	✔️	✔️	❌	❌	❌
SQL optimization	✔️	❌	✔️	❌	❌	❌
Slow query log analysis	✔️	✔️	✔️	✔️	✔️	✔️
Inspection and scoring	✔️	✔️	✔️	❌	❌	❌
Event subscription	✔️	✔️	❌	❌	❌	❌
Auto scaling by using DAS	✔️	✔️	❌	❌	❌	❌
Automatic space expansion	❌	❌	❌	❌	❌	❌
Automatic storage expansion	❌	❌	❌	❌	❌	❌
Prediction-based auto scaling	✔️	✔️	❌	❌	❌	❌
Scheduled auto scaling	✔️	✔️	❌	❌	❌	❌
Automatic scaling for local resources	✔️	✔️	❌	❌	❌	❌
Automatic SQL throttling.	✔️	❌	❌	❌	❌	❌
Automatic SQL optimization	✔️	❌	❌	❌	❌	❌
Intelligent stress testing	✔️	✔️	✔️	❌	❌	❌
Automatic tablespace fragment recycling	❌	❌	❌	❌	❌	❌
Search (Audit)	✔️	✔️	✔️	❌	❌	✔️
SQL Explorer	✔️	✔️	✔️	❌	❌	✔️
SQL Review	✔️	✔️	✔️	❌	❌	❌
Security audit	✔️	✔️	✔️	❌	❌	✔️
Traffic playback and stress testing	✔️	✔️	✔️	❌	❌	✔️
Transaction analysis	✔️	✔️	✔️	❌	❌	❌
Quick transaction analysis	✔️	✔️	✔️	❌	❌	❌

Features of ApsaraDB MyBase instances

The following symbols are used in this section:

✔️ indicates that the feature is supported.
➖ indicates N/A.
❌ indicates that the feature is not supported.

Feature	ApsaraDB MyBase for MySQL	ApsaraDB MyBase for SQL Server
Performance trends	✔️	✔️
Monitoring dashboards	✔️	✔️
Performance insight (new version)	✔️	❌
Performance insight (original version)	✔️	❌
Real-time performance monitoring	✔️	❌
Autonomy center	✔️	❌
Alerting configuration	✔️	❌
Query governance	✔️	❌
Storage analysis	✔️	❌
Capacity assessment	✔️	❌
Session management	✔️	❌
10-second SQL analysis	✔️	❌
SQL throttling	❌	❌
Lock analysis	✔️	❌
Diagnostics	✔️	❌
Diagnostic reports	✔️	❌
SQL optimization	✔️	✔️
Cache analysis	➖	➖
Slow query log analysis	✔️	✔️
Latency insight	➖	➖
Inspection and scoring	✔️	❌
Event subscription	✔️	❌
Auto scaling by using DAS	✔️	❌
Automatic space expansion	✔️	❌
Automatic storage expansion	❌	❌
Prediction-based auto scaling	✔️	❌
Scheduled auto scaling	✔️	❌
Automatic scaling for local resources	❌	❌
Automatic SQL throttling.	✔️	❌
Automatic SQL optimization	✔️	❌
Intelligent stress testing	✔️	❌
Automatic tablespace fragment recycling	✔️	❌
Search (Audit)	✔️	✔️
SQL Explorer	✔️	✔️
SQL Review	✔️	❌
Security audit	✔️	❌
Traffic playback and stress testing	✔️	❌
Transaction analysis	❌	❌
Quick transaction analysis	❌	❌

Features of Tair (Redis OSS-Compatible) and ApsaraDB for MongoDB instances

The following symbols are used in this section:

✔️ indicates that the feature is supported.
➖ indicates N/A.
❌ indicates that the feature is not supported.

Feature	Tair (Redis OSS-Compatible)		ApsaraDB for MongoDB
Feature	Community Edition	Enhanced Edition	Replica set and sharded cluster
Performance trends	✔️	✔️	✔️
Monitoring dashboards	✔️	✔️	✔️
Performance insight (original version)	➖	➖	➖
Real-time performance monitoring	✔️	✔️	✔️
Autonomy center	✔️	✔️	❌
Alerting configuration	✔️	✔️	✔️
Query governance	➖	➖	❌
Storage analysis	➖	➖	✔️
Capacity assessment	❌	❌	❌
Session management	✔️	✔️	✔️
10-second SQL analysis	❌	❌	❌
SQL throttling	❌	❌	❌
Lock analysis	➖	➖	➖
Diagnostics	❌	❌	❌
Diagnostic reports	✔️	✔️	❌
SQL optimization	➖	➖	❌
Cache analysis	✔️	✔️	➖
Slow query log analysis	✔️	✔️	✔️
Latency insight	✔️	✔️	➖
Inspection and scoring	✔️	✔️	❌
Event subscription	✔️	✔️	❌
Automatic bandwidth adjustment	✔️	✔️	➖
Automatic shard addition	✔️	❌	❌
Prediction-based auto scaling	✔️	✔️	❌
Scheduled auto scaling	✔️	✔️	❌
Automatic scaling for local resources	❌	❌	❌
Automatic SQL throttling	❌	❌	❌
Automatic SQL optimization	❌	❌	❌
Intelligent stress testing	❌	❌	❌
Automatic tablespace fragment recycling	❌	❌	❌
Search (Audit)	❌	❌	❌
SQL Explorer	❌	❌	❌
SQL Review	❌	❌	❌
Security audit	❌	❌	❌
Traffic playback and stress testing	❌	❌	❌
Transaction analysis	❌	❌	❌
Quick transaction analysis	❌	❌	❌

Features of self-managed databases

The following symbols are used in this section:

✔️ indicates that the feature is supported.
➖ indicates N/A.
❌ indicates that the feature is not supported.

Feature	Self-managed MySQL database	Self-managed PostgreSQL database	Self-managed Redis database	Self-managed MongoDB database
Performance trends	✔️	✔️	✔️	✔️
Monitoring dashboards	✔️	❌	✔️	✔️
Performance insight (original version)	❌	❌	❌	❌
Real-time performance monitoring	✔️	✔️	✔️	✔️
Autonomy center	❌	❌	❌	❌
Alerting configuration	✔️	❌	✔️	✔️
Query governance	❌	❌	❌	❌
Storage analysis	✔️	✔️	❌	✔️
Capacity assessment	❌	❌	❌	❌
Session management	✔️	✔️	✔️	✔️
10-second SQL analysis	❌	❌	❌	❌
SQL throttling	❌	❌	❌	❌
Lock analysis	✔️	❌	❌	❌
Diagnostics	✔️	❌	❌	❌
Diagnostic reports	❌	❌	❌	❌
SQL optimization	✔️	❌	❌	✔️
Cache analysis	➖	➖	➖	➖
Slow query log analysis	✔️	❌	❌	✔️
Latency insight	➖	➖	➖	➖
Inspection and scoring	✔️	❌	❌	❌
Event subscription	❌	❌	❌	❌
Automatic performance scaling	❌	❌	❌	❌
Automatic space expansion	❌	❌	❌	❌
Automatic storage expansion	❌	❌	❌	❌
Prediction-based auto scaling	❌	❌	❌	❌
Scheduled auto scaling	❌	❌	❌	❌
Automatic scaling for local resources	❌	❌	❌	❌
Automatic SQL throttling	❌	❌	❌	❌
Automatic SQL optimization	❌	❌	❌	❌
Intelligent stress testing	❌	❌	❌	❌
Automatic tablespace fragment recycling	❌	❌	❌	❌
Search (Audit)	❌	❌	❌	❌
SQL Explorer	❌	❌	❌	❌
SQL Review	❌	❌	❌	❌
Security audit	❌	❌	❌	❌
Traffic playback and stress testing	❌	❌	❌	❌
Transaction analysis	❌	❌	❌	❌
Quick transaction analysis	❌	❌	❌	❌