All Products
Search
Document Center

ApsaraDB RDS:Features

Last Updated:Sep 20, 2024

This topic provides an overview of the features that are supported by ApsaraDB RDS for MySQL. In the following tables, ticks (️️️️️️️️✔️) indicate that a feature is supported, and crosses (❌) indicate that a feature is not supported.

MySQL 8.0

Category

Feature

Regular RDS instance

Serverless

RDS Cluster Edition

RDS High-availability Edition

RDS Basic Edition

RDS Basic Edition

RDS High-availability Edition

ESSD

General ESSD

Local SSD

General ESSD

ESSD

General ESSD

ESSD

ESSD

ESSD

Data migration

Data migration

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Data synchronization

Data synchronization

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Instance management

Instance creation

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Specification change

- Regular instances

- Serverless instances

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Automatic storage expansion

✔️

✔️

✔️

✔️

✔️

✔️

Automatic performance scaling

✔️

✔️

✔️

✔️

✔️

Cross-zone migration

✔️

✔️

✔️

✔️

✔️

Automatic or manual primary/secondary switchover

✔️

✔️

✔️

✔️

✔️

✔️

Query and change of the data replication mode

✔️

✔️

✔️

✔️

✔️

✔️

Usage of parameter templates

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Creation of disaster recovery instances

✔️

✔️

✔️

✔️

✔️

Instance restart

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Automatic start and stop

✔️

✔️

Instance suspension

Maintenance window setting

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Instance release

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Recycle bin

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Instance upgrade

Update of the minor engine version

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Upgrade of the major engine version

Upgrade from RDS Basic Edition to RDS Cluster Edition

✔️

✔️

Upgrade from RDS High-availability Edition to RDS Cluster Edition

✔️

✔️

Upgrade from RDS Basic Edition to RDS High-availability Edition

- Regular instances

- Serverless instances

✔️

✔️

✔️

Change the storage type from local SSD to ESSD or general ESSD

✔️

Account management

Account creation

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Custom password policies

✔️

✔️

Password reset

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Account permission modification

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Account deletion

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Reset of the permissions of privileged accounts

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Database management

Database management

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Database deletion

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Database connection management

Instance connection

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Endpoint setting

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Endpoint and port number viewing

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Public endpoint application

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Monitoring and alerting

Metric viewing

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Monitoring frequency setting

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Alert rule setting

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Network setting management

Network type change

✔️

Virtual private cloud (VPC) and vSwitch change

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Read-only instances and read/write splitting

Read-only instance creation

✔️

✔️

✔️

Read/write splitting

✔️

✔️

✔️

✔️

✔️

Change of the network type of the read/write splitting endpoint

✔️

✔️

✔️

✔️

✔️

Security management

IP address whitelist setting

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Change to the enhanced whitelist mode

SSL encryption setting

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Transparent Data Encryption (TDE) setting

✔️

Release protection

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Cloud disk encryption

✔️

✔️

✔️

✔️

✔️

Auditing

SQL Explorer

✔️

✔️

✔️

✔️

✔️

✔️

Log management

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Historical event viewing

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Database backup

Backup data

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Configuration of the backup retention policy after the instance release

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Free quota on backup storage

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Backup download

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Cross-region backup

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Data restoration

Data restoration

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Restoration of individual databases and tables

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Data restoration from a cross-region backup file

✔️

✔️

✔️

Dedicated proxy

Dedicated database proxy

✔️

✔️

✔️

✔️

✔️

Diagnosis and optimization

Database Autonomy Service (DAS)

✔️

✔️

✔️

✔️

✔️

AliSQL

AliSQL

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Tag management

Tag creation

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Tag removal

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Tag-based instance search

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Cluster node management

One primary node and multiple readable secondary nodes

✔️

✔️

Centralized management of the read/write endpoint and read-only routing endpoint

✔️

✔️

Automatic failover and manual switchover of cluster nodes

✔️

✔️

MySQL 5.7

Category

Feature

Regular RDS instance

Serverless

RDS Cluster Edition

RDS High-availability Edition

RDS Basic Edition

RDS Basic Edition

RDS High-availability Edition

ESSD

General ESSD

Local SSD

General ESSD

ESSD

General ESSD

ESSD

ESSD

ESSD

Data migration

Data migration

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Data synchronization

Data synchronization

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Instance management

Instance creation

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Specification change

- Regular instances

- Serverless instances

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Automatic storage expansion

✔️

✔️

✔️

✔️

✔️

✔️

Automatic performance scaling

✔️

✔️

✔️

✔️

✔️

Cross-zone migration

✔️

✔️

✔️

✔️

✔️

Automatic or manual primary/secondary switchover

✔️

✔️

✔️

✔️

✔️

✔️

Query and change of the data replication mode

✔️

✔️

✔️

✔️

✔️

✔️

Usage of parameter templates

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Creation of disaster recovery instances

✔️

✔️

✔️

✔️

✔️

