All Products
Search
Document Center

PolarDB:Features in PolarDB MySQL 5.6, 5.7, and 8.0

Last Updated:Mar 04, 2024

This topic describes the features that are supported by different editions and versions of PolarDB for MySQL.

MySQL 5.6

Features supported by different editions:

Data migration

Feature

Cluster Edition

Data migration

✔️

Data synchronization

Feature

Cluster Edition

Data synchronization

️️️️️️✔️

Cluster management

Feature

Cluster 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

️️️️️️️️✔️

Add tags

️️️️️️️️✔️

Filter clusters by tag

️️️️️️️️✔️

View tags bound to a cluster

️️️️️️️️✔️

Unbind a tag

️️️️️️️️✔️

Account management

Feature

Cluster Edition

Register and log on to an Alibaba Cloud account

️️️️️️️️✔️

Create and authorize a RAM user

️️️️️️️️✔️

Create and manage a database account

️️️️️️️️✔️

Manage database accounts for a cluster

️️️️️️️️✔️

Data security and encryption

Feature

Cluster 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

Database Management

️️️️️️️️✔️

PolarProxy Enterprise Edition

Feature

Cluster Edition

Manage the endpoints of a cluster

️️️️️️️️✔️

Connect to a cluster.

️️️️️️️️✔️

Private domain names

️️️️️️️️✔️

Read/write splitting

️️️️️️️️✔️

Configure PolarProxy

️️️️️️️️✔️

Overload protection

️️️️️️️️✔️

Cluster configuration changes

Cold data archiving

High availability

Feature

Cluster Edition

Architecture for multi-zone deployment

️️️️️️️️✔️

Change the primary zone and vSwitch of a cluster

️️️️️️️️✔️

Cross-zone automatic switchover

️️️️️️️️✔️

Multi-node deployment and Automatic failover and manual failover

️️️️️️️️✔️

Multi-master Cluster (Database/Table) Edition

X-Engine Edition

Feature

Cluster Edition

X-Engine Edition usage

Global database networks

Feature

Cluster Edition

Create and release a GDN

️️️️️️️️✔️

Manage a secondary cluster

️️️️️️️️✔️

Connect to a GDN

️️️️️️️️✔️

Backup and restoration

Feature

Cluster 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

Failover with hot standby overview

️️️️️️️️✔️

Flashback queries

Feature

Cluster Edition

Flashback queries

️️️️️️️️✔️

HTAP

Feature

Cluster Edition

Elastic parallel queries

IMCIs

PolarDB for AI

Feature

Cluster Edition

PolarDB for AI

️️️️️️️️✔️

Cluster recycle bin

Feature

Cluster Edition

Restore a released cluster

️️️️️️️️✔️

Delete a released cluster

️️️️️️️️✔️

Monitoring and optimization

Feature

Cluster 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

Minor version update

️️️️️️️️✔️

Major version upgrade

️️️️️️️️️️️️️️✔️

Scheduled O&M events

Feature

Cluster Edition

View and manage scheduled events

️️️️️️✔️

Parameter configuration

Feature

Cluster Edition

Specify cluster and node parameters

️️️️️️✔️

Apply a parameter template

️️️️️️✔️

High-performance parameter templates

️️️️️️✔️

Transaction system optimization

DDL performance optimization

DDL usability optimization

High concurrency optimization

Feature

Cluster Edition

Concurrency Control

️️️️️️✔️

Inventory Hint

️️️️️️✔️

Statement Queue

️️️️️️✔️

Hot row optimization

️️️️️️✔️

Thread Pool

️️️️️️✔️

Performance monitoring

Feature

Cluster Edition

Performance Agent

SQL Trace

Other features

Feature

Cluster 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

Data migration

✔️

Data synchronization

Feature

Cluster Edition

Data synchronization

️️️️️️✔️

Cluster management

Feature

Cluster 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

Register and log on to an Alibaba Cloud account

️️️️️️✔️

Create and authorize a RAM user

️️️️️️✔️

Create and manage a database account

️️️️️️✔️

Manage database accounts for a cluster

️️️️️️✔️

Data security and encryption

Feature

Cluster 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

Database Management

️️️️️️✔️

PolarProxy Enterprise Edition

Feature

Cluster Edition

Manage the endpoints of a cluster

️️️️️️✔️

Connect to a cluster.

️️️️️️✔️

Private domain names

️️️️️️✔️

Read/write splitting

️✔️

Configure PolarProxy

️✔️

Overload protection

️✔️

Cold data archiving

Multi-master Cluster (Database/Table) Edition

X-Engine Edition

Feature

Cluster Edition

X-Engine Edition usage

Global database networks

Feature

Cluster Edition

Create and release a GDN

️✔️

Manage a secondary cluster

️✔️

Connect to a GDN

️✔️

Failover with hot standby

Feature

Cluster Edition

Failover with hot standby overview

️✔️

Flashback queries

Feature

Cluster Edition

Flashback queries

️️️️️️✔️

HTAP

Feature

Cluster Edition

Elastic parallel queries

IMCIs

PolarDB for AI

Feature

Cluster Edition

PolarDB for AI

️✔️

Cluster recycle bin

Feature

Cluster Edition

Restore a released cluster

️️️️️️✔️

Delete a released cluster

️️️️️️✔️

Monitoring and optimization

Feature

Cluster 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

Minor version update

️️️️️️✔️

Major version upgrade

️️️️️️✔️

Scheduled O&M events

Feature

Cluster Edition

View and manage scheduled events

️️️️️️✔️

Parameter configuration

Feature

Cluster Edition

Specify cluster and node parameters

️️️️️️✔️

Apply a parameter template

️️️️️️✔️

