Features in PolarDB for MySQL 5.6, 5.7, and 8.0-PolarDB(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	Sign up for and log on to an Alibaba Cloud account	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Create and manage RAM users	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Create and manage a database account	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Manage database account passwords	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Data security and encryption	Configure an IP whitelist	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Configure SSL encryption	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
	Configure Transparent Data Encryption (TDE)	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
	SQL firewalls	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
	Dynamic data masking	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
	PolarDB Always-confidential	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
PolarProxy	Manage cluster endpoints	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Connect to a cluster	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Private domain name	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Read/write splitting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Configure a database proxy	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Overload protection	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
Database management		✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Change of cluster configurations	Manually upgrade or downgrade a cluster	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Auto scaling for clusters that do not support serverless	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
	Use DAS for automatic scaling	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
	Add or remove nodes	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Temporary upgrade	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Upgrade an Archive Database Single Node Edition to an Archive Database Cluster Edition	❌	❌	❌	✔️	❌	✔️	✔️	❌	✔️
Cold data archiving	Enable cold data archiving	❌	❌	❌	✔️	✔️	✔️	✔️	✔️	✔️
	Archive data in CSV or ORC format	❌	❌	❌	✔️	✔️	✔️	✔️	✔️	✔️
	Data lifecycle management (DLM)	❌	❌	❌	✔️	❌	✔️	✔️	❌	✔️
	OSS foreign tables	❌	❌	❌	✔️	✔️	✔️	✔️	✔️	✔️
High availability	Multi-zone deployment architecture	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Manually change the primary or secondary zone	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
	Automatically switch zones	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
	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	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
	Add and manage a secondary cluster	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
	Connect to a Global Database Network	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
Backup and restoration	Backup method 1: Automatic backup	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Create a manual backup	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Method 1 for full restoration: Restore data from a backup set	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Restore a PolarDB cluster to a specific point in time	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Method 1 for database and table restoration: Restore data from a backup set	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
	Method 2 for database and table restoration: Restore to a point in time	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
	Flashback query	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Failover with hot replica		✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
Elastic parallel query		❌	❌	❌	✔️	❌	✔️	✔️	❌	✔️
Parallel queries	Parallel acceleration for Hash Join	❌	❌	❌	❌	❌	✔️	✔️	❌	✔️
	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 performance	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Monitoring and optimization	Storage analysis	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Deadlock analysis	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Diagnostic reports	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Performance Insight (original version)	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Performance Insight (New Version)	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Performance monitoring	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Slow SQL statements	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	SQL Explorer and Audit	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Version management	Revision version	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Version management	Major version upgrades	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
Cluster parameters	Configure cluster and node parameters	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Use parameter templates	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	High-performance parameter template	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Transaction system optimization	Commit timestamp (CTS) technology	❌	❌	❌	✔️	❌	✔️	✔️	❌	❌
Transaction system optimization	PolarDB-SCC	❌	✔️	✔️	✔️	❌	✔️	✔️	❌	❌
DDL performance optimization	Instant column addition at the end of a table	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Parallel DDL	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	DDL read-ahead	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	DDL multi-way merging and sorting	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Asynchronous I/O for DDL	❌	❌	❌	✔️	✔️	✔️	✔️	✔️	✔️
	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	❌	❌	❌	✔️	❌	✔️	✔️	❌	✔️
	Global Secondary Indexes (GSIs)	❌	❌	❌	✔️	❌	✔️	✔️	❌	✔️
	Online partition maintenance	❌	❌	❌	✔️	❌	✔️	✔️	❌	✔️
	Create a read-only partition	❌	❌	❌	✔️	❌	✔️	✔️	❌	✔️
	Create hybrid partitions	❌	❌	❌	✔️	❌	✔️	✔️	❌	✔️
	Automated management of partitions	❌	❌	❌	✔️	❌	✔️	✔️	❌	✔️
Query optimizers	Subquery folding	❌	❌	❌	❌	❌	❌	✔️	❌	✔️
	Convert IN predicates into joins	❌	❌	❌	❌	❌	❌	✔️	❌	✔️
	Subquery decorrelation	❌	❌	❌	❌	❌	❌	✔️	❌	✔️
	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 hint	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Statement Queue	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Hot row 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 (PTRC)	❌	❌	❌	❌	❌	❌	✔️	❌	✔️
	Readable Protobuf	❌	❌	❌	❌	❌	❌	✔️	❌	✔️