This topic describes the features that are supported by different editions and versions of the ApsaraDB PolarDB MySQL-compatible edition.

MySQL 8.0

Category Feature MySQL 8.0
Cluster Edition Archive Database Single-node Edition
Data migration Overview of data migration or synchronization solutions Yes Yes Yes
Cluster management Purchase a pay-as-you-go cluster and Purchase a subscription cluster Yes Yes Yes
Purchase a storage plan Yes Yes Yes
Change the billing method from subscription to pay-as-you-go Yes Yes Yes
Change the billing method of a cluster from pay-as-you-go to subscription Yes Yes Yes
Manual renewal Yes Yes Yes
Auto-renewal Yes Yes Yes
Release a cluster Yes Yes Yes
Specify cluster parameters Yes Yes Yes
Configure an IP whitelist Yes Yes Yes
Clone a cluster Yes Yes Yes
Attach tags to clusters Yes Yes Yes
Filter clusters by tag Yes Yes Yes
View tags bound to a cluster Yes Yes Yes
Detach tags from clusters Yes Yes Yes
Access to clusters Apply for a cluster endpoint or a primary endpoint Yes Yes Yes
Connect to a cluster Yes Yes Yes
Private domain names Yes Yes Yes
Account Register and log on to an Alibaba Cloud account Yes Yes Yes
Create and authorize a RAM user Yes Yes Yes
Create a database account Yes Yes Yes
Manage database accounts for a cluster Yes Yes Yes
Database Manage databases Yes Yes Yes
Database proxy Read/write splitting Yes No No
Parallel query Yes No No
Dynamic data masking Yes No No
Configure the PolarDB proxy Yes No No
Elastic scaling Manually change specifications Yes No No
Enable the automatic specification change feature by using DAS Yes No No
Automatic specification changes of the ApsaraDB PolarDB MySQL-compatible edition Cluster Edition Yes No No
Add or remove read-only nodes Yes No No
Perform a temporary upgrade Yes No No
High-availability deployment architecture Multi-zone deployment and Change the primary zone and the vSwitch of a cluster Yes No No
Multi-node deployment and Switch over services between primary and read-only nodes Yes No No
Global database network (GDN) Create and release a GDN Yes No No
Add and remove secondary clusters Yes No No
Connect to a GDN Yes No No
Data security Configure TDE Yes No Yes
Configure SSL encryption Yes Yes Yes
Backup and restoration Automatic backup Yes Yes Yes
Manual backup Yes Yes Yes
Cluster restoration: Restore data from a backup set Yes Yes Yes
Cluster restoration: Restore data to a previous point in time Yes Yes Yes
Database or table restoration: Restore data from a backup set No No No
Database or table restoration: Restore data to a previous point in time No No No
Cluster recycle bin Restore a released cluster Yes Yes Yes
Delete a released cluster Yes Yes Yes
Diagnostics and optimization SQL Explorer Yes Yes Yes
Monitor the performance of clusters and nodes Yes Yes Yes
Slow SQL query Yes Yes No
Autonomy center Yes Yes No
Session Management Yes Yes Yes
Real-time Monitoring Yes Yes Yes
Storage analysis Yes Yes Yes
Deadlock analysis Yes Yes Yes
Diagnostic reports Yes Yes Yes
Performance Insight Yes No No
Kernel features Upgrade versions Yes Yes Yes
Enable binary logging Yes No Yes
ROLLUP Yes Yes Yes
Recycle bin Yes Yes Yes
Fast Query Cache Yes Yes Yes
Parallel query Yes Yes Yes
Statement Outline Yes Yes Yes
Hot row optimization Yes Yes Yes
Performance data monitoring Yes Yes Yes
Other features Set a maintenance window Yes Yes Yes
View and manage scheduled events Yes Yes Yes
Restart nodes Yes Yes Yes

MySQL 5.7