High-performance parameter templates

️️️️️️✔️

Transaction system optimization

Feature

Cluster Edition

CTS

Global consistency (high-performance mode)

️✔️

DDL performance optimization

Feature

Cluster 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

DDL usability optimization

High concurrency optimization

Feature

Cluster Edition

Concurrency Control

️️️️️️✔️

Inventory Hint

️️️️️️✔️

Statement Queue

️️️️️️✔️

Hot row optimization

️️️️️️✔️

Thread Pool

️️️️️️✔️

Performance monitoring

Feature

Cluster Edition

Performance Agent

SQL Trace

Other features

Feature

Cluster Edition

Table recycle bin

Fast Query Cache

️️️️️️✔️

Statement Outline

️️️️️️✔️

Returning

️️️️️️✔️

Readable Protobuf

MySQL 8.0

Features supported by different editions:

Data migration

Feature

Cluster Edition

Multi-master Cluster (Database/Table) Edition

Data migration

✔️

️️️️️️✔️

Data synchronization

Feature

Cluster Edition

Multi-master Cluster (Database/Table) Edition

Data synchronization

️️️️️️✔️

️️️️️️✔️

Cluster management

Feature

Cluster Edition

Multi-master Cluster (Database/Table) 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

Register and log on to an Alibaba Cloud account

️️️️️️✔️

️️️️️️✔️

Create and authorize a RAM user

️️️️️️✔️

️️️️️️✔️

Create and manage a database account

️️️️️️✔️

️️️️️️✔️

Manage database accounts for a cluster

️️️️️️✔️

️️️️️️✔️

Data security and encryption

Feature

Cluster Edition

Multi-master Cluster (Database/Table) 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

Database Management

️️️️️️✔️

️️️️️️✔️

PolarProxy Enterprise Edition

Feature

Cluster Edition

Multi-master Cluster (Database/Table) Edition

Manage the endpoints of a cluster

️️️️️️✔️

️️️️️️✔️

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

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

Enable cold data archiving

️️️️️️✔️

️️️️️️️️✔️

Archive cold data

️️️️️️✔️

️️️️️️️️✔️

Data lifecycle management (DLM)

️✔️

High availability

Feature

Cluster Edition

Multi-master Cluster (Database/Table) Edition

Architecture for multi-zone deployment

️️️️️️✔️

️️️️️️️️✔️

Change the primary zone and vSwitch of a cluster

️✔️

Cross-zone automatic switchover

️✔️

Multi-node deployment and Automatic failover and manual failover

️️️️️️✔️

️️️️️️✔️

Multi-master Cluster (Database/Table) Edition

Feature

Cluster Edition

Multi-master Cluster (Database/Table) Edition

Multi-master Cluster (Database/Table) Edition usage

️✔️

X-Engine Edition

Feature

Cluster Edition

Multi-master Cluster (Database/Table) Edition

X-Engine Edition usage

Global database networks

Feature

Cluster Edition

Multi-master Cluster (Database/Table) Edition

Create and release a GDN

️✔️

Manage a secondary cluster

️✔️

Connect to a GDN

️✔️

Backup and restoration

Feature

Cluster Edition

Multi-master Cluster (Database/Table) 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

Failover with hot standby overview

️✔️

Flashback queries

Feature

Cluster Edition

Multi-master Cluster (Database/Table) Edition

Flashback queries

️️️️️️✔️

️️️️️️✔️

HTAP

Feature

Cluster Edition

Multi-master Cluster (Database/Table) Edition

Elastic parallel queries

️✔️

IMCIs

️✔️

PolarDB for AI

Feature

Cluster Edition

Multi-master Cluster (Database/Table) Edition

PolarDB for AI

️✔️

Cluster recycle bin

Feature

Cluster Edition

Multi-master Cluster (Database/Table) Edition

Restore a released cluster

️️️️️️✔️

️️️️️️✔️

Delete a released cluster

️️️️️️✔️

️️️️️️✔️

Monitoring and optimization

Feature

Cluster Edition

Multi-master Cluster (Database/Table) 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

Minor version update

️️️️️️✔️

️️️️️️✔️

Major version upgrade

️✔️

Scheduled O&M events

Feature

Cluster Edition

Multi-master Cluster (Database/Table) Edition

View and manage scheduled events

️️️️️️✔️

️️️️️️✔️

Parameter configuration

Feature

Cluster Edition

Multi-master Cluster (Database/Table) 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

CTS

️✔️

Global consistency (high-performance mode)

️✔️

DDL performance optimization

Feature

Cluster Edition

Multi-master Cluster (Database/Table) 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

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

View the execution status of DDL statements and metadata locks

️️️️️️✔️

️️️️️️️️✔️

Partitioned tables

Feature

Cluster Edition

Multi-master Cluster (Database/Table) 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

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

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

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

Concurrency Control

️️️️️️✔️

️️️️️️✔️

Inventory Hint

️️️️️️✔️

️️️️️️✔️

Statement Queue

️️️️️️✔️

️️️️️️✔️

Hot row optimization

️️️️️️✔️

️️️️️️️️✔️

Thread Pool

️️️️️️✔️

️️️️️️✔️

Performance monitoring

Feature

Cluster Edition

Multi-master Cluster (Database/Table) Edition

Performance Agent

️✔️

SQL Trace

️️️️️️✔️

️️️️️️✔️

Other features

Feature

Cluster Edition

Multi-master Cluster (Database/Table) Edition

Table recycle bin

️️️️️️✔️

️️️️️️✔️

Fast Query Cache

️️️️️️✔️

️️️️️️✔️

Statement Outline

️️️️️️✔️

️️️️️️✔️

Returning

Readable Protobuf

️✔️