AnalyticDB:Editions

Over the past five years, AnalyticDB for MySQL has launched several editions: Data Warehouse Edition (reserved mode), Data Warehouse Edition (elastic mode), Data Lakehouse Edition, and the newer Enterprise Edition and Basic Edition. The following figure shows the evolution of these editions.

The earliest edition, Data Warehouse Edition (reserved mode), uses a storage-compute coupled architecture. It delivers high-performance queries but does not support independent scaling of computing or storage resources.

To enable scaling of computing resources—up for performance during peak hours and down for cost savings during off-peak hours—AnalyticDB for MySQL introduced the Data Warehouse Edition (elastic mode), which is based on a storage-compute decoupled architecture. This edition not only enables elastic scaling of computing resources but also supports physical isolation of computing resources by resource group to meet the needs of multi-tenant and hybrid workloads.

In recent years, to meet the growing demand for analyzing semi-structured and unstructured data such as log data, AnalyticDB for MySQL launched Data Lakehouse Edition based on elastic mode. It includes a Spark compute engine for offline big data processing.

The newly launched Enterprise Edition and Basic Edition combine the advantages of Data Warehouse Edition (reserved mode), Data Warehouse Edition (elastic mode), and Data Lakehouse Edition. Their reserved resources use a storage-compute coupled architecture to ensure query performance for steady workloads. If the workload has periodic or sudden changes, you can elastically scale computing resources up or down.

Enterprise Edition

Enterprise Edition is a converged upgrade of Data Lakehouse Edition and Data Warehouse Edition, offering the same features as Data Lakehouse Edition. It supports resource group isolation, flexible resource scaling, and tiered storage in elastic mode, as well as the high-throughput real-time writes and high-concurrency online queries of reserved mode.

Enterprise Edition is a multi-replica edition with multi-replica underlying storage. It provides distributed capabilities and high availability, making it suitable for the development, testing, and production environments of various enterprises.

Basic Edition

Basic Edition is a single-replica edition with the same features as Enterprise Edition. However, it uses single-replica underlying storage and does not provide high availability. It is suitable for workloads that do not require high data availability and seek low-cost hot data storage.

Basic Edition currently does not support changing its configuration to Enterprise Edition.

Data Lakehouse Edition

Data Lakehouse Edition is built on a storage-compute decoupled architecture, providing a lakehouse solution that offers both low-cost offline processing and high-performance online analytics. Building on Data Warehouse Edition (elastic mode), it offers comprehensive upgrades in data ingestion, storage, computing, and applications. By using a single copy of the full dataset at the underlying storage layer, it supports both offline and online scenarios, which eliminates data consistency and timeliness issues that arise from data synchronization. It also physically isolates computing resources between offline and online services and supports scheduled or auto scaling of computing and storage resources. It provides a Spark compute engine with standard interfaces and multi-language programming for large-scale batch processing. Furthermore, it offers a visual interface for configuring real-time data synchronization from source systems to the lake (Hudi on OSS) or the warehouse (C-Store).

Data Lakehouse Edition is a cluster edition suitable for business scenarios such as offline processing (preprocessing operations like data cleansing and data standardization), multi-source aggregate analysis, wide table development, and predictive insights (machine learning and AI).

Data Warehouse Edition

View cluster edition

In the AnalyticDB for MySQL console, go to the Cluster Information page for your cluster. The edition and deployment mode are listed in the Cluster Attributes section.

For example, the Edition is Enterprise Edition, and the Deployment Mode is Single-AZ.

What affects cluster availability?

Unexpected node termination, configuration changes (such as disk expansion or instance type changes), and version upgrades can affect availability.

Which editions support configuration changes?

• Data Warehouse Edition and Data Lakehouse Edition support changing the configuration to Enterprise Edition or Basic Edition.

• Data Warehouse Edition (reserved mode) supports changing the configuration to elastic mode.

AnalyticDB for MySQL billing

For details on billing, see Billing overview.