All Products
Search
Document Center

PolarDB:Feature compatibility of PolarDB-X 2.0 Standard Edition and ApsaraDB RDS for MySQL Enterprise Edition

Last Updated:Dec 17, 2024

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

✔️

✔️

Change of instance specifications

✔️

✔️

Automatic storage expansion

Automatic performance scaling

✔️

Cross-zone migration

✔️

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

✔️

✔️

Change of instance specifications

✔️

✔️

Automatic storage expansion

Automatic performance scaling

✔️

Cross-zone migration

✔️

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