Features in PolarDB for MySQL 5.6, 5.7, and 8.0 - PolarDB

This topic describes the features available in different editions and versions of PolarDB for MySQL.

Note

Some features are subject to specific prerequisites. To use the features, make sure that the prerequisites are met. For example, some features require a minor version that is later than a specific version. For more information, see the prerequisites for the features.

Feature		PolarDB for MySQL
		MySQL 5.6	MySQL 5.7		MySQL 8.0.1			MySQL 8.0.2
		Enterprise Edition	Enterprise Edition	Standard Edition	Enterprise Edition		Standard Edition	Enterprise Edition	Standard Edition
		Cluster Edition	Cluster Edition	Standard Edition	Cluster Edition	Multi-master Cluster (Database/Table) Edition	Standard Edition	Cluster Edition	Standard Edition
Serverless		❌	✔️	✔️	✔️	❌	✔️	✔️	❌
Cluster management	Purchase an Enterprise Edition cluster and Purchase a subscription cluster	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Release a cluster	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Clone a cluster	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Enable binary logging	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Set a maintenance window	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Restart nodes	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	View or cancel a scheduled task	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	View the database storage usage	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Cluster lock feature	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Add tags	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Filter clusters by tag	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	View tags bound to a cluster	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Unbind a tag	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	View and manage scheduled events	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Data migration		✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Data synchronization		✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Account management	Register and log on to an Alibaba Cloud account	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Create and grant permissions to a RAM user	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Create and manage a database account.	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Manage the password of a database account	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Data security and encryption	Configure an IP whitelist	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Configure SSL encryption	✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️
	Configure TDE for a PolarDB cluster	✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️
	SQL firewalls	✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️
	Dynamic data masking	✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️
	PolarDB Always-confidential	✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️
PolarProxy	Manage endpoints	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Connect to a cluster.	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Private domain names	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Read/write splitting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Configure PolarProxy	✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️
	Overload protection	✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️
Database management		✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Change of cluster configurations	Manually change the specifications of a cluster	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Auto scaling for clusters that do not support serverless	✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️
	Auto scaling by using DAS	✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️
	Auto-scaling of local resources	✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️
	Add or remove read-only nodes	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Perform a temporary cluster upgrade	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Upgrade an Archive Database Standalone Edition cluster to an Archive Database Cluster Edition cluster	❌	❌	❌	✔️	❌	✔️	✔️	✔️
Cold data archiving	Enable cold data archiving	❌	❌	❌	✔️	✔️	✔️	✔️	✔️
	Archive cold data in the CSV or ORC format	❌	❌	❌	✔️	✔️	✔️	✔️	✔️
	Data lifecycle management (DLM)	❌	❌	❌	✔️	❌	✔️	✔️	✔️
High availability	Multi-zone deployment architecture	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Manually change the primary or secondary zone	✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️
	Use the cross-zone automatic switchover feature	✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️
	Multi-node deployment architecture and Automatic failover and manual failover	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Multi-master Cluster (Database/Table)	Multi-master Cluster (Database/Table)	❌	❌	❌	❌	✔️	❌	❌	❌
Multi-master Cluster (Database/Table)	Add or delete a global read-only node	❌	❌	❌	❌	✔️	❌	❌	❌
X-Engine		❌	❌	❌	✔️	❌	❌	✔️	❌
Global database networks (GDNs)	Create and release a GDN	✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️
	Manage a secondary cluster	✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️
	Connect to a GDN	✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️
Backup and restoration	Automatic backup	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Manual backup	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Full restoration: Restore data from a backup set	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Full restoration: Restore data to an earlier point in time	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Database or table restoration: Restore data from a backup set	✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️
	Database or table restoration: Restore data to an earlier point in time	✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️
	Flashback queries	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Failover with hot replica		✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️
Elastic parallel query		❌	❌	❌	✔️	❌	✔️	✔️	✔️
Parallel queries	Hash joins in parallel queries	❌	❌	❌	✔️	❌	✔️	✔️	✔️
	Use Semijoins to accelerate parallel queries	❌	❌	❌	✔️	✔️	✔️	✔️	✔️
	Use window functions to accelerate parallel queries	❌	❌	❌	✔️	❌	✔️	✔️	✔️
	Use the ROLLUP syntax to accelerate parallel queries	❌	❌	❌	✔️	✔️	✔️	✔️	✔️
