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

This topic describes the features available in PolarDB for MySQL 5.6, 5.7, and 8.0.

Note

Some features require specific prerequisites to be met, such as requiring a specific database engine revision version or later. For more information, see the prerequisites for each feature.

The following table describes the compatibility of features with various PolarDB for MySQL versions and editions, where ✔️ means compatible and ❌ means incompatible.

Feature		PolarDB for MySQL
		PolarDB for MySQL 5.6	PolarDB for MySQL 5.7		PolarDB for MySQL 8.0.1			PolarDB for 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 (Limitless) Edition	Standard Edition	Cluster Edition	Multi-master Cluster (Limitless) Edition	Standard Edition
Serverless		❌	✔️	✔️	✔️	❌	✔️	✔️	❌	❌
Cluster management	Custom purchase and Purchase a subscription cluster	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Release a cluster	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Clone a cluster	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Enable binary logging	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Set a maintenance window	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Manage 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 the endpoints of a cluster	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	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	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
	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	❌	❌	❌	✔️	✔️	✔️	✔️	✔️	✔️
	Manually archive cold data in the CSV format	❌	❌	❌	✔️	✔️	✔️	✔️	✔️	✔️
	Data lifecycle management (DLM)	❌	❌	❌	✔️	❌	✔️	✔️	❌	✔️
	OSS foreign tables	❌	❌	❌	✔️	✔️	✔️	✔️	✔️	✔️
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 (Limitless) Edition	Multi-master Cluster (Limitless)	❌	❌	❌	❌	✔️	❌	❌	✔️	❌
Multi-master Cluster (Limitless) Edition	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	Backup method 1: Automatic backup	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Backup method 2: Manual backup	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Method 1 for full restoration: Restore data from a backup set	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Method 2 for full restoration: Restore data to an earlier point in time	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Method 1 for database and table restoration: Restore data from a backup set	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
	Method 2 for database and 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)	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Performance monitoring	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Slow SQL queries	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	️SQL Explorer and Audit	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Version management	Revision version	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Version management	Major version upgrades	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
Cluster parameters	Configure cluster and node parameters	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Apply a parameter template	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	High-performance parameter templates	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Transaction system optimization	CTS	❌	❌	❌	✔️	❌	✔️	✔️	❌	❌
Transaction system optimization	PolarDB-SCC	❌	✔️	✔️	✔️	❌	✔️	✔️	❌	❌
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	❌	❌	❌	❌	❌	❌	✔️	❌	✔️
	Push down a condition from the WHERE clause 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	❌	❌	❌	❌	❌	❌	✔️	❌	✔️
High concurrency optimization	Concurrency control	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Inventory hints	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Statement queue	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Hot row update optimization	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Thread pool	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	B-tree concurrency control 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	❌	❌	❌	❌	❌	❌	✔️	❌	✔️
	Readable Protobuf	❌	❌	❌	❌	❌	❌	✔️	❌	✔️