Supported database engines and available features - Database Autonomy Service

Database Autonomy Service (DAS) supports a range of relational and NoSQL databases across Alibaba Cloud managed services, self-managed databases on Elastic Compute Service (ECS) instances, and databases from other cloud providers. Use this page to find the features available for your database engine and instance type.

Supported databases

Environment	Relational databases	NoSQL databases
Alibaba Cloud managed databases	ApsaraDB RDS for MySQL, PolarDB for MySQL, ApsaraDB MyBase for MySQL; ApsaraDB RDS for SQL Server, ApsaraDB MyBase for SQL Server; ApsaraDB RDS for PostgreSQL, PolarDB for PostgreSQL; PolarDB for PostgreSQL (Compatible with Oracle); PolarDB-X 2.0	Tair (Redis OSS-compatible), ApsaraDB for MongoDB
Self-managed on ECS	MySQL, PostgreSQL	Redis, MongoDB
Other clouds or self-managed	MySQL, PostgreSQL	Redis, MongoDB

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

Symbol legend

Symbol	Meaning
✓	Supported
—	Not applicable
✗	Not supported

Features of ApsaraDB RDS instances

Feature	ApsaraDB RDS for MySQL	ApsaraDB RDS for PostgreSQL	ApsaraDB RDS for SQL Server
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	✓	✓	✓	✓	✗	✗	✗	✗	✗
Overview of 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	✗	✓	✓	✓	✓	✓	✗	✗	✗
Traffic playback and stress testing	✓	✓	✓	✗	✗	✗	✗	✗	✗
Automatic tablespace fragment recycling	✗	✓	✓	✓	✗	✗	✗	✗	✗
Audit	✓	✓	✓	✓	✓	✓	✓	✓	✓
SQL Explorer	✓	✓	✓	✓	✓	✓	✓	✓	✓
SQL Review	✗	✓	✓	✓	✗	✗	✗	✗	✗
Security audit (new version)	✓	✓	✓	✓	✓	✓	✓	✓	✓
Security audit (original version)	✓	✓	✓	✓	✗	✗	✗	✗	✗
Traffic playback and stress testing	✓	✓	✓	✓	✗	✗	✗	✗	✗
Transaction analysis	✓	✓	✓	✓	✗	✗	✗	✗	✗
Quick transaction analysis	✓	✓	✓	✓	✗	✗	✗	✗	✗

Features of PolarDB clusters

