AnalyticDB:Common scenarios

Build a real-time data warehouse

Managing real-time and batch workloads on separate stacks drives up architecture complexity, development effort, and operations and maintenance (O&M) costs. You also need elastic resource allocation so idle capacity during off-peak hours does not inflate your bill.

AnalyticDB for MySQL unifies both workloads on a single platform:

Unified real-time and batch processing

AnalyticDB for MySQL supports both online transaction processing (OLTP) and online analytical processing (OLAP) workloads. Data can be inserted, updated, and deleted in real time, with real-time analytics running alongside ETL jobs. Resource groups isolate batch and real-time tasks to keep each workload stable.

Independent scaling of compute and storage

AnalyticDB for MySQL uses a decoupled architecture, so you scale compute and storage independently based on actual demand — cutting idle resource costs while maintaining fine-grained control.

Run precision marketing analytics

Marketing teams need to track user growth, activity, and retention across channels in real time to measure return on investment (ROI) quickly and accurately. Faster feedback loops mean faster product iterations, better-targeted campaigns, and higher overall revenue.

AnalyticDB for MySQL supports this with:

Real-time data ingestion from multiple sources

Structured and unstructured data from multiple data sources can be synchronized to AnalyticDB for MySQL in real time.

Real-time feedback on marketing effectiveness

AnalyticDB for MySQL runs contextual computing on logs and business data as they arrive, so marketing teams get timely feedback on campaign performance without waiting for batch jobs to complete.

Power BI dashboards and reports

BI workloads require ingesting and processing large volumes of data with minimal latency, then serving the results to a wide range of visualization tools. Teams expect reports and dashboards to reflect current data.

AnalyticDB for MySQL is built for this:

Millisecond-level writes and query availability

AnalyticDB for MySQL writes millions of rows per second and makes them available for query within milliseconds. Query results are returned within milliseconds to seconds.

Broad compatibility with BI tools

AnalyticDB for MySQL is highly compatible with MySQL and the SQL:2003 standard. It works with dozens of mainstream BI tools, including Tableau, FineReport, and Quick BI.

Query across multiple data sources

Migrating to a cloud data warehouse requires setting up data synchronization from multiple sources, and querying across sharded databases adds complexity. AnalyticDB for MySQL simplifies both.

Wide data source support

AnalyticDB for MySQL integrates data from:

Simple warehouse setup

Data from ApsaraDB RDS, PolarDB for MySQL, or a Logstore in Log Service can be synchronized to an AnalyticDB for MySQL cluster with minimal configuration. Data from multiple databases and tables can be aggregated into a single table for global analysis.

Run interactive ad hoc queries

Interactive analytics requires multi-dimensional queries to return results fast enough to feel responsive — users drilling into dashboards or running ad hoc queries should not wait. Data must be analysis-ready to support exploratory workflows.

AnalyticDB for MySQL delivers the response times and query depth this requires:

Sub-second JOIN performance

Results for queries involving JOINs are returned within milliseconds or seconds, keeping applications smooth and responsive.

High-dimensional query support

AnalyticDB for MySQL handles queries spanning thousands of dimensions, with dozens of tables and thousands of rows joined in a single query.