All Products
Search
Document Center

AnalyticDB:Benefits

Last Updated:Sep 09, 2024

This topic describes the core benefits of AnalyticDB for MySQL.

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.

High elasticity and extensibility

AnalyticDB for MySQL is built on a cloud-native architecture, decoupling storage and computing resources. This allows you to separately scale computing and storage resources on demand, so that you can rightsize your application and solve individual bottlenecks at relatively lower costs.

High performance at low costs

  • In AnalyticDB for MySQL, data becomes queryable milliseconds after it is written, even in large amounts, and strong data consistency is ensured.

  • AnalyticDB for MySQL can handle operations on large amounts of data within seconds or milliseconds, delivering a performance for complex queries that is 10 times faster than relational databases.

  • AnalyticDB for MySQL is highly flexible and allows you to change cluster configurations as your business evolves. You can scale clusters based on a schedule or on demand. In addition, AnalyticDB for MySQL supports tiered storage of hot and cold data. You are billed for the actual storage usage, which significantly reduces computing and storage costs.

Data Lakehouse

  • Data Lakehouse Edition supports integrated resource scheduling. You can use scheduled scaling and on-demand scaling to rightsize computing resources for data analysis and processing. This increases resource utilization and reduces resource costs.

  • Data Lakehouse Edition offers a consistent user experience. You can use consistent billing units, metadata, permissions, programming languages, and transmission links to improve development efficiency.

Serverless Spark

  • Data Lakehouse Edition uses a standardized interface to implement features of the multi-language programmable Spark compute engine.

  • The Spark engine is integrated with the computing resources and data storage of AnalyticDB for MySQL. You can use Serverless Spark to perform low-cost batch processing based on on-demand scaling of computing resources and write data directly to internal storage for real-time analysis.

Open storage

Data Lakehouse Edition supports the Hudi framework for cost-effective, near-real-time batch data updates. Data Lakehouse Edition supports the open source Hudi framework to implement near-real-time processing for incremental data and data ingestion based on the low-cost Object Storage Service (OSS).

Ease of use

  • AnalyticDB for MySQL is highly compatible with MySQL protocols and the SQL:92, SQL:99, and SQL:2003 standards. You can easily get started with AnalyticDB for MySQL by using standard SQL statements, common BI tools, and extract, transform, load (ETL) tools.

  • AnalyticDB for MySQL provides a variety of methods to import or export data and serves as a one-stop platform for Job development and data visualization.