This topic describes the features that are supported by different editions and versions of PolarDB for MySQL.

MySQL 8.0

Features supported by different editions:

Data migration
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
Data migration✔️✔️✔️✔️
Data synchronization
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
Data synchronization✔️✔️✔️✔️
Cluster management
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
Purchase a pay-as-you-go 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✔️✔️✔️✔️
Bind a tag✔️✔️✔️✔️
Filter clusters by tag✔️✔️✔️✔️
View tags bound to a cluster✔️✔️✔️✔️
Unbind a tag✔️✔️✔️✔️
Account management
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
Register and log on to an Alibaba Cloud account✔️✔️✔️✔️
Create and authorize a RAM user✔️✔️✔️✔️
Create a database account✔️✔️✔️✔️
Manage database accounts for a cluster✔️✔️✔️✔️
Data security and encryption
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
Set IP address whitelists for a cluster.✔️✔️✔️✔️
Configure SSL encryption✔️✔️✔️
Configure TDE for a PolarDB for MySQL cluster✔️✔️
Overview of SQL firewalls✔️✔️
Dynamic data masking✔️✔️
Database management
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
Database Management✔️✔️✔️✔️
PolarProxy Enterprise Edition
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
Apply for a cluster endpoint or a primary endpoint✔️✔️✔️✔️
Connect to a cluster✔️✔️✔️✔️
Private domain names✔️✔️✔️✔️
Read/write splitting✔️✔️✔️
Configure PolarProxy✔️✔️
Overload protection✔️✔️
Cluster configuration changes
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
Manually upgrade or downgrade a PolarDB cluster✔️✔️✔️
Automatic configuration changes (auto scaling)✔️✔️
Configure the auto scaling feature of DAS✔️
Automatically scale local resources✔️
Add or remove read-only nodes✔️✔️✔️
Temporary upgrade✔️✔️
Upgrade an Archive Database Standalone Edition cluster to an Archive Database Cluster Edition cluster
High-availability deployment architecture
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
Multi-zone deployment✔️✔️
Change the primary zone and vSwitch of a cluster✔️
Multi-node deployment and Automatic failover and manual failover✔️✔️✔️
Multi-master Cluster (Database/Table) Edition
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
Usage✔️
X-Engine Edition
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
Usage✔️
Global database networks
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
Create and release a GDN✔️
Add and remove secondary clusters✔️
Connect to a GDN✔️
Backup and restoration
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
Automatic backup✔️✔️✔️✔️
Manual backup✔️✔️✔️✔️
Cluster restoration: Restore data from a backup set✔️✔️✔️✔️
Cluster restoration: Restore data to a previous point in time✔️✔️✔️✔️
Database or table restoration: Restore data from a backup set✔️
Database or table restoration: Restore data to a previous point in time✔️
Failover with hot standby
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
Overview✔️
Flashback queries
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
Flashback queries✔️✔️✔️✔️
HTAP
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
Elastic parallel queries✔️✔️
IMCIs✔️
PolarDB for AI
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
PolarDB for AI✔️
Cluster recycle bin
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
Restore a released cluster✔️✔️✔️✔️
Delete a released cluster✔️✔️✔️✔️
Monitoring and optimization
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
️SQL Explorer and Audit✔️✔️✔️
View performance monitoring data✔️✔️✔️✔️
Slow SQL query✔️✔️
Autonomy center✔️✔️
Session Management✔️✔️✔️
Real-time Monitoring✔️✔️✔️
Storage analysis✔️✔️✔️
Deadlock analysis✔️✔️✔️
Diagnostic reports✔️✔️✔️
Performance Insight (original version)✔️✔️
Performance insight (new)✔️✔️
Version management
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
Upgrade the cluster version✔️✔️✔️✔️
Scheduled O&M events
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
View and manage scheduled events✔️✔️✔️✔️
Query historical events✔️✔️✔️✔️
Parameters
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
Specify cluster and node parameters✔️✔️✔️✔️
Apply a parameter template✔️✔️✔️✔️
High-performance parameter template✔️✔️✔️✔️
Transaction system optimization
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
CTS✔️✔️
SCC✔️
DDL performance optimization
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
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
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
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
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
View the execution status of DDL statements and metadata locks✔️✔️✔️
Partitioned tables
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
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 optimizer
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
Subquery decorrelation✔️
Cost-based query transformation✔️
LIMIT OFFSET pushdown✔️✔️✔️✔️
Full predicate pushdown✔️✔️✔️✔️
Fast traverse✔️✔️✔️✔️
Bloom filter pushdown✔️
Parallel queries
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
Hash joins in parallel queries✔️
Semijoins in parallel queries✔️✔️✔️
Parallel execution of window functions✔️
Use ROLLUP to improve performance✔️✔️✔️
OSS foreign tables
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
Use OSS foreign tables to access OSS data✔️✔️✔️✔️
Perform multi-file queries for a single OSS foreign table✔️✔️✔️✔️
Export local tables to OSS✔️✔️✔️✔️
High concurrency optimization
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
Concurrency control✔️✔️✔️✔️
Inventory hints✔️✔️✔️✔️
Statement queue✔️✔️✔️✔️
Hot row optimization✔️✔️✔️
Thread pool✔️✔️✔️✔️
Performance monitoring
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
Performance Agent✔️✔️✔️
SQL trace✔️✔️✔️✔️
Other features
FeatureCluster EditionMulti-master Cluster (Database/Table) EditionX-Engine EditionSingle Node Edition
Table recycle bin✔️✔️✔️✔️
Fast query cache✔️✔️✔️✔️
Statement outline✔️✔️✔️✔️
Returning
Readable Protobuf✔️

