This topic describes the features of AnalyticDB for MySQL.

Before you use AnalyticDB for MySQL, we recommend that you familiarize yourself with terminology such as cluster, node, database, and account to better understand the features of AnalyticDB for MySQL. For more information, see Terms.

Compute engines

Item Description
Xihe analytical computing engine Xihe MPP SQL engine Uses a massively parallel processing (MPP) architecture to compute data for all tasks of a query. Data pipelines are used to implement stream computing to meet low-latency ad hoc analysis requirements.
Xihe BSP SQL engine Uses a batch computing architecture to compute data for each task. Tasks can be divided in a directed acyclic graph (DAG). This engine supports disk storage and is suitable for complex analysis scenarios that involve large amounts of data, high throughput, and limited resources.

Storage engines

Item Description
Xuanwu analytical storage engine (C-Store) Provides enterprise-class data storage with high reliability, high availability, high performance, and low costs. This engine serves as a basis for high-throughput real-time writes and high-performance real-time queries.

Database objects

Item Description
Database Supports multiple databases. For more information, see CREATE DATABASE.
Table group N/A
Table
  • Automatically optimizes the number of shards. You need to only specify the distribution key when you create a table. For more information, see CREATE TABLE.
  • Automatically generates a 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 grave accents (``).
  • 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 remove columns. For more information, see ALTER TABLE.
  • Allows you to change the data type of a column.
  • Allows you to change the comment 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

Item Description
DML

Data types

Item Description
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.
  • Details of multi-value columns can be queried.
  • The JSON format is supported. For more information, see JSON.

Enterprise-class features

Item Description
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 Resource Access Management (RAM) roles.

Accounts and permissions

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

Ecosystem

Item Description
DataWorks Integrates with DataWorks. AnalyticDB for MySQL databases can be used as data sources.
Kettle Improves the data writing performance.
Log Service 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.
Data Transmission Service (DTS)
  • Supports multiple data types and type inference. For more information, see Basic data types.
  • Supports 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

Item Description
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

Item Description
Scalability
  • Specifies the storage capacity. The disk capacity can range from 100 GB to 1,000 GB.
  • Expands storage of disks separately.
  • Scales out or scales in nodes.
Visibility Queries data immediately after the data is written.

Maintainability

Item Description
Monitoring
  • Monitors clusters.
  • Monitors slow SQL queries.
  • Supports SQL audit.
Alerting Sets alert rules. For more information, see Set an alert rule.
Load management Supported.
Set a maintenance window Supported.
Hot update Supported.