Functions and features

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: Numeric functions Arithmetic operators String functions Date and time functions Control flow functions Aggregate functions Bit functions and operators Window functions

DML

Item	Description
DML	Supports the INSERT INTO, REPLACE INTO, INSERT SELECT FROM, UPDATE, and DELETE statements. Supports the TRUNCATE TABLE statement. Supports the KILL PROCESS statement for load management.

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.