DAS feature support for different database engines-Database Autonomy Service(DAS)-阿里云帮助中心

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	RDS MySQL				RDS PostgreSQL			RDS SQL Server
Feature	Basic Edition	High-availability Series	RDS Enterprise Edition	Cluster Edition	Basic Edition	High-availability Series	Cluster Edition	Basic Edition	High-availability Series	Cluster Edition
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	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌	❌
Parameter Diagnostics	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌	❌
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	❌	✔️	✔️	✔️	✔️	✔️	✔️	❌	❌	❌
Traffic playback and stress testing	✔️	✔️	✔️	❌	❌	❌	❌	❌	❌	❌
Automatic fragment reclamation	❌	✔️	✔️	✔️	❌	❌	❌	❌	❌	❌
Audit	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
SQL Explorer	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
SQL Review	❌	✔️	✔️	✔️	❌	❌	❌	❌	❌	❌
Security Audit (Old Version)	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌	❌
Security Audit (New Version)	✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️	✔️	✔️
Traffic playback and stress testing	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌	❌
Transaction Analysis	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌	❌
Quick Transaction Analysis	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌	❌
Sensitive data detection	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Column Encryption	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️

Features of PolarDB clusters

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	✓	✓	✓	✗	✗	✗
Overview of 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	✓	✗	✗	✗	✗	✗
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 ApsaraDB MyBase instances

Feature	MyBase for MySQL	MyBase for SQL Server	MyBase for Redis
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	✔️	✔️	➖
Cache Analysis	➖	➖	✔️
Slow Query Log	✔️	✔️	✔️
Latency Insight	➖	➖	✔️
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 (Legacy)	✔️	❌	❌
Traffic playback and stress testing	✔️	❌	❌
Transaction analysis	❌	❌	❌
Quick transaction analysis	No	Incorrect	❌

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

Feature	Tair (Redis OSS-compatible)		ApsaraDB for MongoDB
Feature	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	✗	✗	✗	✗

Supported database engines and features