Feature	PolarDB for MySQL			PolarDB for PostgreSQL	PolarDB for PostgreSQL (Compatible with Oracle)	PolarDB-X 2.0
Feature	Enterprise Edition (Cluster)	Enterprise Edition (Single Node)	Enterprise Edition Multi-master Cluster (Database/Table)	Enterprise Edition	Enterprise Edition	PolarDB-X 2.0
Performance Trend	✔️	✔️	✔️	✔️	✔️	✔️
Dashboard	✔️	✔️	✔️	❌	❌	✔️
Performance Insight (New Version)	✔️	✔️	✔️	❌	❌	❌
Performance Insight (Old Version)	✔️	✔️	✔️	✔️	✔️	❌
Real-Time Performance	✔️	✔️	✔️	✔️	✔️	✔️
Autonomy Center	✔️	✔️	❌	❌	❌	❌
Configure Alerting	✔️	✔️	❌	❌	❌	✔️
Query Governance	✔️	✔️	✔️	❌	❌	❌
Storage Analysis	✔️	✔️	✔️	✔️	✔️	✔️
Capacity Assessment	❌	❌	❌	❌	❌	❌
Instance Session	✔️	✔️	✔️	✔️	✔️	✔️
10-Second SQL Analysis	✔️	✔️	✔️	❌	❌	✔️
SQL Throttling	✔️	✔️	✔️	❌	❌	❌
Lock analysis	✔️	✔️	✔️	❌	❌	❌
Quick Diagnostics	❌	❌	❌	❌	❌	❌
Diagnostic Report	✔️	✔️	✔️	❌	❌	❌
SQL Optimization	✔️	❌	✔️	❌	❌	❌
Slow Query Log	✔️	✔️	✔️	✔️	✔️	✔️
Inspection and Scoring	✔️	✔️	✔️	❌	❌	❌
Event Subscription Service	✔️	✔️	❌	❌	❌	❌
Automatic scaling for performance optimization	✔️	✔️	❌	❌	❌	❌
Automatic space expansion	❌	❌	❌	❌	❌	❌
Automatic storage scaling	❌	❌	❌	❌	❌	❌
Prediction-based auto scaling	✔️	✔️	❌	❌	❌	❌
Scheduled auto scaling	✔️	✔️	❌	❌	❌	❌
Automatic scaling for local resources	✔️	✔️	❌	❌	❌	❌
Automatic SQL throttling	✔️	❌	❌	❌	❌	❌
Automatic SQL optimization	✔️	❌	❌	❌	❌	❌
Create a traffic playback and stress testing task	✔️	✔️	✔️	❌	❌	❌
Automatic fragment reclamation	❌	❌	❌	❌	❌	❌
Audit	✔️	✔️	✔️	❌	❌	✔️
SQL Explorer	✔️	✔️	✔️	❌	❌	✔️
SQL Review	✔️	✔️	✔️	❌	❌	❌
Security Audit (New Version)	✔️	✔️	✔️	❌	❌	❌
Security Audit (Old Version)	✔️	✔️	✔️	❌	❌	✔️
Traffic playback and stress testing	✔️	✔️	✔️	❌	❌	✔️
Transaction Analysis	✔️	✔️	✔️	❌	❌	❌
Quick Transaction Analysis	✔️	✔️	✔️	❌	❌	❌
Sensitive data detection	✔️	✔️	✔️	✔️	✔️	✔️
Column Encryption	✔️	✔️	✔️	✔️	✔️	✔️

Features of ApsaraDB MyBase instances

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	✗	✗
Overview of 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	✓	✗
Traffic playback and stress testing	✓	✗
Automatic tablespace fragment recycling	✓	✗
Audit	✓	✓
SQL Explorer	✓	✓
SQL Review	✓	✗
Security audit (original version)	✓	✗
Traffic playback and stress testing	✓	✗
Transaction analysis	✗	✗
Quick transaction analysis	✗	✗

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

Feature	Tair (Redis OSS-compatible)	ApsaraDB for MongoDB
Redis Open-Source Edition	Enterprise 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	✗	✗	✗
Overview of 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	✗	✗	✗
Traffic playback and stress testing	✗	✗	✗
Automatic tablespace fragment recycling	✗	✗	✗
Audit	✗	✗	✗
SQL Explorer	✗	✗	✗
SQL Review	✗	✗	✗
Security audit (original version)	✗	✗	✗
Traffic playback and stress testing	✗	✗	✗
Transaction analysis	✗	✗	✗
Quick transaction analysis	✗	✗	✗

Features of self-managed MySQL, PostgreSQL, Redis, and MongoDB databases

Feature	Self-managed MySQL	Self-managed PostgreSQL	Self-managed Redis	Self-managed MongoDB
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	✗	✗	✗	✗
Overview of 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	✗	✗	✗	✗
Traffic playback and stress testing	✗	✗	✗	✗
Automatic tablespace fragment recycling	✗	✗	✗	✗
Audit	✗	✗	✗	✗
SQL Explorer	✗	✗	✗	✗
SQL Review	✗	✗	✗	✗
Security audit (original version)	✗	✗	✗	✗
Traffic playback and stress testing	✗	✗	✗	✗
Transaction analysis	✗	✗	✗	✗
Quick transaction analysis	✗	✗	✗	✗

Database Autonomy Service:Supported database engines and features