This topic provides an overview of the features provided by AliSQL. It also provides a comparison between MySQL versions with AliSQL and other MySQL versions.

Introduction to AliSQL

AliSQL is an independent MySQL branch that is customized by Alibaba Cloud. AliSQL provides all of the features that are available in the MySQL Community Edition and some similar features that you can find in the MySQL Enterprise Edition. These similar features include enterprise-grade backup and restoration, thread pool, and parallel query. AliSQL also provides features such as sequence engines that are compatible with Oracle. ApsaraDB RDS for MySQL with AliSQL provides all the basic features of MySQL and a wide range of advanced features such as enterprise-grade security, backup, restoration, monitoring, performance optimization, and read-only instances.

MySQL versions supported

Feature Description MySQL 8.0 MySQL 5.7 MySQL 5.6
Statement concurrency control The concurrency control (CCL) feature allows you to control the concurrency of statements based on syntax rules. You can install the DBMS_CCL package to use this feature. Supported Supported Not supported
Statement outline The statement outline feature allows you to stably run query plans by using optimizer and index hints. You can install the DBMS_OUTLN package to use this feature. Supported Supported Not supported
A new version is available. The recycle bin feature allows you to temporarily store deleted tables. It also allows you to specify a retention period within which you can retrieve the deleted tables. You can install the DBMS_RECYCLE package to use this feature. Supported Not supported Not supported
Thread Pool The thread pool feature separates threads from sessions. If a large number of sessions are created on your RDS instance, you can run a small number of threads to complete the tasks in active sessions. Supported Supported Supported
Sequence Engine The Sequence engine simplifies the generation of sequence values on your ApsaraDB RDS for MySQL instance. Supported Not supported Supported
Performance Insight The performance insight feature supports load monitoring, association analysis, and performance optimization at the instance level. You can evaluate loads on your ApsaraDB RDS for MySQL instance and resolve performance issues. This allows you to ensure the stability of your RDS instance. Supported Supported Not supported
Purge Large File Asynchronously The Purge Large File Asynchronously feature allows you to asynchronously delete files from your ApsaraDB RDS for MySQL instance. This ensures the stability of your RDS instance. Supported Supported Supported
Returning This returning feature allows data manipulation language (DML) statements to return result sets. You can install the DBMS_TRANS package to use this feature. Supported Not supported Not supported
Statement Queue The statement queue feature allows statements to queue in the same bucket. These statements may be executed on the same resources. For example, these statements are executed on the same row of a table. This reduces overheads from possible conflicts. Supported Supported Not supported
Inventory Hint The inventory hint feature can work with the returning and statement queue features to rapidly commit and roll back transactions. This allows you to increase the throughput of your application. Supported Supported Supported
Performance Agent The performance agent feature is provided as a plug-in of MySQL. You can use this feature to calculate and analyze the performance metrics of your ApsaraDB RDS for MySQL instance. Supported Supported Supported
A new version is available. The fast query cache is a query cache that is developed by Alibaba Cloud based on the native MySQL query cache. The fast query cache uses a new design and implementation mechanism to increase the query performance of your ApsaraDB RDS for MySQL instance. Not supported Supported Not supported
Data Protect The data protect feature controls the permissions on delete operations. This allows you to protect your data from being accidentally deleted. Supported Supported Supported
Binlog in Redo The Binlog in Redo feature synchronously writes binary logs to the redo log file when a transaction is committed. This reduces operations on disks and improves the performance of your ApsaraDB RDS for MySQL instance. Supported Not supported Not supported
Faster DDL The faster DDL feature provides an optimized buffer pool management mechanism. This mechanism reduces the impact of DDL operations on the performance of your ApsaraDB RDS for MySQL instance. This mechanism also increases the number of concurrent DDL operations that are allowed. Supported Supported Supported

Features

Category Feature MySQL Community Edition MySQL Enterprise Edition MySQL 5.7 and MySQL 8.0 with AliSQL ApsaraDB RDS for MySQL
Enterprise-grade 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 proxies supported
MySQL Partitioning Supported Supported Supported Supported
Storage Engine

InnoDB

MyISAM

NDB

InnoDB

MyISAM

NDB

InnoDB

X-Engine

InnoDB

X-Engine

Oracle Compatibility 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, Optimistic Backups Not supported Supported Supported Database- and table-level backup supported
Full, Partial, Selective, Hot Selective restore Not supported Supported Supported Database-level and table-level restoration supported
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 Supported BYOK-based TDE and key rotation supported BYOK-based TDE and key rotation supported
Enterprise Disk Data Encryption at Rest Not supported Not supported Not supported BYOK-based 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 Readonly Request Extention 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 Supported for the RDS High-availability Edition
Multi-Source Replication Supported Supported Supported Highly available read-only instances supported