This topic provides an overview of the features that are provided by AliSQL. This topic also provides a comparison between AliSQL and other MySQL versions.
Introduction to AliSQL
AliSQL is an independent MySQL branch that is developed by Alibaba Cloud. AliSQL provides all of the features that are available in the MySQL Community edition. AliSQL also provides 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. In addition, AliSQL provides Oracle-compatible features, such as the Sequence engine. ApsaraDB RDS for MySQL with AliSQL provides all the basic features of MySQL and a wide range of advanced features. These advanced features include enterprise-grade security, backup and restoration, monitoring, performance optimization, and read-only instance.
Features and supported MySQL versions
| Category | Feature | Description | MySQL 8.0 | MySQL 5.7 | MySQL 5.6 |
|---|---|---|---|---|---|
| Functionality | Thread Pool | The thread pool feature separates threads from sessions. If a large number of sessions are created on your RDS instance, ApsaraDB RDS can run a small number of threads to complete the tasks in active sessions. | Supported | Supported | 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 | |
| Sequence Engine | The Sequence engine simplifies the generation of sequence values on your RDS instance. | Supported | Not 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 | |
| Performance | 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 a new implementation mechanism to increase the query performance of your RDS instance. | Not supported | Supported | Not 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 the operations on the disk and improves the performance of your RDS instance. | 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 feature 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 increases the throughput of your application. | Supported | Supported | Supported | |
| Stability | Faster DDL | The faster DDL feature provides an optimized buffer pool management mechanism. This mechanism reduces the impact of data definition language (DDL) operations on the performance of your RDS instance. This mechanism also increases the number of concurrent DDL operations that are allowed. | Supported | Supported | Supported |
| Statement concurrency control | The concurrency control (CCL) feature allows ApsaraDB RDS 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 | |
| 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 RDS instance. | Supported | Supported | Supported | |
| Purge Large File Asynchronously | The Purge Large File Asynchronously feature allows ApsaraDB RDS to asynchronously delete files from your RDS instance. This ensures the stability of your RDS instance. | Supported | 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 RDS instance and resolve performance issues. This allows you to improve the stability of your RDS instance. | Supported | Supported | Not supported | |
| Security | Data Protect | The data protection feature controls the permissions on delete operations. This allows you to protect your data from being accidentally deleted. | Supported | Supported | Supported |
| Recycle bin | The recycle bin feature allows ApsaraDB RDS 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 |
Features
| Category | Feature | MySQL Community edition | MySQL Enterprise edition | AliSQL (MySQL 5.7 and MySQL 8.0) | 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- 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 supported | |
| 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 supported | |
| Enterprise Encryption | SSL | Supported | SSL | SSL | |
| SQL Explorer | Not supported | Supported | SQL Explorer supported | SQL Explorer supported | |
| 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 supported | |
| MySQL Enterprise Reliability | Statement outline | Not supported | Not supported | Supported | Supported |
| Inventory Hint | Not supported | Not supported | Supported | Supported | |
| Statement concurrency control | 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 |