Category Feature MySQL 5.7
Cluster Edition Single-node Edition
Data migration Overview of data migration or synchronization solutions Yes Yes
Cluster management Purchase a pay-as-you-go cluster and Purchase a subscription cluster Yes Yes
Purchase a storage plan Yes Yes
Change the billing method from subscription to pay-as-you-go Yes Yes
Change the billing method of a cluster from pay-as-you-go to subscription Yes Yes
Manual renewal Yes Yes
Auto-renewal Yes Yes
Release a cluster Yes Yes
Specify cluster parameters Yes Yes
Configure an IP whitelist Yes Yes
Clone a cluster Yes Yes
Attach tags to clusters Yes Yes
Filter clusters by tag Yes Yes
View tags bound to a cluster Yes Yes
Detach tags from clusters Yes Yes
Access to clusters Apply for a cluster endpoint or a primary endpoint Yes Yes
Connect to a cluster Yes Yes
Private domain names Yes Yes
Account Register and log on to an Alibaba Cloud account Yes Yes
Create and authorize a RAM user Yes Yes
Create a database account Yes Yes
Manage database accounts for a cluster Yes Yes
Database Manage databases Yes Yes
Database proxy Read/write splitting Yes No
Parallel query Yes No
Dynamic data masking Yes No
Configure the PolarDB proxy Yes No
Elastic scaling Manually change specifications Yes No
Enable the automatic specification change feature by using DAS Yes No
Automatic specification changes of the ApsaraDB PolarDB MySQL-compatible edition Cluster Edition Yes No
Add or remove read-only nodes Yes No
Perform a temporary upgrade Yes No
High-availability deployment architecture Multi-zone deployment and Change the primary zone and the vSwitch of a cluster Yes No
Multi-node deployment and Switch over services between primary and read-only nodes Yes No
Global database network (GDN) Create and release a GDN No No
Add and remove secondary clusters No No
Connect to a GDN No No
Data security Configure TDE Yes Yes
Configure SSL encryption Yes Yes
Backup and restoration Automatic backup Yes Yes
Manual backup Yes Yes
Cluster restoration: Restore data from a backup set Yes Yes
Cluster restoration: Restore data to a previous point in time Yes Yes
Database or table restoration: Restore data from a backup set Yes No
Database or table restoration: Restore data to a previous point in time Yes No
Cluster recycle bin Restore a released cluster Yes Yes
Delete a released cluster Yes Yes
Diagnostics and optimization SQL Explorer Yes Yes
Monitor the performance of clusters and nodes Yes Yes
Slow SQL query Yes No
Autonomy center Yes No
Session Management Yes Yes
Real-time Monitoring Yes Yes
Storage analysis Yes Yes
Deadlock analysis Yes Yes
Diagnostic reports Yes Yes
Performance Insight Yes No
Kernel features Upgrade versions Yes Yes
Enable binary logging Yes Yes
ROLLUP No No
Recycle bin No No
Fast Query Cache No No
Parallel query No No
Statement Outline Yes Yes
Hot row optimization No No
Performance data monitoring No No
Other features Set a maintenance window Yes Yes
View and manage scheduled events Yes Yes
Restart nodes Yes Yes

MySQL 5.6

Category Feature MySQL 5.6
Cluster Edition Single-node Edition
Data migration Overview of data migration or synchronization solutions Yes Yes
Cluster management Purchase a pay-as-you-go cluster and Purchase a subscription cluster Yes Yes
Purchase a storage plan Yes Yes
Change the billing method from subscription to pay-as-you-go Yes Yes
Change the billing method of a cluster from pay-as-you-go to subscription Yes Yes
Manual renewal Yes Yes
Auto-renewal Yes Yes
Release a cluster Yes Yes
Specify cluster parameters Yes Yes
Configure an IP whitelist Yes Yes
Clone a cluster Yes Yes
Attach tags to clusters Yes Yes
Filter clusters by tag Yes Yes
View tags bound to a cluster Yes Yes
Detach tags from clusters Yes Yes
Access to clusters Apply for a cluster endpoint or a primary endpoint Yes Yes
Connect to a cluster Yes Yes
Private domain names Yes Yes
Account Register and log on to an Alibaba Cloud account Yes Yes
Create and authorize a RAM user Yes Yes
Create a database account Yes Yes
Manage database accounts for a cluster Yes Yes
Database Manage databases Yes Yes
Database proxy Read/write splitting Yes No
Parallel query Yes No
Dynamic data masking Yes No
Configure the PolarDB proxy Yes No
Elastic scaling Manually change specifications Yes No
Enable the automatic specification change feature by using DAS Yes No
Automatic specification changes of the ApsaraDB PolarDB MySQL-compatible edition Cluster Edition Yes No
Add or remove read-only nodes Yes No
Perform a temporary upgrade Yes No
High-availability deployment architecture Multi-zone deployment and Change the primary zone and the vSwitch of a cluster Yes No
Multi-node deployment and Switch over services between primary and read-only nodes Yes No
Global database network (GDN) Create and release a GDN No No
Add and remove secondary clusters No No
Connect to a GDN No No
Data security Configure TDE Yes Yes
Configure SSL encryption Yes Yes
Backup and restoration Automatic backup Yes Yes
Manual backup Yes Yes
Cluster restoration: Restore data from a backup set Yes Yes
Cluster restoration: Restore data to a previous point in time Yes Yes
Database or table restoration: Restore data from a backup set Yes No
Database or table restoration: Restore data to a previous point in time Yes No
Cluster recycle bin Restore a released cluster Yes Yes
Delete a released cluster Yes Yes
Diagnostics and optimization SQL Explorer Yes Yes
Monitor the performance of clusters and nodes Yes Yes
Slow SQL query Yes No
Autonomy center Yes No
Session Management Yes Yes
Real-time Monitoring Yes Yes
Storage analysis Yes Yes
Deadlock analysis Yes Yes
Diagnostic reports Yes Yes
Performance Insight Yes No
Kernel features Upgrade versions Yes Yes
Enable binary logging Yes Yes
ROLLUP No No
Recycle bin No No
Fast Query Cache No No
Parallel query No No
Statement Outline Yes Yes
Hot row optimization Yes Yes
Performance data monitoring No No
Other features Set a maintenance window Yes Yes
View and manage scheduled events Yes Yes
Restart nodes Yes Yes