This topic describes the features of AnalyticDB for MySQL.

Database objects

Before you use AnalyticDB for MySQL, we recommend that you familiarize yourself with the terms such as cluster, node, database, and account. For more information, see Terms.

Feature Item Description
Database objects Database Supports multiple databases. For more information, see CREATE DATABASE.
Table group N/A
Table
  • Automatically optimizes the number of shards. You only need to specify the distribution key when you create a table. For more information, see CREATE TABLE.
  • Automatically generates the value for the auto-increment column when you add a row. AnalyticDB for MySQL also ensures that this value is the greatest among all node groups.
  • Allows you to use reserved words by quoting them with backticks (`).
  • Allows you to rename a table. For more information, see ALTER TABLE.
  • Supports list and range partitions (coming soon).
  • Allows you to set multiple distribution keys and random distribution keys (coming soon).
Column
  • Allows you to set auto-increment columns. For more information, see CREATE TABLE.
  • Allows you to add and delete columns. For more information, see ALTER TABLE.
  • Allows you to change the data type of a column.
  • Allows you to change the comments of a column. For more information, see ALTER TABLE.
  • Allows you to use an expression without variables as the default value, such as CURRENT_TIMESTAMP.
  • Allows you to change the value constraint for a column from NOT NULL to NULL. For more information, see ALTER TABLE.
  • Allows you to rename a column. For more information, see ALTER TABLE.
View Supported.
Index Allows you to create, modify, and delete indexes. For more information, see ALTER TABLE.
Function The following functions are compatible with MySQL:

DML statements

Feature Item Description
Data manipulation language (DML) statements DML statement

Data types

Feature Item Description
Data types Data type Supports multiple data types. Some data types are optimized in AnalyticDB for MySQL. For more information, see Data types.
  • The maximum value of M in DECIMAL(M,D) is 1000.
  • The TIMESTAMP and DATETIME data types are compatible with MySQL.
  • You can query the details of a multi-value column.
  • The BINARY type is compatible with MySQL (coming soon).
  • The JSON format is supported. For more information, see JSON.

Enterprise-level features

Feature Item Description
Enterprise-level features Time zone Supported.
Configure a whitelist Supported.
Security group Supported.
API Supported.
Resource Access Management (RAM)
  • Supports Security Token Service (STS).
  • Supports custom policies and system policies.
  • Supports RAM roles.
Terraform Supported (coming soon).
Tag Supported (coming soon).
SSL, TDE, and BYOK Supported (coming soon).

Accounts and permissions

Feature Item Description
Accounts and permissions Account types Compatible with the account system of MySQL.
Permission model Compatible with permissions in MySQL. The finest permission granularity is column.

Ecosystem

Feature Item Description
Ecosystem DataWorks Integrates with DataWorks to provide data sources.
Kettle Improves data write performance.
Informatica Supports Informatica (coming soon).
Log Service Supports data transfer from Log Service (coming soon).
Data Transmission Service (DTS)
  • Supports multiple data types, and type inference. For more information, see Data types.
  • Supports data definition language (DDL) statements.
  • Allows you to merge multiple tables.
  • Provides high stability to enhance user experience.
Use the LOAD DATA statement to import local data Compatible with MySQL.
Tableau Supported.
Others Supports 90% of MySQL business intelligence (BI) and client tools.

Consistency

Feature Item Description
Consistency Read and write consistency Uses strong consistency by default.

Availability and reliability

Feature Item Description
Data persistence Triplicate technology Supported.
Full backup Supported.
Log backup Supported.
Backup and restoration Supported.
Zone-disaster recovery Supported (coming soon).

Usability

Feature Item Description
Usability Scalability
  • Allows you to select the disk capacity. The disk capacity ranges from 100 GB to 1,000 GB.
  • Allows you to extend disks separately.
  • Allows you to add or remove nodes as needed.
Visibility Allows you to query data soon after the data is written.
Recycle bin Supported (coming soon).
User-defined function (UDF) Supported (coming soon).

Maintainability

Maintainability Monitoring
  • Allows you to monitor clusters.
  • Allows you to monitor slow SQL queries.
  • Supports SQL auditing (coming soon).
Alerting Allows you to set alert rules. For more information, see Set alert rules.
Load management Supported.
Custom cluster maintenance window Supported.
Hot upgrade Supported.

Performance

Feature Item Description
Performance Write Provides up to 1.5 times the write speed of AnalyticDB for MySQL V2.0.
Query Provides up to 1.4 times the query speed of AnalyticDB for MySQL V2.0.
Concurrency Supports higher concurrency.
Throughput Supports higher data throughput.