Features of ApsaraDB RDS for MySQL - ApsaraDB RDS - Alibaba Cloud Documentation Center

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 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	❌	❌	✔️	❌	❌	❌	❌	❌	❌
Network setting management	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 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	❌	❌	✔️	❌	❌	✔️	✔️	❌	❌
Network setting management	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
Category	Feature	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	✔️
Instance upgrade	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 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	✔️
Network setting management	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	✔️