This topic describes the feature compatibility of PolarDB-X 2.0 Standard Edition and ApsaraDB RDS for MySQL Enterprise Edition when they run MySQL 5.7 or MySQL 8.0.
MySQL 8.0
Category | Feature | ApsaraDB RDS for MySQL Enterprise Edition | PolarDB-X 2.0 Standard Edition |
Data migration | Data migration | ✔️ | ❌ |
Data synchronization | Data synchronization | ✔️ | ❌ |
Instance management | Instance creation | ✔️ | ✔️ |
✔️ | ✔️ | ||
Automatic storage expansion | ❌ | ❌ | |
Automatic performance scaling | ✔️ | ❌ | |
❌ | ✔️ | ||
Automatic or manual primary/secondary switchover | ✔️ | ❌ | |
Query and change of the data replication mode | ❌ | ❌ | |
Use of parameter templates | ✔️ | ❌ | |
Creation of a disaster recovery instance | ✔️ | ❌ | |
Restart of an instance | ✔️ | ✔️ | |
Automatic start and stop of a serverless instance | ❌ | ❌ | |
Instance suspension | ❌ | ❌ | |
Maintenance window setting | ✔️ | ✔️ | |
Instance release | ✔️ | ✔️ | |
Instance recycle bin | ✔️ | ❌ | |
Instance upgrade | Update of the minor engine version | ✔️ | ✔️ |
Upgrade of the major engine version | ❌ | ❌ | |
Upgrade from Basic Edition to Cluster Edition | ❌ | ❌ | |
Upgrade from High-availability Edition to Cluster Edition | ❌ | ❌ | |
Upgrade from Basic Edition to High-availability Edition | ❌ | ❌ | |
Upgrade from standard SSDs to ESSDs | ❌ | ❌ | |
Upgrade from High-availability Edition to Enterprise Edition | ❌ | ❌ | |
Account management | Account creation | ✔️ | ✔️ |
Custom password policies | ❌ | ❌ | |
Password reset | ✔️ | ✔️ | |
Account permission modification | ✔️ | ✔️ | |
Account deletion | ✔️ | ✔️ | |
Reset of the permissions of privileged accounts | ✔️ | ✔️ | |
Database management | Database management | ✔️ | ✔️ |
Database deletion | ✔️ | ✔️ | |
Database connection management | Instance connection by using a CLI or a client | ✔️ | ✔️ |
Endpoint setting | ✔️ | ✔️ | |
Endpoint and port number viewing | ✔️ | ✔️ | |
Public endpoint application or release | ✔️ | ✔️ | |
Monitoring and alerts | Monitoring information viewing | ✔️ | ✔️ |
Monitoring frequency setting | ✔️ | ✔️ | |
Alerts management | ✔️ | ✔️ | |
Network management | Network type change | ✔️ | ✔️ |
Virtual private cloud (VPC) and vSwitch change | ✔️ | ✔️ | |
Read-only instance management and read/write splitting | Read-only instance creation | ✔️ | ✔️ |
Read/write splitting (shared proxy) | ✔️ | ❌ | |
PolarProxy | ✔️ | ❌ | |
Security management | IP address whitelist setting | ✔️ | ✔️ |
Change to enhanced whitelist mode | ❌ | ❌ | |
Enabling SSL encryption by using a cloud certificate | ✔️ | ✔️ | |
Transparent data encryption (TDE) setting | ❌ | ✔️ | |
Release protection | ✔️ | ❌ | |
Cloud disk encryption | ❌ | ❌ | |
Sensitive data management | ❌ | ❌ | |
Data Security Center (DSC) | ❌ | ❌ | |
Audit | SQL Explorer | ✔️ | ✔️ |
Error log and slow log viewing | ✔️ | ✔️ | |
Historical events | ✔️ | ✔️ | |
Data backup | Automatic backup | ✔️ | ✔️ |
Long-term retention for backup files | ✔️ | ❌ | |
Backup storage fees | ✔️ | ✔️ | |
Download of backup files | ✔️ | ✔️ | |
Cross-region backup feature | ❌ | ✔️ | |
Database restoration | Restoration of full data | ✔️ | ✔️ |
Restoration of individual databases and tables | ❌ | ❌ | |
Cross-region data restoration | ❌ | ✔️ | |
Dedicated database proxy | PolarProxy | ✔️ | ❌ |
Diagnosis and optimization | Database Autonomy Service (DAS) | ✔️ | ❌ |
AliSQL | AliSQL | ✔️ | ❌ |
Tag management | Tag adding | ✔️ | ✔️ |
Tag removal | ✔️ | ✔️ | |
Tag-based instance search | ✔️ | ✔️ | |
Cluster node management | One primary node and multiple readable secondary nodes | ❌ | ❌ |
Unified management of read/write endpoints and read-only endpoints | ❌ | ❌ | |
Automatic failover and manual switchover of cluster nodes | ❌ | ❌ |
MySQL 5.7
Category | Feature | ApsaraDB RDS for MySQL Enterprise Edition | PolarDB-X 2.0 Standard Edition |
Data migration | Data migration | ✔️ | ❌ |
Data synchronization | Data synchronization | ✔️ | ❌ |
Instance management | Instance creation | ✔️ | ✔️ |
✔️ | ✔️ | ||
Automatic storage expansion | ❌ | ❌ | |
Automatic performance scaling | ✔️ | ❌ | |
❌ | ✔️ | ||
Automatic or manual primary/secondary switchover | ✔️ | ❌ | |
Query and change of the data replication mode | ❌ | ❌ | |
Use of parameter templates | ✔️ | ❌ | |
Creation of a disaster recovery instance | ✔️ | ❌ | |
Restart of an instance | ✔️ | ✔️ | |
Automatic start and stop of a serverless instance | ❌ | ❌ | |
Instance suspension | ❌ | ❌ | |
Maintenance window setting | ✔️ | ✔️ | |
Instance release | ✔️ | ✔️ | |
Instance recycle bin | ✔️ | ❌ | |
Instance upgrade | Update of the minor engine version | ✔️ | ✔️ |
Upgrade of the major engine version | ❌ | ❌ | |
Upgrade from Basic Edition to Cluster Edition | ❌ | ❌ | |
Upgrade from High-availability Edition to Cluster Edition | ❌ | ❌ | |
Upgrade from Basic Edition to High-availability Edition | ❌ | ❌ | |
Upgrade from standard SSDs to ESSDs | ❌ | ❌ | |
Upgrade from High-availability Edition to Enterprise Edition | ❌ | ❌ | |
Account management | Account creation | ✔️ | ✔️ |
Custom password policies | ❌ | ❌ | |
Password reset | ✔️ | ✔️ | |
Account permission modification | ✔️ | ✔️ | |
Account deletion | ✔️ | ✔️ | |
Reset of the permissions of privileged accounts | ✔️ | ✔️ | |
Database management | Database management | ✔️ | ✔️ |
Database deletion | ✔️ | ✔️ | |
Database connection management | Instance connection by using a CLI or a client | ✔️ | ✔️ |
Endpoint setting | ✔️ | ✔️ | |
Endpoint and port number viewing | ✔️ | ✔️ | |
Public endpoint application or release | ✔️ | ✔️ | |
Monitoring and alerts | Monitoring information viewing | ✔️ | ✔️ |
Monitoring frequency setting | ✔️ | ✔️ | |
Alerts management | ✔️ | ✔️ | |
Network management | Network type change | ✔️ | ✔️ |
Virtual private cloud (VPC) and vSwitch change | ✔️ | ✔️ | |
Read-only instance management and read/write splitting | Read-only instance creation | ✔️ | ✔️ |
Read/write splitting (shared proxy) | ✔️ | ❌ | |
PolarProxy | ✔️ | ❌ | |
Security management | IP address whitelist setting | ✔️ | ✔️ |
Change to enhanced whitelist mode | ✔️ | ❌ | |
Enabling SSL encryption by using a cloud certificate | ✔️ | ✔️ | |
Transparent data encryption (TDE) setting | ❌ | ✔️ | |
Release protection | ✔️ | ❌ | |
Cloud disk encryption | ❌ | ❌ | |
Sensitive data management | ❌ | ❌ | |
Data Security Center (DSC) | ❌ | ❌ | |
Audit | ️SQL Explorer | ✔️ | ✔️ |
Error log and slow log viewing | ✔️ | ✔️ | |
Historical events | ✔️ | ✔️ | |
Data backup | Automatic backup | ✔️ | ✔️ |
Long-term retention for backup files | ✔️ | ❌ | |
Backup storage fees | ✔️ | ✔️ | |
Download of backup files | ✔️ | ✔️ | |
Cross-region backup feature | ❌ | ✔️ | |
Database restoration | Restoration of full data | ✔️ | ✔️ |
Restoration of individual databases and tables | ❌ | ❌ | |
Cross-region data restoration | ❌ | ✔️ | |
Dedicated database proxy | PolarProxy | ✔️ | ❌ |
Diagnosis and optimization | Database Autonomy Service (DAS) | ✔️ | ❌ |
AliSQL | AliSQL | ✔️ | ❌ |
Tag management | Tag adding | ✔️ | ✔️ |
Tag removal | ✔️ | ✔️ | |
Tag-based instance search | ✔️ | ✔️ | |
Cluster node management | One primary node and multiple readable secondary nodes | ❌ | ❌ |
Unified management of read/write endpoints and read-only endpoints | ❌ | ❌ | |
Automatic failover and manual switchover of cluster nodes | ❌ | ❌ |