This topic provides an overview of features offered by AliSQL, such as a comparison between MySQL versions with AliSQL and other MySQL versions.

Introduction to AliSQL

AliSQL is an independent MySQL branch customized by Alibaba Cloud. In addition to all the features of MySQL Community Edition, AliSQL provides features similar to those of MySQL Enterprise Edition. These similar features include enterprise-level backup and restoration, thread pool, and parallel query. AliSQL also provides features such as sequence engines that are compatible with Oracle. ApsaraDB RDS MySQL uses AliSQL as its kernel to offer all its basic features and the advanced features such as enterprise-level security, backup, restoration, monitoring, performance optimization, and read-only instances.

Features

Category Feature MySQL Community Edition MySQL Enterprise Edition MySQL 5.7 and MySQL 8.0 with AliSQL ApsaraDB RDS MySQL
Enterprise-level value-added services 24/7 support Not supported Supported Supported Supported
Emergency troubleshooting Not supported Supported Supported Supported
Expert support Not supported Supported Supported Supported
MySQL features MySQL Database Server Supported Supported Supported Supported
MySQL Document Store Supported Supported Supported for MySQL 8.0 Supported for MySQL 8.0
MySQL Connectors Supported Supported Supported for versions released to the public Supported for versions released to the public
MySQL Replication Supported Supported Supported Supported
MySQL Router Supported Supported MaxScale supported for MySQL 8.0 Single-tenant database proxy
MySQL Partitioning Supported Supported Supported Supported
Storage Engine

InnoDB

MyISAM

NDB

InnoDB

MyISAM

NDB

InnoDB

X-Engine

InnoDB

X-Engine

Oracle-compatible features Sequence Engine Not supported Not supported Supported for MySQL 8.0 Supported for MySQL 8.0
MySQL Enterprise Monitor Enterprise Dashboard Not supported Supported Under development Enhanced Monitor
Query Analyzer Not supported Supported Under development Performance Insight
Replication Monitor Not supported Supported Under development Supported
Enhanced OS Metrics Not supported Not supported Not supported Enhanced Monitor
MySQL Enterprise Backup Hot backup for InnoDB Not supported Supported Supported Supported
Full, Incremental, Partial, and Optimistic Backups Not supported Supported Supported Database- and table-level backup
Full, Partial, Selective, and Hot Selective Restore Not supported Supported Supported Database- and table-level restoration
Point-In-Time Recovery Not supported Supported Supported Supported
Cross-Region Backup Not supported Not supported Not supported Cross-Region Backup
Recycle bin Not supported Not supported Supported for MySQL 8.0 Supported for MySQL 8.0
Flashback Not supported Not supported Supported Supported
MySQL Enterprise Security Enterprise TDE Local key replacement Supported BYOK TDE and Key Rotating BYOK TDE and Key Rotating
Enterprise Disk Data Encryption at Rest Not supported Not supported Not supported BYOK disk encryption
Enterprise Encryption SSL Supported SSL SSL
Enterprise Audit Not supported Supported SQL Explorer SQL Explorer
SM4 encryption algorithm Not supported Not supported Supported Supported
MySQL Enterprise Scalability Thread Pool Not supported Supported Supported for MySQL 8.0 Supported for MySQL 8.0
Enterprise Read-only Request Extension Not supported Not supported Supported Read-only instances
MySQL Enterprise Reliability SQL Outline Not supported Not supported Supported Supported
Hot Massive Update Not supported Not supported Supported Supported
Hot SQL Limit Not supported Not supported Supported Supported
Hot SQL Firewall Not supported Not supported Supported Supported
MySQL Enterprise High-Availability Enterprise Automatic Failover Switch Not supported Not supported Third-party high-availability mechanism required High-availability Edition
Multi-Source Replication Supported Supported Supported Highly available read-only instances

Versions supported

Version Feature
MySQL 8.0 Performance Insight
Recycle bin
Sequence engine
Statement outline
Statement concurrency control
Thread pool
Purge Large File Asynchronously
Instance lock status optimization
MySQL 5.7 Performance Insight
Changes in MySQL 5.7.26
Instance lock status optimization
MySQL 5.6 Instance lock status optimization