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 |