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 database services	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) 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 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	✔️	✔️	✔️	✔️	✔️	✔️	❌	✔️	✔️
Configure alerting	✔️	✔️	✔️	✔️	✔️	✔️	❌	❌	❌
Query governance	✔️	✔️	✔️	✔️	✔️	✔️	❌	❌	❌
Storage analysis	✔️	✔️	✔️	✔️	✔️	✔️	❌	❌	❌
Capacity assessment	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌
Session management	✔️	✔️	✔️	✔️	✔️	✔️	❌	❌	❌
10-second SQL analysis	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌
SQL throttling	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌
Deadlock 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	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
SQL Explorer	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
SQL Review	❌	✔️	✔️	✔️	❌	❌	❌	❌	❌
Security audit	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌
Traffic playback and stress testing	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌

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	X-Engine Edition	Single Node Edition	Multi-master Cluster (Database/Table) Edition	Enterprise Edition	Enterprise Edition	PolarDB-X 2.0
Performance trends	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Monitoring dashboards	✔️	✔️	✔️	✔️	❌	❌	✔️
Performance insight (new version)	✔️	✔️	❌	✔️	❌	❌	❌
Performance insight (original version)	✔️	✔️	❌	✔️	✔️	✔️	❌
Real-time performance monitoring	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Autonomy center	✔️	❌	❌	❌	❌	❌	❌
Configure alerting	❌	❌	❌	❌	❌	❌	✔️
Query governance	✔️	✔️	✔️	✔️	❌	❌	❌
Storage analysis	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Capacity assessment	❌	❌	❌	❌	❌	❌	❌
Session management	✔️	✔️	❌	✔️	✔️	✔️	✔️
10-second SQL analysis	✔️	✔️	❌	✔️	❌	❌	✔️
SQL throttling	✔️	✔️	❌	✔️	❌	❌	❌
Deadlock analysis	✔️	✔️	❌	✔️	❌	❌	❌
Diagnostics	❌	❌	❌	❌	❌	❌	❌
Diagnostic reports	✔️	✔️	✔️	✔️	❌	❌	❌
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	✔️	✔️	✔️	✔️	❌	❌	✔️
SQL Explorer	✔️	✔️	✔️	✔️	❌	❌	✔️
SQL Review	✔️	✔️	✔️	✔️	❌	❌	❌
Security audit	✔️	✔️	❌	✔️	❌	❌	✔️
Traffic playback and stress testing	✔️	✔️	❌	✔️	❌	❌	✔️

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	✔️	❌
Configure alerting	✔️	❌
Query governance	✔️	❌
Storage analysis	✔️	❌
Capacity assessment	✔️	❌
Session management	✔️	❌
10-second SQL analysis	✔️	❌
SQL throttling	❌	❌
Deadlock analysis	✔️	❌
Diagnostics	✔️	❌
Diagnostic reports	✔️	❌
SQL optimization	✔️	✔️
Cache analysis	➖	➖
Slow query log analysis	✔️	✔️
Latency insights	➖	➖
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	✔️	✔️
SQL Explorer	✔️	✔️
SQL Review	✔️	❌
Security audit	✔️	❌
Traffic playback and stress testing	✔️	❌

Features of ApsaraDB for Redis 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	ApsaraDB for Redis		ApsaraDB for MongoDB
Feature	Community Edition	Enhanced Edition (Tair)	Replica set and sharded cluster
Performance trends	✔️	✔️	✔️
Monitoring dashboards	✔️	✔️	✔️
Performance insight (original version)	➖	➖	➖
Real-time performance monitoring	✔️	✔️	✔️
Autonomy center	✔️	✔️	❌
Configure alerting	✔️	✔️	✔️
Query governance	➖	➖	❌
Storage analysis	➖	➖	✔️
Capacity assessment	❌	❌	❌
Session management	✔️	✔️	✔️
10-second SQL analysis	❌	❌	❌
SQL throttling	❌	❌	❌
Deadlock analysis	➖	➖	➖
Diagnostics	❌	❌	❌
Diagnostic reports	✔️	✔️	❌
SQL optimization	➖	➖	❌
Cache analysis	✔️	✔️	➖
Slow query log analysis	✔️	✔️	✔️
Latency insights	✔️	✔️	➖
Inspection and scoring	✔️	✔️	❌
Event subscription	✔️	✔️	❌
Automatic bandwidth adjustment	✔️	✔️	➖
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	❌	❌	❌
SQL Explorer	❌	❌	❌
SQL Review	❌	❌	❌
Security audit	❌	❌	❌
Traffic playback and stress testing	❌	❌	❌

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	❌	❌	❌	❌
Configure alerting	✔️	❌	✔️	✔️
Query governance	❌	❌	❌	❌
Storage analysis	✔️	✔️	❌	✔️
Capacity assessment	❌	❌	❌	❌
Session management	✔️	✔️	✔️	✔️
10-second SQL analysis	❌	❌	❌	❌
SQL throttling	❌	❌	❌	❌
Deadlock analysis	✔️	❌	❌	❌
Diagnostics	✔️	❌	❌	❌
Diagnostic reports	❌	❌	❌	❌
SQL optimization	✔️	❌	❌	✔️
Cache analysis	➖	➖	➖	➖
Slow query log analysis	✔️	❌	❌	✔️
Latency insights	➖	➖	➖	➖
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	❌	❌	❌	❌
SQL Explorer	❌	❌	❌	❌
SQL Review	❌	❌	❌	❌
Security audit	❌	❌	❌	❌
Traffic playback and stress testing	❌	❌	❌	❌