Feature details for PolarDB for MySQL engine versions-PolarDB(PolarDB)-阿里云帮助中心

This topic describes the features available in PolarDB for MySQL for your reference.

Note

PolarDBDatabase engine: among the features supported by various versions,some features have specific prerequisites. For example, a specific minor engine version or later may be required. For more information, see the prerequisites described in each feature topic.

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 (Limitless) Edition	Standard Edition	Cluster Edition	Multi-master Cluster (Limitless) Edition	Standard Edition
Serverless		❌	✔️	✔️	✔️	❌	✔️	✔️	❌	❌
Cluster management	Custom PurchaseandPurchase a subscription cluster	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Release a cluster	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Clone a cluster	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Enable binary logging	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Set a maintenance window	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Manage nodes	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	View or cancel scheduled tasks	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	View database storage usage	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Cluster lock	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Bind cluster 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 manage RAM users	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Create and manage database accounts	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Manage database account passwords	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Data security and encryption	Configure cluster allowlists	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Configure SSL encryption	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
	Configure transparent data encryption (TDE)	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
	SQL firewall	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
	Dynamic data masking	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
	Fully encrypted database	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
Database proxy	Manage endpoints	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Connect to a cluster	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Private domain names	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Read/write splitting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Configure the database proxy	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Overload protection	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
Manage databases		✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Change cluster specifications	Manual specification change	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Implement elastic scaling by using auto scaling	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
	Configure auto scaling with DAS	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
	Add or remove nodes	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Temporary upgrade	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Upgrade archive database Standalone Edition to Cluster Edition	❌	❌	❌	✔️	❌	✔️	✔️	❌	✔️
Cold storage archive	Enable cold data archiving	❌	❌	❌	✔️	✔️	✔️	✔️	✔️	✔️
	Archive data in CSV or ORC format	❌	❌	❌	✔️	✔️	✔️	✔️	✔️	✔️
	Lifecycle management (DLM)	❌	❌	❌	✔️	❌	✔️	✔️	❌	✔️
	OSS foreign tables	❌	❌	❌	✔️	✔️	✔️	✔️	✔️	✔️
High availability	Multi-zone deployment architecture	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Manually change the primary or secondary zone	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
	Cross-zone automatic switchover	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
	Multi-node deployment architectureandAutomatic 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	❌	❌	❌	❌	✔️	❌	❌	✔️	❌
High compression engine (X-Engine)		❌	❌	❌	✔️	❌	❌	✔️	❌	❌
Global Database Network (GDN)	Create and delete global database networks	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
	Add and manage secondary clusters	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
	Connect to a Global Database Network	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
Backup and restoration	Automatic backup	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Manual backup	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Full restoration (restore from backup set)	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Full restoration (restore to a previous point in time)	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Database and table restoration (restore from backup set)	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
	Database and table restoration (restore to a previous point in time)	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
	Flashback query	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Seamless switchover (hot standby switchover)		✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
Elastic Parallel Query (EPQ)		❌	❌	❌	✔️	❌	✔️	✔️	❌	✔️
Large query optimization (Parallel Query)	Accelerate hash joins with parallel execution	❌	❌	❌	❌	❌	✔️	✔️	❌	✔️
	Parallel acceleration for semi-joins	❌	❌	❌	✔️	✔️	✔️	✔️	✔️	✔️
	Use window functions to accelerate parallel queries	❌	❌	❌	✔️	❌	✔️	✔️	❌	✔️
	Use the ROLLUP syntax to accelerate parallel queries	❌	❌	❌	✔️	✔️	✔️	✔️	✔️	✔️
Columnar index (IMCI)		❌	❌	❌	✔️	✔️	✔️	✔️	✔️	✔️
PolarDB for AI		❌	❌	❌	✔️	❌	❌	✔️	❌	❌
Cluster recycle bin	Restore a released cluster	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Permanently delete a released cluster	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Autonomy Center	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Session management	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Real-time performance	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Monitoring and optimization	Storage analysis	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Lock analysis	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Diagnostic report	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Performance Insight (original version)	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Performance insight (new)	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Performance monitoring	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Slow SQL query	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	SQL Explorer	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Version management	Minor version management	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Version management	Major version upgrade	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌	✔️
Parameter settings	Set cluster and node parameters	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Use parameter templates	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	High-performance parameter templates	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Transaction system optimization	Commit timestamp (CTS) technology	❌	❌	❌	✔️	❌	✔️	✔️	❌	❌
Transaction system optimization	What is global consistency (high-performance mode)	❌	✔️	✔️	✔️	❌	✔️	✔️	❌	❌
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 usability optimization	Preemptive DDL	❌	❌	❌	✔️	✔️	✔️	✔️	✔️	✔️
DDL usability 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 Index	❌	❌	❌	✔️	❌	✔️	✔️	❌	✔️
	Global Secondary Indexes (GSIs)	❌	❌	❌	✔️	❌	✔️	✔️	❌	✔️
	Online partition maintenance	❌	❌	❌	✔️	❌	✔️	✔️	❌	✔️
	Create a read-only partition	❌	❌	❌	✔️	❌	✔️	✔️	❌	✔️
	Create a hybrid partition	❌	❌	❌	✔️	❌	✔️	✔️	❌	✔️
	Automated management of partitions	❌	❌	❌	✔️	❌	✔️	✔️	❌	✔️
Query Optimizer	Subquery folding	❌	❌	❌	❌	❌	❌	✔️	❌	✔️
	Transforming IN predicates to 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 hint	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Statement Queue	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Hot row optimization	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Thread Pool	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	B-tree concurrency control optimization	❌	❌	❌	✔️	✔️	✔️	✔️	✔️	✔️
Kernel performance monitoring	Performance Agent	❌	❌	❌	❌	❌	❌	✔️	❌	✔️
	SQL Trace	❌	❌	❌	✔️	✔️	✔️	✔️	✔️	✔️
	SQL detail	❌	❌	❌	✔️	✔️	✔️	✔️	✔️	✔️
Other kernel features	Tenant management and resource isolation	❌	❌	❌	❌	❌	❌	✔️	❌	✔️
	RDMA-based log shipment	❌	❌	❌	✔️	✔️	✔️	❌	✔️	❌
	Warm Buffer Pool	❌	❌	❌	❌	❌	❌	✔️	❌	✔️
	Fast query cache	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Returning	❌	✔️	✔️	❌	❌	❌	❌	❌	❌
	Partial Result Cache (PTRC)	❌	❌	❌	❌	❌	❌	✔️	❌	✔️
	Readable Protobuf	❌	❌	❌	❌	❌	❌	✔️	❌	✔️