AnalyticDB for MySQL is developed based on an architecture that integrates data warehouse and lakehouse services and provides real-time data analysis capabilities. AnalyticDB for MySQL is highly compatible with MySQL, and can update data within milliseconds and respond to queries within sub-seconds.
The unique design of AnalyticDB for MySQL allows you to aggregate and analyze structured, semi-structured, and unstructured data from data lakes and databases. AnalyticDB for MySQL can simultaneously perform high-throughput batch processing and high-performance, real-time analysis, which reduces costs and improves efficiency.
Video introduction
Editions
AnalyticDB for MySQL launches Data Warehouse Edition in reserved mode, Data Warehouse Edition in elastic mode, Data Lakehouse Edition, Enterprise Edition, and Basic Edition over five years of evolution. For more information, see Editions.
Features
AnalyticDB for MySQL leverages the in-house XIHE compute engine and XUANWU storage engine to provide features such as SQL audit, monitoring and alerting, SQL diagnostics, and data import and export. AnalyticDB for MySQL also supports Apache Spark and Apache Hudi for real-time data lake ingestion. For more information, see Functions and features.
Usage
The following methods are available for managing AnalyticDB for MySQL clusters. You can use one of the methods to perform operations, such as creating clusters and accounts, configuring networks, and creating and managing resource groups.
Console: The AnalyticDB for MySQL console is a friendly web-based GUI. Log on to the AnalyticDB for MySQL console.
SDK: You can use SDKs as an alternative to the AnalyticDB for MySQL console to manage your resources. The SDKs can perform all operations available in the AnalyticDB for MySQL console. For more information, see Integration overview.
API: You can use the AnalyticDB for MySQL API as an alternative to the AnalyticDB for MySQL console to manage your resources. The API can perform most of the operations available in the AnalyticDB for MySQL console. For more information, see API reference (Data Warehouse Edition) and API reference (Data Lakehouse Edition).
Getting started
The first time you use AnalyticDB for MySQL, we recommend that you read the topics in Getting Started to become familiar with the entire procedure for using the service.