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
✔️ ✔️ ✔️ ✔️
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-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 ✔️
✔️
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 ✔️ ✔️ ✔️ ✔️
Readable Protobuf ✔️