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 | ✔️ | ❌ | ❌ | ❌ |
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 |
---|---|---|
✔️ | ✔️ | |
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 |
---|---|---|
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 | 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
Feature | Cluster 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 | Single Node Edition |
---|---|---|
Enable cold data archiving | ❌ | ❌ |
Archive cold data | ❌ | ❌ |
Data lifecycle management (DLM) | ❌ | ❌ |
High-availability
deployment architecture
Feature | Cluster 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 | Single Node Edition |
---|---|---|
Multi-master Cluster (Database/Table) Edition usage | ❌ | ❌ |
X-Engine
Edition
Feature | Cluster Edition | Single Node Edition |
---|---|---|
X-Engine 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
Feature | Cluster 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 | Single Node Edition |
---|---|---|
Failover with hot standby 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 | ✔️ | ✔️ |
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 templates | ✔️ | ✔️ |
Transaction
system optimization
Feature | Cluster Edition | Single Node Edition |
---|---|---|
CTS | ❌ | ❌ |
Global Consistency | ✔️ | ❌ |
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
optimization
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 | ✔️ | ✔️ |
✔️ | ✔️ | |
Readable Protobuf | ❌ | ❌ |
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 |
---|---|---|
✔️ | ✔️ | |
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 |
---|---|---|
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 | 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
Feature | Cluster 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 | Single Node Edition |
---|---|---|
Enable cold data archiving | ❌ | ❌ |
Archive cold data | ❌ | ❌ |
Data lifecycle management (DLM) | ❌ | ❌ |
High-availability
deployment architecture
Feature | Cluster 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 | Single Node Edition |
---|---|---|
Multi-master Cluster (Database/Table) Edition usage | ❌ | ❌ |
X-Engine
Edition
Feature | Cluster Edition | Single Node Edition |
---|---|---|
X-Engine 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
Feature | Cluster 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 | Single Node Edition |
---|---|---|
Failover with hot standby 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 | ✔️ | ✔️ |
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 templates | ✔️ | ✔️ |
Transaction
system optimization
Feature | Cluster Edition | Single Node Edition |
---|---|---|
CTS | ❌ | ❌ |
Global Consistency | ❌ | ❌ |
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
optimization
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 | ❌ | ❌ |
❌ | ❌ | |
Readable Protobuf | ❌ | ❌ |
Was this helpful?