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

Features supported by different editions:

Data migration
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single Node Edition
Data migration ✔️ ✔️ ✔️ ✔️
Data synchronization
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single Node Edition
Data synchronization ✔️ ✔️ ✔️ ✔️
Cluster management
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single 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
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single 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
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single Node Edition
Configure an IP whitelist ✔️ ✔️ ✔️ ✔️
Configure SSL encryption ✔️ ❌ ✔️ ✔️
Configure TDE for a PolarDB for MySQL cluster ✔️ ❌ ❌ ✔️
SQL firewalls ✔️ ❌ ✔️ ❌
Dynamic data masking ✔️ ❌ ✔️ ❌
Database management
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single Node Edition
Database Management ✔️ ✔️ ✔️ ✔️
PolarProxy Enterprise Edition
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single 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
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single 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 ❌ ❌ ❌ ❌
Cold data archiving
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single Node Edition
Enable cold data archiving ✔️ ✔️ ❌ ❌
Archive cold data ✔️ ✔️ ❌ ❌
Data lifecycle management (DLM) ✔️ ❌ ❌ ❌
High-availability deployment architecture
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single 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
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single Node Edition
Multi-master Cluster (Database/Table) Edition usage ❌ ✔️ ❌ ❌
X-Engine Edition
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single Node Edition
X-Engine Edition usage ❌ ❌ ✔️ ❌
Global database networks
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single Node Edition
Create and release a GDN ✔️ ❌ ❌ ❌
Add and remove secondary clusters ✔️ ❌ ❌ ❌
Connect to a GDN ✔️ ❌ ❌ ❌
Backup and restoration
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single 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
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single Node Edition
Failover with hot standby overview ✔️ ❌ ❌ ❌
Flashback queries
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single Node Edition
Flashback queries ✔️ ✔️ ✔️ ✔️
HTAP
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single Node Edition
Elastic parallel queries ✔️ ❌ ✔️ ❌
IMCIs ✔️ ❌ ❌ ❌
PolarDB for AI
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single Node Edition
PolarDB for AI ✔️ ❌ ❌ ❌
Cluster recycle bin
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single Node Edition
Restore a released cluster ✔️ ✔️ ✔️ ✔️
Delete a released cluster ✔️ ✔️ ✔️ ✔️
Monitoring and optimization
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single 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
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single Node Edition
Upgrade the cluster version ✔️ ✔️ ✔️ ✔️
Upgrade the cluster version ✔️ ❌ ❌ ✔️
Scheduled O&M events
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single Node Edition
View and manage scheduled events ✔️ ✔️ ✔️ ✔️
Query historical events ✔️ ✔️ ✔️ ✔️
Parameters
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single Node Edition
Specify cluster and node parameters ✔️ ✔️ ✔️ ✔️
Apply a parameter template ✔️ ✔️ ✔️ ✔️
High-performance parameter templates ✔️ ✔️ ✔️ ✔️
Transaction system optimization
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single Node Edition
CTS ✔️ ❌ ❌ ✔️
Global Consistency ✔️ ❌ ❌ ❌
DDL performance optimization
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single 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
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single 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
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single Node Edition
View the execution status of DDL statements and metadata locks ✔️ ✔️ ❌ ✔️
Partitioned tables
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single 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 optimization
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single Node Edition
Subquery decorrelation ✔️ ❌ ❌ ❌
Cost-based query transformation ✔️ ❌ ❌ ❌
LIMIT OFFSET pushdown ✔️ ✔️ ✔️ ✔️
Full predicate pushdown ✔️ ✔️ ✔️ ✔️
Fast traverse ✔️ ✔️ ✔️ ✔️
Bloom filter pushdown ✔️ ❌ ❌ ❌
Parallel queries
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single Node Edition
Hash joins in parallel queries ✔️ ❌ ❌ ❌
Semijoins in parallel queries ✔️ ✔️ ❌ ✔️
Parallel execution of window functions ✔️ ❌ ❌ ❌
Use ROLLUP to improve performance ✔️ ✔️ ❌ ✔️
OSS foreign tables
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single 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
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single Node Edition
Concurrency control ✔️ ✔️ ✔️ ✔️
Inventory hints ✔️ ✔️ ✔️ ✔️
Statement queue ✔️ ✔️ ✔️ ✔️
Hot row optimization ✔️ ✔️ ❌ ✔️
Thread Pool ✔️ ✔️ ✔️ ✔️
Performance monitoring
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single Node Edition
Performance Agent ✔️ ❌ ✔️ ✔️
SQL Trace ✔️ ✔️ ✔️ ✔️
Other features
Feature Cluster Edition Multi-master Cluster (Database/Table) Edition X-Engine Edition Single Node Edition
Table recycle bin ✔️ ✔️ ✔️ ✔️
Fast query cache ✔️ ✔️ ✔️ ✔️
Statement outline ✔️ ✔️ ✔️ ✔️
Returning
❌ ❌ ❌ ❌
Readable Protobuf ✔️ ❌ ❌ ❌