MySQL 5.7

Features supported by different editions:

Data migration
FeatureCluster EditionSingle Node Edition
Data migration✔️✔️
Data synchronization
FeatureCluster EditionSingle Node Edition
Data synchronization✔️✔️
Cluster management
FeatureCluster EditionSingle Node Edition
Purchase a pay-as-you-go 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✔️✔️
Bind a tag✔️✔️
Filter clusters by tag✔️✔️
View tags bound to a cluster✔️✔️
Unbind a tag✔️✔️
Account management
FeatureCluster EditionSingle Node Edition
Register and log on to an Alibaba Cloud account✔️✔️
Create and authorize a RAM user✔️✔️
Create a database account✔️✔️
Manage database accounts for a cluster✔️✔️
Data security and encryption
FeatureCluster EditionSingle Node Edition
Set IP address whitelists for a cluster✔️✔️
Configure SSL encryption✔️✔️
Configure TDE for a PolarDB for MySQL cluster✔️✔️
Overview✔️
Dynamic Data Masking✔️
Database management
FeatureCluster EditionSingle Node Edition
Database Management✔️✔️
PolarProxy Enterprise Edition
FeatureCluster EditionSingle Node Edition
Apply for a cluster endpoint or a primary endpoint✔️✔️
Connect to a cluster✔️✔️
Private domain names✔️✔️
Read/write splitting✔️
Configure PolarProxy✔️
Overload protection✔️
High-availability deployment architecture
FeatureCluster EditionSingle Node Edition
Multi-zone deployment✔️
Change the primary zone and vSwitch of a cluster✔️
Multi-node deployment and Automatic failover and manual failover✔️
Multi-master Cluster (Database/Table) Edition
FeatureCluster EditionSingle Node Edition
Usage
X-Engine Edition
FeatureCluster EditionSingle Node Edition
Usage
Global database networks
FeatureCluster EditionSingle Node Edition
Create and release a GDN✔️
Add and remove secondary clusters✔️
Connect to a GDN✔️
Failover with hot standby
FeatureCluster EditionSingle Node Edition
Overview✔️
Flashback queries
FeatureCluster EditionSingle Node Edition
Flashback queries✔️✔️
HTAP
FeatureCluster EditionSingle Node Edition
Elastic parallel queries
IMCIs
PolarDB for AI
FeatureCluster EditionSingle Node Edition
PolarDB for AI✔️
Cluster recycle bin
FeatureCluster EditionSingle Node Edition
Restore a released cluster✔️✔️
Delete a released cluster✔️✔️
Monitoring and optimization
FeatureCluster EditionSingle Node Edition
️SQL Explorer and Audit✔️✔️
View performance monitoring data✔️✔️
Slow SQL query✔️
Autonomy center✔️
Session Management✔️✔️
Real-time Monitoring✔️✔️
Storage analysis✔️✔️
Deadlock analysis✔️✔️
Diagnostic reports✔️✔️
Performance Insight (original version)✔️
Performance insight (new)✔️
Version management
FeatureCluster EditionSingle Node Edition
Upgrade the cluster version✔️✔️
Scheduled O&M events
FeatureCluster EditionSingle Node Edition
View and manage scheduled events✔️✔️
Query historical events✔️✔️
Parameters
FeatureCluster EditionSingle Node Edition
Specify cluster and node parameters✔️✔️
Apply a parameter template✔️✔️
High-performance parameter template✔️✔️
Transaction system optimization
FeatureCluster EditionSingle Node Edition
CTS
SCC✔️
DDL performance optimization
FeatureCluster EditionSingle Node Edition
Instant ADD COLUMN✔️✔️
Parallel DDL✔️✔️
DDL read-ahead✔️✔️
DDL multi-way merging and sorting✔️✔️
DDL asynchronous I/O
Faster TRUNCATE/DROP TABLE✔️✔️
DDL usability optimization
FeatureCluster EditionSingle Node Edition
View the execution status of DDL statements and metadata locks
Query optimizer
FeatureCluster EditionSingle Node Edition
Subquery decorrelation
Cost-based query transformation
LIMIT OFFSET pushdown
Full predicate pushdown
Fast traverse
Bloom filter pushdown
High concurrency optimization
FeatureCluster EditionSingle Node Edition
Concurrency control✔️✔️
Inventory hints✔️✔️
Statement queue✔️✔️
Hot row optimization✔️✔️
Thread pool✔️✔️
Performance monitoring
FeatureCluster EditionSingle Node Edition
Performance Agent
SQL trace
Other features
FeatureCluster EditionSingle Node Edition
Table recycle bin
Fast query cache✔️✔️
Statement outline✔️✔️
Returning✔️✔️
Readable Protobuf

