This topic describes the features that are supported by different editions and versions of PolarDB for MySQL.
MySQL 5.6
Features supported by different editions:
Data migration
Feature | Cluster Edition |
✔️ |
Data synchronization
Feature | Cluster Edition |
️️️️️️✔️ |
Cluster management
Feature | Cluster Edition |
Purchase a pay-as-you-go cluster and Purchase a subscription cluster | ️️️️️️️️✔️ |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ |
Account management
Feature | Cluster Edition |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ |
Data security and encryption
Feature | Cluster Edition |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ |
Database management
Feature | Cluster Edition |
️️️️️️️️✔️ |
PolarProxy Enterprise Edition
Feature | Cluster Edition |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ |
Cluster configuration changes
Feature | Cluster Edition |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
❌ |
Cold data archiving
Feature | Cluster Edition |
❌ | |
❌ | |
❌ |
High availability
Feature | Cluster Edition |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
Multi-node deployment and Automatic failover and manual failover | ️️️️️️️️✔️ |
Multi-master Cluster (Database/Table) Edition
Feature | Cluster Edition |
❌ |
X-Engine Edition
Feature | Cluster Edition |
❌ |
Global database networks
Feature | Cluster Edition |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ |
Backup and restoration
Feature | Cluster Edition |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
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 |
️️️️️️️️✔️ |
Flashback queries
Feature | Cluster Edition |
️️️️️️️️✔️ |
HTAP
Feature | Cluster Edition |
❌ | |
❌ |
PolarDB for AI
Feature | Cluster Edition |
️️️️️️️️✔️ |
Cluster recycle bin
Feature | Cluster Edition |
️️️️️️️️✔️ | |
️️️️️️️️✔️ |
Monitoring and optimization
Feature | Cluster Edition |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️✔️ | |
️️️️️️️️️✔️ |
Version management
Feature | Cluster Edition |
️️️️️️️️✔️ | |
️️️️️️️️️️️️️️✔️ |
Scheduled O&M events
Feature | Cluster Edition |
️️️️️️✔️ |
Parameter configuration
Feature | Cluster Edition |
️️️️️️✔️ | |
️️️️️️✔️ | |
️️️️️️✔️ |
Transaction system optimization
Feature | Cluster Edition |
❌ | |
❌ |
DDL performance optimization
Feature | Cluster Edition |
❌ | |
❌ | |
️️️️️️✔️ | |
❌ | |
❌ | |
❌ |
DDL stability optimization
DDL usability optimization
Feature | Cluster Edition |
View the execution status of DDL statements and metadata locks | ❌ |
Partitioned tables
Query optimization
Parallel queries
OSS foreign tables
High concurrency optimization
Feature | Cluster Edition |
️️️️️️✔️ | |
️️️️️️✔️ | |
️️️️️️✔️ | |
️️️️️️✔️ | |
️️️️️️✔️ |
Performance monitoring
Feature | Cluster Edition |
❌ | |
❌ |
Other features
Feature | Cluster Edition |
❌ | |
️️️️️️✔️ | |
❌ | |
❌ | |
❌ |
MySQL 5.7
Features supported by different editions:
Data migration
Feature | Cluster Edition |
✔️ |
Data synchronization
Feature | Cluster Edition |
️️️️️️✔️ |
Cluster management
Feature | Cluster Edition |
Purchase a pay-as-you-go cluster and Purchase a subscription cluster | ️️️️️️✔️ |
️️️️️️✔️ | |
️️️️️️✔️ | |
️️️️️️✔️ | |
️️️️️️✔️ | |
️️️️️️✔️ | |
️️️️️️✔️ | |
️️️️️️✔️ | |
️️️️️️✔️ | |
️️️️️✔️ | |
️️️️️✔️ | |
️️️️️️✔️ | |
️️️️️️✔️ |
Account management
Feature | Cluster Edition |
️️️️️️✔️ | |
️️️️️️✔️ | |
️️️️️️✔️ | |
️️️️️️✔️ |
Data security and encryption
Feature | Cluster Edition |
️️️️️️✔️ | |
️️️️️️✔️ | |
️️️️️️✔️ | |
️✔️ | |
️✔️ |
Database management
Feature | Cluster Edition |
️️️️️️✔️ |
PolarProxy Enterprise Edition
Feature | Cluster Edition |
️️️️️️✔️ | |
️️️️️️✔️ | |
️️️️️️✔️ | |
️✔️ | |
️✔️ | |
️✔️ |
Cluster configuration changes
Feature | Cluster Edition |
️✔️ | |
️✔️ | |
️✔️ | |
️✔️ | |
️✔️ | |
️✔️ | |
❌ |
Cold data archiving
Feature | Cluster Edition |
❌ | |
❌ | |
❌ |
High availability
Multi-master Cluster (Database/Table) Edition
Feature | Cluster Edition |
❌ |
X-Engine Edition
Feature | Cluster Edition |
❌ |
Global database networks
Feature | Cluster Edition |
️✔️ | |
️✔️ | |
️✔️ |
Backup and restoration
Feature | Cluster Edition |
️️️️️️✔️ | |
️️️️️️✔️ | |
️️️️️️✔️ | |
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 |
️✔️ |
Flashback queries
Feature | Cluster Edition |
️️️️️️✔️ |
HTAP
Feature | Cluster Edition |
❌ | |
❌ |
PolarDB for AI
Feature | Cluster Edition |
️✔️ |
Cluster recycle bin
Feature | Cluster Edition |
️️️️️️✔️ | |
️️️️️️✔️ |
Monitoring and optimization
Feature | Cluster Edition |
️️️️️️✔️ | |
️️️️️️✔️ | |
️✔️ | |
️✔️ | |
️️️️️️✔️ | |
️️️️️️✔️ | |
️️️️️️✔️ | |
️️️️️️✔️ | |
️️️️️️✔️ | |
️✔️ | |
️✔️ |
Version management
Feature | Cluster Edition |
️️️️️️✔️ | |
️️️️️️✔️ |
Scheduled O&M events
Feature | Cluster Edition |
️️️️️️✔️ |
Parameter configuration
Feature | Cluster Edition |
️️️️️️✔️ | |
️️️️️️✔️ | |
️️️️️️✔️ |
Transaction system optimization
Feature | Cluster Edition |
❌ | |
️✔️ |
DDL performance optimization
Feature | Cluster Edition |
️️️️️️✔️ | |
️️️️️️✔️ | |
️️️️️️✔️ | |
️️️️️️✔️ | |
❌ | |
️️️️️️✔️ |
DDL stability optimization
Feature | Cluster Edition |
❌ | |
️️️️️️✔️ | |
️️️️️️✔️ | |
Prevent long-running transactions on read-only nodes from blocking DDL operations | ️️️️️️✔️ |
DDL usability optimization
Feature | Cluster Edition |
View the execution status of DDL statements and metadata locks | ❌ |
Partitioned tables
Query optimization
Parallel queries
OSS foreign tables
High concurrency optimization
Feature | Cluster Edition |
️️️️️️✔️ | |
️️️️️️✔️ | |
️️️️️️✔️ | |
️️️️️️✔️ | |
️️️️️️✔️ |
Performance monitoring
Feature | Cluster Edition |
❌ | |
❌ |
Other features
Feature | Cluster Edition |
❌ | |
️️️️️️✔️ | |
️️️️️️✔️ | |
️️️️️️✔️ | |
❌ |
MySQL 8.0
Features supported by different editions:
Data migration
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
✔️ | ️️️️️️✔️ |
Data synchronization
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
️️️️️️✔️ | ️️️️️️✔️ |
Cluster management
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
Purchase a pay-as-you-go cluster and Purchase a subscription cluster | ️️️️️️✔️ | ️️️️️️✔️ |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ |
Account management
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ |
Data security and encryption
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
️️️️️️✔️ | ️️️️️️✔️ | |
️✔️ | ❌ | |
️✔️ | ❌ | |
️✔️ | ❌ | |
️✔️ | ❌ |
Database management
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
️️️️️️✔️ | ️️️️️️✔️ |
PolarProxy Enterprise Edition
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ | |
️✔️ | ❌ | |
️✔️ | ❌ |
Cluster configuration changes
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
️️️️️️✔️ | ️️️️️️✔️ | |
️✔️ | ❌ | |
️✔️ | ❌ | |
️✔️ | ❌ | |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️️️✔️ | |
❌ | ❌ |
Cold data archiving
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
️️️️️️✔️ | ️️️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️️️✔️ | |
️✔️ | ❌ |
High availability
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
️️️️️️✔️ | ️️️️️️️️✔️ | |
️✔️ | ❌ | |
️✔️ | ❌ | |
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
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
❌ | ❌ |
Global database networks
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
️✔️ | ❌ | |
️✔️ | ❌ | |
️✔️ | ❌ |
Backup and restoration
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ | |
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 |
️✔️ | ❌ |
Flashback queries
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
️️️️️️✔️ | ️️️️️️✔️ |
HTAP
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
️✔️ | ❌ | |
️✔️ | ❌ |
PolarDB for AI
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
️✔️ | ❌ |
Cluster recycle bin
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ |
Monitoring and optimization
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
️️️️️️✔️ | ️️️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️️️✔️ |
Version management
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
️️️️️️✔️ | ️️️️️️✔️ | |
️✔️ | ❌ |
Scheduled O&M events
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
️️️️️️✔️ | ️️️️️️✔️ |
Parameter configuration
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ |
Transaction system optimization
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
️✔️ | ❌ | |
️✔️ | ❌ |
DDL performance optimization
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
️️️️️️✔️ | ️️️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️️️✔️ | |
❌ | ❌ |
DDL stability optimization
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
️️️️️️✔️ | ️️️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️️️✔️ | |
Prevent long-running transactions on read-only nodes from blocking DDL operations | ️️️️️️✔️ | ️️️️️️️️✔️ |
DDL usability optimization
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
View the execution status of DDL statements and metadata locks | ️️️️️️✔️ | ️️️️️️️️✔️ |
Partitioned tables
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
️️️️️️✔️ | ️️️️️️✔️ | |
️✔️ | ❌ | |
️✔️ | ❌ | |
️✔️ | ❌ | |
️✔️ | ❌ | |
️✔️ | ❌ | |
️✔️ | ❌ | |
️✔️ | ❌ |
Query optimization
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
️✔️ | ❌ | |
️✔️ | ❌ | |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ | |
️✔️ | ❌ |
Parallel queries
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
️✔️ | ❌ | |
️️️️️️✔️ | ️️️️️️️️✔️ | |
️✔️ | ❌ | |
️️️️️️✔️ | ️️️️️️️️✔️ |
OSS foreign tables
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ |
High concurrency optimization
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ |
Performance monitoring
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
️✔️ | ❌ | |
️️️️️️✔️ | ️️️️️️✔️ |
Other features
Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ | |
️️️️️️✔️ | ️️️️️️✔️ | |
❌ | ❌ | |
️✔️ | ❌ |