All Products
Search
Document Center

Database Autonomy Service:Supported database engines and features

Last Updated:Sep 12, 2024

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

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

  • 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

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 (previous version)

✔️

✔️

✔️

✔️

Real-time performance monitoring

✔️

✔️

✔️

✔️

✔️

✔️

Autonomy center

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Alerting configuration

✔️

✔️

✔️

✔️

✔️

✔️

Query governance

✔️

✔️

✔️

✔️

✔️

✔️

Storage analysis

✔️

✔️

✔️

✔️

✔️

✔️

Capacity assessment

✔️

✔️

✔️

✔️

Instance session management

✔️

✔️

✔️

✔️

✔️

✔️

10-second SQL analysis

✔️

✔️

✔️

✔️

SQL throttling

✔️

✔️

✔️

✔️

Lock analysis

✔️

✔️

✔️

✔️

Quick diagnostics

✔️

✔️

✔️

✔️

Diagnostics 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 and Audit

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

SQL Review

✔️

✔️

✔️

Security audit (previous version)

✔️

✔️

✔️

✔️

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

Cluster Edition

X-Engine Edition

Single Node Edition

Multi-master Cluster (Database/Table) Edition

Enterprise Edition

Enterprise Edition

Performance trends

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Monitoring dashboards

✔️

✔️

✔️

✔️

✔️

Performance insight (new version)

✔️

✔️

✔️

✔️

Performance insight (previous version)

✔️

✔️

✔️

✔️

✔️

✔️

Real-time performance monitoring

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Autonomy center

✔️

✔️

Alerting configuration

✔️

✔️

✔️

✔️

Query governance

✔️

✔️

✔️

✔️

Storage analysis

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Capacity assessment

Instance session management

✔️

✔️

✔️

✔️

✔️

✔️

✔️

10-second SQL analysis

✔️

✔️

✔️

✔️

✔️

SQL throttling

✔️

✔️

✔️

✔️

Lock analysis

✔️

✔️

✔️

✔️

Quick diagnostics

Diagnostics 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 (Audit)

✔️

✔️

✔️

✔️

✔️

SQL Explorer and Audit

✔️

✔️

✔️

✔️

✔️

SQL Review

✔️

✔️

✔️

✔️

Security audit (previous version)

✔️

✔️

✔️

✔️

✔️

Traffic playback and stress testing

✔️

✔️

✔️

✔️

✔️

Transaction analysis

✔️

✔️

✔️

✔️

Quick transaction analysis

✔️

✔️

✔️

✔️

Features of ApsaraDB MyBase instances

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

Community Edition

Enterprise Edition

Replica set and sharded cluster

Performance trends

✔️

✔️

✔️

Monitoring dashboards

✔️

✔️

✔️

Performance insight (previous version)

Real-time performance monitoring

✔️

✔️

✔️

Autonomy center

✔️

✔️

Alerting configuration

✔️

✔️

✔️

Query governance

Storage analysis

✔️

Capacity assessment

Instance session management

✔️

✔️

✔️

10-second SQL analysis

SQL throttling

Lock analysis

Quick diagnostics

Diagnostics 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 (previous version)

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 (previous version)

Real-time performance monitoring

✔️

✔️

✔️

✔️

Autonomy center

Alerting configuration

✔️

✔️

✔️

Query governance

Storage analysis

✔️

✔️

✔️

Capacity assessment

Instance session management

✔️

✔️

✔️

✔️

10-second SQL analysis

SQL throttling

Lock analysis

✔️

Quick diagnostics

✔️

Diagnostics 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 (previous version)

Traffic playback and stress testing

Transaction analysis

Quick transaction analysis