All Products
Search
Document Center

AnalyticDB for MySQL:What is AnalyticDB for MySQL?

Last Updated:Jul 24, 2024

AnalyticDB for MySQL is a cloud-native, enterprise-grade data warehouse service that integrates database and big data capabilities. AnalyticDB for MySQL is highly compatible with MySQL. In AnalyticDB for MySQL, you can query data within milliseconds after the data is written, and queries can be processed in less than a second.

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 is available in Data Lakehouse Edition and Data Warehouse Edition. 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.