All Products
Search
Document Center

ApsaraDB RDS:Overview of AliSQL features

Last Updated:Mar 07, 2024

AliSQL is an independent MySQL branch that is developed by Alibaba Cloud. AliSQL provides all the features of MySQL. AliSQL also provides enterprise-grade features, such as backup and restoration, monitoring, performance optimization, and read-only instances. 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 the features of 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.

Features and MySQL versions

Category

Feature

Description

MySQL 8.0

MySQL 5.7

MySQL 5.6

Functionality

Native Flashback

The native flashback feature allows you to query or restore the data at a specified point in time by executing SQL statements. This way, you can obtain the historical data at your earliest opportunity after accidental operations.

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 ApsaraDB RDS for MySQL instance, the system can run a small number of threads to process the tasks in all active sessions.

Supported

Supported

Supported

Statement Outline

The statement outline feature allows the system to stably run query plans by using optimizer hints 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

Supported

Supported

Returning

The returning feature allows DML statements to return result sets. You can install the DBMS_TRANS package to use this feature.

Supported

Not supported

Not supported

EncDB

The always-confidential feature encrypts the data columns that you want to protect in your RDS instance. This prevents unauthorized users from accessing the plaintext of the protected data columns by using software and tools on the cloud platform.

Not supported

Supported

Not supported

Performance

Fast Query Cache

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 allows the system to write binary logs to the redo log file when transactions are committed. This reduces the operations on the disk and increases 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 the overheads that are caused by potential conflicts.

Supported

Supported

Not supported

Inventory Hint

The inventory hint feature can be used in combination with the returning feature and the statement queue feature to commit and roll back transactions at fast speeds. 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 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 the system 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 an extension for MySQL. This feature is used 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 the system 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 the loads on your RDS instance and resolve performance issues. This increases the stability of your RDS instance.

Supported

Supported

Not supported

Binlog Cache Free Flush

The binlog cache free flush feature is supported. This feature optimizes the commitment of large transactions to prevent excessive lantencies in writing binary logs, prevents your RDS instance from becoming unresponsive, and ensures that your RDS instance remains stable and writable.

Supported

Not supported

Not supported

Security

Recycle Bin

The recycle bin feature allows the system 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

N/A

Emergency troubleshooting

N/A

Expert support

N/A

MySQL Features

MySQL Database Server

MySQL Connectors

Supported for public versions

Supported for public versions

MySQL Replication

MySQL Router

MaxScale supported for MySQL 8.0

Shared proxies supported

MySQL Partitioning

Storage Engine

InnoDB

MyISAM

NDB

InnoDB

MyISAM

NDB

InnoDB

X-Engine

InnoDB

X-Engine

Oracle Compatibility

Sequence Engine

N/A

N/A

Supported for MySQL 8.0

Supported for MySQL 8.0

MySQL Enterprise Monitor

Enterprise Dashboard

N/A

Under development

Enhanced Monitor

Query Analyzer

N/A

Under development

Performance Insight

Replication Monitor

N/A

Under development

Enhanced OS Metrics

N/A

N/A

N/A

Enhanced Monitor

MySQL Enterprise Backup

Hot backup for InnoDB

N/A

Full, Incremental, Partial, Optimistic Backups

N/A

Database- and table-level backup supported

Full, Partial, Selective, Hot Selective restore

N/A

Database- and table-level restoration supported

Point-In-Time-Recovery

N/A

Cross-Region Backup

N/A

N/A

N/A

Cross-region backup supported

Recycle bin

N/A

N/A

Supported for MySQL 8.0

Supported for MySQL 8.0

Flashback

N/A

N/A

MySQL Enterprise Security

Enterprise TDE

Local key replacement supported

BYOK-based TDE and key rotation supported

BYOK-based TDE and key rotation supported

Enterprise Disk Data Encryption at Rest

N/A

N/A

N/A

BYOK-based disk encryption supported

Enterprise Encryption

SSL

SSL

SSL

SQL Explorer

N/A

️SQL Explorer

️SQL Explorer

SM4 encryption algorithm

N/A

N/A

EncDB

N/A

N/A

Supported for MySQL 5.7

Supported for MySQL 5.7

MySQL Enterprise Scalability

Thread Pool

N/A

Supported for MySQL 8.0

Supported for MySQL 8.0

Enterprise Readonly Request Extention

N/A

N/A

Read-only instances supported

MySQL Enterprise Reliability

Statement Outline

N/A

N/A

Inventory Hint

N/A

N/A

Statement Concurrency Control

N/A

N/A

Hot SQL Firewall

N/A

N/A

MySQL Enterprise High-Availability

Enterprise Automatic Failover Switch

N/A

N/A

Third-party high-availability mechanism required

RDS High-availability Edition

Multi-Source Replication

Highly available read-only instances supported

References