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. 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 need only 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.
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.
Functions The following functions are fully compatible with MySQL:

DML

Feature Item Description
DML DML

Data type

Feature Item Description
Data type 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 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 Supported.
RAM
  • Supports Security Token Service (STS).
  • Supports custom policies and system policies.
  • Supports RAM roles.

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.
SLS Uses 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.
DTS
  • Supports multiple data types, and type inference. For more information, see Basic data types.
  • Supports data definition language (DDL) statements.
  • Merges 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 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.

Usability

Feature Item Description
Usability Scalability
  • Selects the storage capacity. The disk capacity ranges from 100 GB to 1,000 GB.
  • Extends disks separately.
  • Scales out or scales in nodes.
Visibility Queries data immediately after the data is written.

Maintainability

Maintainability Monitoring
  • Monitors clusters.
  • Monitors slow SQL queries.
  • Supports SQL auditing.
Alert Sets alert rules. For more information, see Set an alert rule.
Load management Supported.
Custom cluster maintenance window Supported.
Hot upgrade Supported.