Instance restart

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Automatic start and stop

✔️

✔️

Maintenance window setting

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Instance release

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Recycle bin

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Instance upgrade

Update of the minor engine version

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Upgrade of the major engine version

✔️

Upgrade from RDS Basic Edition to RDS High-availability Edition

- Regular instances

- Serverless instances

✔️

✔️

✔️

Upgrade from RDS Basic Edition to RDS Cluster Edition

✔️

✔️

Upgrade from RDS High-availability Edition to RDS Cluster Edition

✔️

✔️

Change the storage type from local SSD to ESSD or general ESSD

✔️

Change the storage type from ESSD to general ESSD

✔️

✔️

✔️

✔️

✔️

Account management

Account creation

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Custom password policies

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Password reset

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Account permission modification

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Account deletion

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Reset of the permissions of privileged accounts

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Database management

Database management

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Database deletion

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Database connection management

Instance connection

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Endpoint setting

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Endpoint and port number viewing

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Public endpoint application

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Monitoring and alerting

Metric viewing

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Monitoring frequency setting

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Alert rule setting

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Network setting management

Network type change

✔️

✔️

✔️

VPC and vSwitch change

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Read-only instances and read/write splitting

Read-only instance creation

✔️

✔️

✔️

Read/write splitting

✔️

✔️

✔️

✔️

✔️

Change of the network type of the read/write splitting endpoint

✔️

✔️

✔️

✔️

✔️

Security management

Whitelist setting

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Change to the enhanced whitelist mode

✔️

✔️

✔️

SSL encryption setting

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

TDE setting

✔️

Release protection

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Cloud disk encryption

✔️

✔️

✔️

✔️

✔️

Auditing

SQL Explorer

✔️

✔️

✔️

✔️

✔️

✔️

Log management

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Historical event viewing

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Database backup

Backup data

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Configuration of the backup retention policy after the instance release

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Free quota on backup storage

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Backup download

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Cross-region backup

✔️

✔️

✔️

✔️

✔️

✔️

✔️

High-frequency physical backup

✔️

Data restoration

Data restoration

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Restoration of individual databases and tables

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Data restoration from a cross-region backup file

✔️

✔️

✔️

Dedicated proxy

Dedicated database proxy

✔️

✔️

✔️

✔️

✔️

Diagnosis and optimization

DAS

✔️

✔️

✔️

✔️

✔️

AliSQL

AliSQL

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Tag management

Tag creation

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Tag removal

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Tag-based instance search

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Cluster node management

One primary node and multiple readable secondary nodes

✔️

✔️

Centralized management of the read/write endpoint and read-only routing endpoint

✔️

✔️

Automatic failover and manual switchover of cluster nodes

✔️

✔️

MySQL 5.6

Category

Feature

RDS High-availability Edition

Local SSD

Data migration

Data migration

✔️

Data synchronization

Data synchronization

✔️

Instance management

Instance creation

✔️

Specification change

✔️

Automatic storage expansion

Automatic performance scaling

✔️

Cross-zone migration

✔️

Automatic or manual primary/secondary switchover

✔️

Query and change of the data replication mode

✔️

Usage of parameter templates

✔️

Creation of disaster recovery instances

✔️

Instance restart

✔️

Maintenance window setting

✔️

Instance release

✔️

Recycle bin

✔️

Instance upgrade

Update of the minor engine version

✔️

Upgrade of the major engine version

✔️

Account management

Account creation

✔️

Password reset

✔️

Account permission modification

✔️

Account deletion

✔️

Reset of the permissions of privileged accounts

✔️

Custom password policies

Database management

Database management

✔️

Database deletion

✔️

Database connection management

Instance connection

✔️

Endpoint setting

✔️

Endpoint and port number viewing

✔️

Public endpoint application

✔️

Monitoring and alerting

Metric viewing

✔️

Monitoring frequency setting

✔️

Alert rule setting

✔️

Network setting management

Network type change

✔️

VPC and vSwitch change

✔️

Read-only instances and read/write splitting

Read-only instance creation

✔️

Read/write splitting

✔️

Change of the network type of the read/write splitting endpoint

✔️

Security management

Whitelist setting

✔️

Change to the enhanced whitelist mode

✔️

SSL encryption setting

✔️

TDE setting

✔️

Release protection

✔️

Cloud disk encryption

Auditing

SQL Explorer

✔️

Log management

✔️

Historical event viewing

✔️

Database backup

Backup data

✔️

Configuration of the backup retention policy after the instance release

✔️

Free quota on backup storage

✔️

Backup download

✔️

Cross-region backup

✔️

Data restoration

Data restoration

✔️

Restoration of individual databases and tables

✔️

Data restoration from a cross-region backup file

✔️

Dedicated proxy

Dedicated database proxy

Diagnosis and optimization

DAS

✔️

AliSQL

AliSQL

✔️

Tag management

Tag creation

✔️

Tag removal

✔️

Tag-based instance search

✔️