IMCIs		❌	❌	❌	✔️	❌	✔️	✔️	✔️
PolarDB for AI		✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️
Cluster recycle bin	Restore a released cluster	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Delete a released cluster	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Autonomy center	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Session management	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Real-time monitoring	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Monitoring and optimization	Storage analysis	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Deadlock analysis	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Diagnostic reports	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Performance insight (original version)	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Performance insight (new version)	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Performance monitoring	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Slow SQL queries	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	SQL Explorer and Audit	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Version management	Minor version update	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Version management	Major version upgrade	✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️
Cluster parameters	Configure cluster and node parameters	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Apply a parameter template	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	High-performance parameter templates	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Transaction system optimization	CTS	❌	❌	❌	✔️	❌	✔️	✔️	❌
Transaction system optimization	Global consistency (high-performance mode)	❌	✔️	✔️	✔️	❌	✔️	✔️	❌
DDL performance optimization	Instant ADD COLUMN	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Parallel DDL	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	DDL read-ahead	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	DDL multi-way merging and sorting	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	DDL asynchronous I/O	❌	❌	❌	✔️	✔️	✔️	✔️	✔️
	Faster TRUNCATE/DROP TABLE	❌	✔️	✔️	❌	❌	❌	❌	❌
DDL stability optimization	Nonblocking DDL statements	❌	❌	❌	✔️	✔️	✔️	✔️	✔️
	DDL physical replication optimization	❌	✔️	✔️	✔️	✔️	✔️	❌	❌
	Async metadata lock replication	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Prevent long-running transactions on read-only nodes from blocking DDL operations	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
DDL ease of use optimization	Preemptive DDL	❌	❌	❌	✔️	✔️	✔️	✔️	✔️
DDL ease of use optimization	View the DDL statement execution status and MDL status	❌	❌	❌	✔️	✔️	✔️	✔️	✔️
DDL security optimization	Table recycle bin	❌	❌	❌	✔️	✔️	✔️	✔️	✔️
Partitioned tables	Modify a partitioned table	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Interval range partitioning	❌	❌	❌	✔️	❌	✔️	✔️	✔️
	Partial indexes	❌	❌	❌	✔️	❌	✔️	✔️	✔️
	GSIs	❌	❌	❌	✔️	❌	✔️	✔️	✔️
	Online partition maintenance	❌	❌	❌	✔️	❌	✔️	✔️	✔️
	Create a read-only partition	❌	❌	❌	✔️	❌	✔️	✔️	✔️
	Create a hybrid partitioned table	❌	❌	❌	✔️	❌	✔️	✔️	✔️
	Automated management of partitions	❌	❌	❌	✔️	❌	✔️	✔️	✔️
Query optimizers	Subquery folding	❌	❌	❌	❌	❌	❌	✔️	✔️
	Convert IN predicates into joins	❌	❌	❌	❌	❌	❌	✔️	✔️
	Subquery unnesting	❌	❌	❌	❌	❌	❌	✔️	✔️
	Left join elimination	❌	❌	❌	✔️	✔️	✔️	✔️	✔️
	Push down a condition from the HAVING clause to the WHERE clause	❌	❌	❌	❌	❌	❌	✔️	✔️
	WHERE to derived tables	❌	❌	❌	❌	❌	❌	✔️	✔️
	Join condition pushdown	❌	❌	❌	❌	❌	❌	✔️	✔️
	Cost-based query transformation	❌	❌	❌	❌	❌	❌	✔️	✔️
	Statement outline	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Auto plan cache	❌	❌	❌	✔️	✔️	✔️	✔️	✔️
	Adaptive execution plan switching	❌	❌	❌	✔️	✔️	✔️	❌	❌
	LIMIT OFFSET pushdown	❌	❌	❌	✔️	✔️	✔️	✔️	✔️
	Full predicate pushdown	❌	❌	❌	✔️	✔️	✔️	✔️	✔️
	Fast traverse	❌	❌	❌	✔️	✔️	✔️	✔️	✔️
	Bloom filter pushdown	❌	❌	❌	❌	❌	❌	✔️	✔️
Federated queries	Federated storage engine	❌	❌	❌	✔️	✔️	✔️	✔️	✔️
Federated queries	OSS foreign tables	❌	❌	❌	✔️	✔️	✔️	✔️	✔️
High concurrency optimization	Concurrency control	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Inventory hint	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Statement queue	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Hot row update optimization	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Thread pool	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	B-tree concurrency optimization	❌	❌	❌	✔️	✔️	✔️	✔️	✔️
Performance monitoring	Performance Agent	❌	❌	❌	❌	❌	❌	✔️	✔️
	SQL Trace	❌	❌	❌	✔️	✔️	✔️	✔️	✔️
	SQL detail	❌	❌	❌	✔️	✔️	✔️	✔️	✔️
Other features	Tenant management and resource isolation	❌	❌	❌	❌	❌	❌	✔️	✔️
	RDMA-based log shipment	❌	❌	❌	✔️	✔️	✔️	❌	❌
	Warm buffer pool	❌	❌	❌	❌	❌	❌	✔️	✔️
	Fast query cache	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Returning	❌	✔️	✔️	❌	❌	❌	❌	❌
	Partial result cache (PTRC)	❌	❌	❌	❌	❌	❌	✔️	✔️
	Readable Protobuf	❌	❌	❌	❌	❌	❌	✔️	✔️