All Products
Search

This Product

    AnalyticDB:Benefits

    Document Center

    AnalyticDB:Benefits

    Last Updated:Aug 25, 2026

    AnalyticDB for MySQL is highly compatible with MySQL, makes data queryable within milliseconds of ingestion, resolves complex analytical queries in under a second, and provides decoupled storage-compute elasticity with a unified lakehouse platform.

    MySQL compatibility — zero-friction migration

    AnalyticDB for MySQL is compatible with MySQL protocols and the SQL:92, SQL:99, and SQL:2003 standards. You can migrate existing MySQL workloads without changing application code.

    • Connect with standard SQL through common BI tools and ETL platforms — no proprietary query language to learn.

    • A variety of data import and export methods, job development, and data visualization are available in one environment.

    Decoupled storage and compute

    AnalyticDB for MySQL separates storage from computing. You can scale each layer independently: add computing nodes during query peaks and scale back when idle — you pay only for what you use.

    • Scheduled and on-demand elasticity let you match computing resources to workload patterns without upfront capacity planning.

    • Tiered hot and cold data storage keeps frequently accessed data on high-performance media and automatically moves aging data to lower-cost storage, so storage billing reflects actual usage.

    Real-time ingestion, sub-second queries

    Data is queryable within milliseconds of ingestion and complex analytical queries return in under a second, powering real-time dashboards, interactive exploration, and online reporting.

    Unified lakehouse platform

    Run both high-performance online analytics and large-scale batch processing on the same platform, eliminating the need to move data between separate systems.

    • Scheduled and on-demand resource groups let you shift computing capacity between analytical and batch workloads, raising utilization and lowering cost.

    • Unified billing, metadata, permissions, and data pipelines mean one environment to manage instead of many.

    • A built-in Serverless Spark engine handles batch processing through on-demand resources — no need to provision a standalone Spark cluster. Results are written directly to internal storage and are immediately available for online analysis.

    • Support for Apache Hudi enables near-real-time incremental processing on low-cost OSS storage, with built-in data ingestion to the data lake.