DAS feature support for different database engines - Database Autonomy Service

Database Autonomy Service (DAS) es compatible con diversas bases de datos relacionales y NoSQL en servicios administrados de Alibaba Cloud, bases de datos autoadministradas en instancias de Elastic Compute Service (ECS) y bases de datos de otros proveedores de nube. Consulte esta página para identificar las funciones disponibles según su motor de base de datos y tipo de instancia.

Bases de datos compatibles

Entorno	Bases de datos relacionales	Bases de datos NoSQL
Bases de datos administradas de Alibaba Cloud	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
Autoadministradas en ECS	MySQL, PostgreSQL	Redis, MongoDB
Otras nubes o autoadministradas	MySQL, PostgreSQL	Redis, MongoDB

PolarDB-X 2.0 es un servicio de base de datos distribuida nativa de la nube desarrollado por Alibaba Cloud.

Leyenda de símbolos

Símbolo	Significado
✓	Compatible
—	No aplica
✗	No compatible

Funciones de las instancias de ApsaraDB RDS

Función	ApsaraDB RDS for MySQL				ApsaraDB RDS for PostgreSQL		ApsaraDB RDS for SQL Server
Función	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	✓	✓	✓	✓	✗	✗	✗	✗	✗

Funciones de los clústeres de PolarDB

Función	PolarDB for MySQL			PolarDB for PostgreSQL	PolarDB for PostgreSQL (Compatible with Oracle)	PolarDB-X 2.0
Función	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	✔️	✔️	✔️	✔️	✔️	✔️

Funciones de las instancias de ApsaraDB MyBase

Función	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	✗	✗

Funciones de instancias de Tair (compatible con Redis OSS) y ApsaraDB for MongoDB

Función	Tair (compatible con Redis OSS)		ApsaraDB for MongoDB
Función	Redis Open-Source Edition	Enterprise Edition	Conjunto de réplicas y clúster fragmentado
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	✗	✗	✗

Funciones de bases de datos MySQL, PostgreSQL, Redis y MongoDB autogestionadas

Función	MySQL autogestionado	PostgreSQL autogestionado	Redis autogestionado	MongoDB autogestionado
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:Motores de base de datos y funciones compatibles