MySQL 5.6

Features supported by different editions:

Data migration
FeatureCluster EditionSingle Node Edition
Data migration✔️✔️
Data synchronization
FeatureCluster EditionSingle Node Edition
Data synchronization✔️✔️
Cluster management
FeatureCluster EditionSingle Node Edition
Purchase a pay-as-you-go 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✔️✔️
Bind a tag✔️✔️
Filter clusters by tag✔️✔️
View tags bound to a cluster✔️✔️
Unbind a tag✔️✔️
Account management
FeatureCluster EditionSingle Node Edition
Register and log on to an Alibaba Cloud account✔️✔️
Create and authorize a RAM user✔️✔️
Create a database account✔️✔️
Manage database accounts for a cluster✔️✔️
Data security and encryption
FeatureCluster EditionSingle Node Edition
Set IP address whitelists for a cluster✔️✔️
Configure SSL encryption✔️✔️
Configure TDE for a PolarDB for MySQL cluster✔️✔️
Overview✔️
Dynamic Data Masking✔️
Database management
FeatureCluster EditionSingle Node Edition
Database Management✔️✔️
PolarProxy Enterprise Edition
FeatureCluster EditionSingle Node Edition
Apply for a cluster endpoint or a primary endpoint✔️✔️
Connect to a cluster✔️✔️
Private domain names✔️✔️
Read/write splitting✔️
Configure PolarProxy✔️
Overload protection✔️
High-availability deployment architecture
FeatureCluster EditionSingle Node Edition
Multi-zone deployment✔️
Change the primary zone and vSwitch of a cluster✔️
Multi-node deployment and Automatic failover and manual failover✔️
Multi-master Cluster (Database/Table) Edition
FeatureCluster EditionSingle Node Edition
Usage
X-Engine Edition
FeatureCluster EditionSingle Node Edition
Usage
Global database networks
FeatureCluster EditionSingle Node Edition
Create and release a GDN✔️
Add and remove secondary clusters✔️
Connect to a GDN✔️
Failover with hot standby
FeatureCluster EditionSingle Node Edition
Overview✔️
Flashback queries
FeatureCluster EditionSingle Node Edition
Flashback queries✔️✔️
HTAP
FeatureCluster EditionSingle Node Edition
Elastic parallel queries
IMCIs
PolarDB for AI
FeatureCluster EditionSingle Node Edition
PolarDB for AI✔️
Cluster recycle bin
FeatureCluster EditionSingle Node Edition
Restore a released cluster✔️✔️
Delete a released cluster✔️✔️
Monitoring and optimization
FeatureCluster EditionSingle Node Edition
️SQL Explorer and Audit✔️✔️
View performance monitoring data✔️✔️
Slow SQL query✔️
Autonomy center✔️
Session Management✔️✔️
Real-time Monitoring✔️✔️
Storage analysis✔️✔️
Deadlock analysis✔️✔️
Diagnostic reports✔️✔️
Performance Insight (original version)✔️
Performance insight (new)✔️
Version management
FeatureCluster EditionSingle Node Edition
Upgrade the cluster version✔️✔️
Scheduled O&M events
FeatureCluster EditionSingle Node Edition
View and manage scheduled events✔️✔️
Query historical events✔️✔️
Parameters
FeatureCluster EditionSingle Node Edition
Specify cluster and node parameters✔️✔️
Apply a parameter template✔️✔️
High-performance parameter template✔️✔️
Transaction system optimization
FeatureCluster EditionSingle Node Edition
CTS
SCC
DDL performance optimization
FeatureCluster EditionSingle Node Edition
Instant ADD COLUMN
Parallel DDL
DDL read-ahead✔️✔️
DDL multi-way merging and sorting
DDL asynchronous I/O
Faster TRUNCATE/DROP TABLE
DDL usability optimization
FeatureCluster EditionSingle Node Edition
View the execution status of DDL statements and metadata locks
Query optimizer
FeatureCluster EditionSingle Node Edition
Subquery decorrelation
Cost-based query transformation
LIMIT OFFSET pushdown
Full predicate pushdown
Fast traverse
Bloom filter pushdown
High concurrency optimization
FeatureCluster EditionSingle Node Edition
Concurrency control✔️✔️
Inventory hints✔️✔️
Statement queue✔️✔️
Hot row optimization✔️✔️
Thread pool✔️✔️
Performance monitoring
FeatureCluster EditionSingle Node Edition
Performance Agent
SQL trace
Other features
FeatureCluster EditionSingle Node Edition
Table recycle bin
Fast query cache✔️✔️
Statement outline
Returning
Readable Protobuf