All Products
Search

This Product

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

    Document Center

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

    Last Updated:Mar 28, 2026

    Use this page to confirm feature availability before selecting a version or edition of PolarDB for MySQL.

    Some features require a minimum engine revision version. Check the prerequisites for each feature before use.

    The table below shows feature compatibility across versions and editions. ✔️ means supported. ❌ means not supported.

    FeaturePolarDB for MySQL 5.6PolarDB for MySQL 5.7PolarDB for MySQL 8.0.1PolarDB for MySQL 8.0.2
    Enterprise Edition — Cluster EditionEnterprise Edition — Cluster EditionStandard Edition — Cluster EditionEnterprise Edition — Cluster EditionStandard Edition — Multi-master Cluster (Limitless) EditionEnterprise Edition — Cluster EditionStandard Edition — Cluster EditionEnterprise Edition — Multi-master Cluster (Limitless) EditionStandard Edition
    Serverless❌✔️✔️✔️❌✔️✔️❌❌
    Cluster management
    Custom purchase and Purchase a subscription cluster✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Release a cluster✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Clone a cluster✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Enable binary logging✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Set a maintenance window✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Manage 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✔️✔️✔️✔️✔️✔️✔️✔️✔️
    View and manage scheduled events✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Data migration✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Data synchronization✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Account management
    Register and log on to an Alibaba Cloud account✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Create and grant permissions to a RAM user✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Create and manage a database account✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Manage the password of a database account✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Data security and encryption
    Configure an IP whitelist✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Configure SSL encryption✔️✔️✔️✔️❌✔️✔️❌✔️
    Configure TDE for a PolarDB cluster✔️✔️✔️✔️❌✔️✔️❌✔️
    SQL firewalls✔️✔️✔️✔️❌✔️✔️❌✔️
    Dynamic data masking✔️✔️✔️✔️❌✔️✔️❌✔️
    PolarDB Always-confidential✔️✔️✔️✔️❌✔️✔️❌✔️
    PolarProxy
    Manage the endpoints of a cluster✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Connect to a cluster✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Private domain names✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Read/write splitting✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Configure PolarProxy✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Overload protection✔️✔️✔️✔️❌✔️✔️❌✔️
    Database management✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Change of cluster configurations
    Manually change the specifications of a cluster✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Auto scaling for clusters that do not support serverless✔️✔️✔️✔️❌✔️✔️❌✔️
    Auto scaling by using DAS✔️✔️✔️✔️❌✔️✔️❌✔️
    Add or remove read-only nodes✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Perform a temporary cluster upgrade✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Upgrade an Archive Database Standalone Edition cluster to an Archive Database Cluster Edition cluster❌❌❌✔️❌✔️✔️❌✔️
    Cold data archiving
    Enable cold data archiving❌❌❌✔️✔️✔️✔️✔️✔️
    Manually archive cold data in the CSV format❌❌❌✔️✔️✔️✔️✔️✔️
    Data lifecycle management (DLM)❌❌❌✔️❌✔️✔️❌✔️
    OSS foreign tables❌❌❌✔️✔️✔️✔️✔️✔️
    High availability
    Multi-zone deployment architecture✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Manually change the primary or secondary zone✔️✔️✔️✔️❌✔️✔️❌✔️
    Use the cross-zone automatic switchover feature✔️✔️✔️✔️❌✔️✔️❌✔️
    Multi-node deployment architecture and Automatic failover and manual failover✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Multi-master Cluster (Limitless) Edition
    Multi-master Cluster (Limitless)❌❌❌❌✔️❌❌✔️❌
    Add or delete a global read-only node❌❌❌❌✔️❌❌✔️❌
    X-Engine❌❌❌✔️❌❌✔️❌❌
    Global database networks (GDNs)
    Create and release a GDN✔️✔️✔️✔️❌✔️✔️❌✔️
    Manage a secondary cluster✔️✔️✔️✔️❌✔️✔️❌✔️
    Connect to a GDN✔️✔️✔️✔️❌✔️✔️❌✔️
    Backup and restoration
    Backup method 1: Automatic backup✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Backup method 2: Manual backup✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Method 1 for full restoration: Restore data from a backup set✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Method 2 for full restoration: Restore data to an earlier point in time✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Method 1 for database and table restoration: Restore data from a backup set✔️✔️✔️✔️❌✔️✔️❌✔️
    Method 2 for database and table restoration: Restore data to an earlier point in time✔️✔️✔️✔️❌✔️✔️❌✔️
    Flashback queries✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Failover with hot replica✔️✔️✔️✔️❌✔️✔️❌✔️
    Elastic parallel query❌❌❌✔️❌✔️✔️❌✔️
    Parallel queries
    Hash joins in parallel queries❌❌❌❌❌✔️✔️❌✔️
    Use Semijoins to accelerate parallel queries❌❌❌✔️✔️✔️✔️✔️✔️
    Use window functions to accelerate parallel queries❌❌❌✔️❌✔️✔️❌✔️
    Use the ROLLUP syntax to accelerate parallel queries❌❌❌✔️✔️✔️✔️✔️✔️
    IMCIs❌❌❌✔️✔️✔️✔️✔️✔️
    PolarDB for AI❌❌❌✔️❌❌✔️❌❌
    Cluster recycle bin
    Restore a released cluster✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Delete a released cluster✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Autonomy center✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Session management✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Real-time Monitoring✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Monitoring and optimization
    Storage analysis✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Deadlock analysis✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Diagnostic reports✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Performance Insight (original version)✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Performance insight (new)✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Performance monitoring✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Slow SQL queries✔️✔️✔️✔️✔️✔️✔️✔️✔️
    SQL Explorer and Audit✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Version management
    Revision version✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Major version upgrades✔️✔️✔️✔️❌✔️✔️❌✔️
    Cluster parameters
    Configure cluster and node parameters✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Apply a parameter template✔️✔️✔️✔️✔️✔️✔️✔️✔️
    High-performance parameter templates✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Transaction system optimization
    CTS❌❌❌✔️❌✔️✔️❌❌
    PolarDB-SCC❌✔️✔️✔️❌✔️✔️❌❌
    DDL performance optimization
    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
    Nonblocking DDL statements❌❌❌✔️✔️✔️✔️✔️✔️
    DDL physical replication optimization❌✔️✔️✔️✔️✔️❌✔️❌
    Async metadata lock replication✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Prevent long-running transactions on read-only nodes from blocking DDL operations✔️✔️✔️✔️✔️✔️✔️✔️✔️
    DDL ease of use optimization
    Preemptive DDL❌❌❌✔️✔️✔️✔️✔️✔️
    View the DDL statement execution status and MDL status❌❌❌✔️✔️✔️✔️✔️✔️
    DDL security optimization
    Table recycle bin❌❌❌✔️✔️✔️✔️✔️✔️
    Partitioned tables
    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 optimizers
    Subquery folding❌❌❌❌❌❌✔️❌✔️
    Convert IN predicates into joins❌❌❌❌❌❌✔️❌✔️
    Subquery unnesting❌❌❌❌❌❌✔️❌✔️
    Left join elimination❌❌❌✔️✔️✔️✔️✔️✔️
    Push down a condition from the HAVING clause to the WHERE clause❌❌❌❌❌❌✔️❌✔️
    Push down a condition from the WHERE clause to derived tables❌❌❌❌❌❌✔️❌✔️
    Join condition pushdown❌❌❌❌❌❌✔️❌✔️
    Cost-based query transformation❌❌❌❌❌❌✔️❌✔️
    Statement outline✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Auto plan cache❌❌❌✔️✔️✔️✔️✔️✔️
    Adaptive execution plan switching❌❌❌✔️✔️✔️❌✔️❌
    LIMIT OFFSET pushdown❌❌❌✔️✔️✔️✔️✔️✔️
    Full predicate pushdown❌❌❌✔️✔️✔️✔️✔️✔️
    Fast traverse❌❌❌✔️✔️✔️✔️✔️✔️
    Bloom filter pushdown❌❌❌❌❌❌✔️❌✔️
    High concurrency optimization
    Concurrency control✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Inventory hints✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Statement queue✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Hot row update optimization✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Thread pool✔️✔️✔️✔️✔️✔️✔️✔️✔️
    B-tree concurrency control optimization❌❌❌✔️✔️✔️✔️✔️✔️
    Performance monitoring
    Performance Agent❌❌❌❌❌❌✔️❌✔️
    SQL Trace❌❌❌✔️✔️✔️✔️✔️✔️
    SQL detail❌❌❌✔️✔️✔️✔️✔️✔️
    Other features
    Tenant management and resource isolation❌❌❌❌❌❌✔️❌✔️
    RDMA-based log shipment❌❌❌✔️✔️✔️❌✔️❌
    Warm Buffer Pool❌❌❌❌❌❌✔️❌✔️
    Fast Query Cache✔️✔️✔️✔️✔️✔️✔️✔️✔️
    Returning❌✔️✔️❌❌❌❌❌❌
    Partial Result Cache❌❌❌❌❌❌✔️❌✔️
    Readable Protobuf❌❌❌❌❌❌✔️❌✔️