Supported database engines and features - Database Autonomy Service

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

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
Monitoring	Performance trends	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Monitoring dashboards	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Performance insight (new version)	❌	✔️	✔️	✔️	❌	❌	❌	❌	❌
	Performance insight (previous version)	❌	✔️	✔️	✔️	❌	✔️	❌	❌	❌
	Real-time monitoring	✔️	✔️	✔️	✔️	✔️	✔️	❌	❌	❌
Event	Autonomy center	✔️	✔️	✔️	✔️	✔️	✔️	❌	✔️	✔️
Alerting	Alert configuration	✔️	✔️	✔️	✔️	✔️	✔️	❌	❌	❌
Query governance	Query governance	✔️	✔️	✔️	✔️	✔️	✔️	❌	❌	❌
Space	Storage analysis	✔️	✔️	✔️	✔️	✔️	✔️	❌	❌	❌
Space	Capacity assessment	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌
Session	Session management	✔️	✔️	✔️	✔️	✔️	✔️	❌	❌	❌
	10-second SQL analysis	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌
	SQL throttling	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌
Deadlock analysis	Deadlock analysis	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌
Diagnostics	Diagnostics	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌
	Diagnostics reports	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌
	Parameter diagnostics	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌
SQL optimization	SQL optimization	❌	✔️	✔️	✔️	❌	✔️	✔️	✔️	✔️
Slow query	Slow query log analysis	❌	✔️	✔️	✔️	❌	✔️	✔️	✔️	✔️
Inspection and scoring	Inspection and scoring	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌
Autonomy service	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	❌	✔️	✔️	✔️	❌	❌	❌	❌	❌
SQL Explorer and Audit	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	Cluster Edition	Cluster Edition	PolarDB-X 2.0
Monitoring	Performance trends	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Monitoring dashboards	✔️	✔️	✔️	✔️	❌	❌	✔️
	Performance insight (new version)	✔️	✔️	❌	✔️	❌	❌	❌
	Performance insight (previous version)	✔️	✔️	❌	✔️	✔️	✔️	❌
	Real-time monitoring	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Event	Autonomy center	✔️	❌	❌	❌	❌	❌	❌
Alerting	Alert configuration	❌	❌	❌	❌	❌	❌	✔️
Query governance	Query governance	✔️	✔️	✔️	✔️	❌	❌	❌
Space	Storage analysis	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Space	Capacity assessment	❌	❌	❌	❌	❌	❌	❌
Session	Session management	✔️	✔️	❌	✔️	✔️	✔️	✔️
	10-second SQL analysis	✔️	✔️	❌	✔️	❌	❌	✔️
	SQL throttling	✔️	✔️	❌	✔️	❌	❌	❌
Deadlock analysis	Deadlock analysis	✔️	✔️	❌	✔️	❌	❌	❌
Diagnostics	Diagnostics	❌	❌	❌	❌	❌	❌	❌
Diagnostics	Diagnostics reports	✔️	✔️	✔️	✔️	❌	❌	❌
SQL optimization	SQL optimization	✔️	✔️	❌	✔️	❌	❌	❌
Slow query	Slow query log analysis	✔️	✔️	❌	✔️	✔️	✔️	✔️
Inspection and scoring	Inspection and scoring	✔️	✔️	✔️	✔️	❌	❌	❌
Autonomy service	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	❌	❌	❌	❌	❌	❌	❌
SQL Explorer and Audit	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
Monitoring	Performance trends	✔️	✔️
	Monitoring dashboards	✔️	✔️
	Performance insight (new version)	✔️	❌
	Performance insight (previous version)	✔️	❌
	Real-time monitoring	✔️	❌
Event	Autonomy center	✔️	❌
Alerting	Alert configuration	✔️	❌
Query governance	Query governance	✔️	❌
Space	Storage analysis	✔️	❌
Space	Capacity assessment	✔️	❌
Session	Session management	✔️	❌
	10-second SQL analysis	✔️	❌
	SQL throttling	❌	❌
Deadlock analysis	Deadlock analysis	✔️	❌
Diagnostics	Diagnostics	✔️	❌
Diagnostics	Diagnostics reports	✔️	❌
SQL optimization	SQL optimization	✔️	✔️
Cache analysis	Cache analysis	➖	➖
Slow query	Slow query log analysis	✔️	✔️
Latency insight	Latency insight	➖	➖
Inspection and scoring	Inspection and scoring	✔️	❌
Autonomy service	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	✔️	❌
SQL Explorer and Audit	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		Enhanced Edition (Tair) and Community Edition	Replica set and sharded cluster
Monitoring	Performance trends	✔️	✔️
	Monitoring dashboards	✔️	✔️
	Performance insight (previous version)	➖	➖
	Real-time monitoring	✔️	✔️
Event	Autonomy center	✔️	❌
Alerting	Alert configuration	✔️	✔️
Query governance	Query governance	➖	❌
Space	Storage analysis	➖	✔️
Space	Capacity assessment	❌	❌
Session	Session management	✔️	✔️
	10-second SQL analysis	❌	❌
	SQL throttling	❌	❌
Deadlock analysis	Deadlock analysis	➖	➖
Diagnostics	Diagnostics	❌	❌
Diagnostics	Diagnostics reports	✔️	❌
SQL optimization	SQL optimization	➖	❌
Cache analysis	Cache analysis	✔️	➖
Slow query	Slow query log analysis	✔️	✔️
Latency insight	Latency insight	✔️	➖
Inspection and scoring	Inspection and scoring	✔️	❌
Autonomy service	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	❌	❌
SQL Explorer and Audit	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
Monitoring	Performance trends	✔️	✔️	✔️	✔️
	Monitoring dashboards	✔️	❌	✔️	✔️
	Performance insight (previous version)	❌	❌	❌	❌
	Real-time monitoring	✔️	✔️	✔️	✔️
Event	Autonomy center	❌	❌	❌	❌
Alerting	Alert configuration	✔️	❌	✔️	✔️
Query governance	Query governance	❌	❌	❌	❌
Space	Storage analysis	✔️	✔️	❌	✔️
Space	Capacity assessment	❌	❌	❌	❌
Session	Session management	✔️	✔️	✔️	✔️
	10-second SQL analysis	❌	❌	❌	❌
	SQL throttling	❌	❌	❌	❌
Deadlock analysis	Deadlock analysis	✔️	❌	❌	❌
Diagnostics	Diagnostics	✔️	❌	❌	❌
Diagnostics	Diagnostics reports	❌	❌	❌	❌
SQL optimization	SQL optimization	✔️	❌	❌	✔️
Cache analysis	Cache analysis	➖	➖	➖	➖
Slow query	Slow query log analysis	✔️	❌	❌	✔️
Latency insight	Latency insight	➖	➖	➖	➖
Inspection and scoring	Inspection and scoring	✔️	❌	❌	❌
Autonomy service	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	❌	❌	❌	❌
SQL Explorer and Audit	Search	❌	❌	❌	❌
	SQL Explorer	❌	❌	❌	❌
	SQL Review	❌	❌	❌	❌
	Security audit	❌	❌	❌	❌
	Traffic playback and stress testing	❌	❌	❌	❌