This topic describes the enhanced 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. This helps you understand the features of AnalyticDB for MySQL.

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, which is available soon.
  • Allows you to set multiple distribution keys and random distribution keys, which is available soon.
Column
  • Allows you to set auto-increment columns. For more information, see ALTER 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 fully 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 Basic 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 data type is compatible with MySQL, which is available soon.
  • The JSON format is supported. For more information, see JSON.

Enterprise-class features

Feature Item Description
Enterprise-class features Time zone Supported.
Configure a whitelist Supported.
Security group Supported.
API operation Supported.
Resource Access Management (RAM)
  • Supports Security Token Service (STS).
  • Supports custom policies and system policies.
  • Supports RAM roles.
Terraform Supported. This item is available soon.
Tag Supported. This item is available soon.
SSL encryption, Transparent data encryption (TDE), and bring your own key (BYOK) Supported. This item is available 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. AnalyticDB for MySQL databases can be used as data sources.
Kettle Improves the data write performance.
Informatica Supports Informatica, which is available soon.
Log Service Allows you to use Log Service to transfer log data to AnalyticDB for MySQL. For more information, see Use Log Service to transfer log data to AnalyticDB for MySQL.
Data Transmission Service (DTS)
  • Supports multiple data types, and type inference. For more information, see Basic data types.
  • Supports data definition language (DDL) statements.
  • Allows you to merge multiple tables.
  • Provides high stability to enhance user experience.
Support for the LOAD DATA statement to import local data Compatible with MySQL.
Tableau Supported.
Others Supports 90% of the MySQL business intelligence (BI) and client tools. For more information, see Yonghong BI and DBeaver.

Consistency

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

Availability and reliability

Feature Item Description
Data persistence Triplicate storage Supported.
Full backup Supported.
Log backup Supported.
Backup and restoration Supported.
Zone-disaster recovery Supported. This item is available soon.

Usability

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

Maintainability

Maintainability Monitoring
  • Allows you to monitor clusters.
  • Allows you to monitor slow SQL queries.
  • Supports SQL auditing.
Alerting Allows you to set alert rules. For more information, see Set an alert rule.
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 than AnalyticDB for MySQL V2.0.
Throughput Supports higher data throughput than AnalyticDB for MySQL V2.0.