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
| 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 |
|---|---|---|---|---|
| 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
| 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 | ❌ | ❌ | ❌ | ❌ |
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 |
|---|---|---|---|---|
| Usage | ❌ | ✔️ | ❌ | ❌ |
X-Engine Edition
| Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition | X-Engine Edition | Single Node 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 |
|---|---|---|---|---|
| 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 | ✔️ | ✔️ | ✔️ | ✔️ |
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 template | ✔️ | ✔️ | ✔️ | ✔️ |
Transaction system optimization
| Feature | Cluster Edition | Multi-master Cluster (Database/Table) Edition | X-Engine Edition | Single Node Edition |
|---|---|---|---|---|
| CTS | ✔️ | ❌ | ❌ | ✔️ |
| SCC | ✔️ | ❌ | ❌ | ❌ |
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 optimizer
| 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 | ✔️ | ❌ | ❌ | ❌ |
MySQL 5.7
Features supported by different editions:
Data migration
| Feature | Cluster Edition | Single Node Edition |
|---|---|---|
| Data migration | ✔️ | ✔️ |
Data synchronization
| Feature | Cluster Edition | Single Node Edition |
|---|---|---|
| Data synchronization | ✔️ | ✔️ |
Cluster management
| Feature | Cluster 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 | 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 | Single 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
| Feature | Cluster Edition | Single Node Edition |
|---|---|---|
| Database Management | ✔️ | ✔️ |
PolarProxy Enterprise Edition
| Feature | Cluster 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
High-availability deployment architecture
| Feature | Cluster 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 | Single Node Edition |
|---|---|---|
| Usage | ❌ | ❌ |
X-Engine Edition
| Feature | Cluster Edition | Single Node Edition |
|---|---|---|
| Usage | ❌ | ❌ |
Global database networks
| Feature | Cluster Edition | Single Node Edition |
|---|---|---|
| Create and release a GDN | ✔️ | ❌ |
| Add and remove secondary clusters | ✔️ | ❌ |
| Connect to a GDN | ✔️ | ❌ |
Backup and restoration
Failover with hot standby
| Feature | Cluster Edition | Single Node Edition |
|---|---|---|
| Overview | ✔️ | ❌ |
Flashback queries
| Feature | Cluster Edition | Single Node Edition |
|---|---|---|
| Flashback queries | ✔️ | ✔️ |
HTAP
| Feature | Cluster Edition | Single Node Edition |
|---|---|---|
| Elastic parallel queries | ❌ | ❌ |
| IMCIs | ❌ | ❌ |
PolarDB for AI
| Feature | Cluster Edition | Single Node Edition |
|---|---|---|
| PolarDB for AI | ✔️ | ❌ |
Cluster recycle bin
| Feature | Cluster Edition | Single Node Edition |
|---|---|---|
| Restore a released cluster | ✔️ | ✔️ |
| Delete a released cluster | ✔️ | ✔️ |
Monitoring and optimization
| Feature | Cluster 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 | Single Node Edition |
|---|---|---|
| Upgrade the cluster version | ✔️ | ✔️ |
Scheduled O&M events
| Feature | Cluster Edition | Single Node Edition |
|---|---|---|
| View and manage scheduled events | ✔️ | ✔️ |
| Query historical events | ✔️ | ✔️ |
Parameters
| Feature | Cluster Edition | Single Node Edition |
|---|---|---|
| Specify cluster and node parameters | ✔️ | ✔️ |
| Apply a parameter template | ✔️ | ✔️ |
| High-performance parameter template | ✔️ | ✔️ |
DDL performance optimization
| Feature | Cluster 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 | 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 | Single Node Edition |
|---|---|---|
| View the execution status of DDL statements and metadata locks | ❌ | ❌ |
Partitioned tables
| Feature | Cluster 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 optimizer
| Feature | Cluster 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 | 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 | 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 | Single Node Edition |
|---|---|---|
| Concurrency control | ✔️ | ✔️ |
| Inventory hints | ✔️ | ✔️ |
| Statement queue | ✔️ | ✔️ |
| Hot row optimization | ✔️ | ✔️ |
| Thread pool | ✔️ | ✔️ |
Performance monitoring
| Feature | Cluster Edition | Single Node Edition |
|---|---|---|
| Performance Agent | ❌ | ❌ |
| SQL trace | ❌ | ❌ |
Other features
| Feature | Cluster Edition | Single Node Edition |
|---|---|---|
| Table recycle bin | ❌ | ❌ |
| Fast query cache | ✔️ | ✔️ |
| Statement outline | ✔️ | ✔️ |
| Returning | ✔️ | ✔️ |
| Readable Protobuf | ❌ | ❌ |
MySQL 5.6
Features supported by different editions:
Data migration
| Feature | Cluster Edition | Single Node Edition |
|---|---|---|
| Data migration | ✔️ | ✔️ |
Data synchronization
| Feature | Cluster Edition | Single Node Edition |
|---|---|---|
| Data synchronization | ✔️ | ✔️ |
Cluster management
| Feature | Cluster 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 | 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 | Single 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
| Feature | Cluster Edition | Single Node Edition |
|---|---|---|
| Database Management | ✔️ | ✔️ |
PolarProxy Enterprise Edition
| Feature | Cluster 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
High-availability deployment architecture
| Feature | Cluster 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 | Single Node Edition |
|---|---|---|
| Usage | ❌ | ❌ |
X-Engine Edition
| Feature | Cluster Edition | Single Node Edition |
|---|---|---|
| Usage | ❌ | ❌ |
Global database networks
| Feature | Cluster Edition | Single Node Edition |
|---|---|---|
| Create and release a GDN | ✔️ | ❌ |
| Add and remove secondary clusters | ✔️ | ❌ |
| Connect to a GDN | ✔️ | ❌ |
Backup and restoration
Failover with hot standby
| Feature | Cluster Edition | Single Node Edition |
|---|---|---|
| Overview | ✔️ | ❌ |
Flashback queries
| Feature | Cluster Edition | Single Node Edition |
|---|---|---|
| Flashback queries | ✔️ | ✔️ |
HTAP
| Feature | Cluster Edition | Single Node Edition |
|---|---|---|
| Elastic parallel queries | ❌ | ❌ |
| IMCIs | ❌ | ❌ |
PolarDB for AI
| Feature | Cluster Edition | Single Node Edition |
|---|---|---|
| PolarDB for AI | ✔️ | ❌ |
Cluster recycle bin
| Feature | Cluster Edition | Single Node Edition |
|---|---|---|
| Restore a released cluster | ✔️ | ✔️ |
| Delete a released cluster | ✔️ | ✔️ |
Monitoring and optimization
| Feature | Cluster 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 | Single Node Edition |
|---|---|---|
| Upgrade the cluster version | ✔️ | ✔️ |
Scheduled O&M events
| Feature | Cluster Edition | Single Node Edition |
|---|---|---|
| View and manage scheduled events | ✔️ | ✔️ |
| Query historical events | ✔️ | ✔️ |
Parameters
| Feature | Cluster Edition | Single Node Edition |
|---|---|---|
| Specify cluster and node parameters | ✔️ | ✔️ |
| Apply a parameter template | ✔️ | ✔️ |
| High-performance parameter template | ✔️ | ✔️ |
DDL performance optimization
| Feature | Cluster 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 | 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 | Single Node Edition |
|---|---|---|
| View the execution status of DDL statements and metadata locks | ❌ | ❌ |
Partitioned tables
| Feature | Cluster 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 optimizer
| Feature | Cluster 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 | 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 | 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 | Single Node Edition |
|---|---|---|
| Concurrency control | ✔️ | ✔️ |
| Inventory hints | ✔️ | ✔️ |
| Statement queue | ✔️ | ✔️ |
| Hot row optimization | ✔️ | ✔️ |
| Thread pool | ✔️ | ✔️ |
Performance monitoring
| Feature | Cluster Edition | Single Node Edition |
|---|---|---|
| Performance Agent | ❌ | ❌ |
| SQL trace | ❌ | ❌ |
Other features
| Feature | Cluster Edition | Single Node Edition |
|---|---|---|
| Table recycle bin | ❌ | ❌ |
| Fast query cache | ✔️ | ✔️ |
| Statement outline | ❌ | ❌ |
| Returning | ❌ | ❌ |
| Readable Protobuf | ❌ | ❌ |