AnalyticDB for MySQL V3.0 is a new version developed based on the service and application development experience gained from AnalyticDB for MySQL V2.0.
Integrated with the advantages of distributed architecture, elastic computing, and cloud computing, AnalyticDB for MySQL V3.0 improves scalability, usability, reliability, and security to meet the requirements of data warehousing in different scenarios. AnalyticDB for MySQL V3.0 supports concurrent access on a larger scale, faster read and write capabilities, and smarter hybrid query and load management. It refines resource utilization and reduces costs, allowing you to focus more on business development and data value.
Compared with AnalyticDB for MySQL V2.0, AnalyticDB for MySQL V3.0 has the following benefits.
Ease of use
A database should be easy to use to realize its value. AnalyticDB for MySQL V3.0 is fully compatible with MySQL protocols and supports all SQL statements and syntax. In most scenarios, you can migrate MySQL databases to AnalyticDB for MySQL V3.0 without modifying the code and reduce your migration costs. In addition, AnalyticDB for MySQL V3.0 is also compatible with common tools of MySQL.
Higher cost effectiveness
AnalyticDB for MySQL V3.0 supports flexible billing methods, including pay-as-you-go and subscription. It also allows you to extend disks separately. You can further reduce costs by extending or shrinking the disk space. When you create a cluster, you can purchase the disk space based on actual usage. If the purchased disk space becomes fully occupied, you can purchase additional disk space.
In addition, the price of AnalyticDB for MySQL V3.0 is greatly reduced. For example, the price of an AnalyticDB for MySQL V3.0 cluster consisting of C8 node groups is up to 21% lower than that of an AnalyticDB for MySQL V2.0 cluster consisting of C8 elastic compute units (ECUs).
AnalyticDB for MySQL V3.0 stores hot and cold data separately in What is OSS? in tiered storage mode, and permanently retains historical data. AnalyticDB for MySQL V3.0 uses cloud-native architecture to seamlessly integrate with Alibaba Cloud services that provide strong computing power, such as Apsara PolarDB and Data Lake Analytics.
Large-scale database clusters featuring high read and write speeds
AnalyticDB for MySQL V3.0 synchronizes replicas in compliance with the Raft consensus protocol and creates indexes in a lightweight manner. This achieves high throughput for read and write operations in real time. AnalyticDB for MySQL V3.0 also improves the distributed hybrid computing engine and the query optimizer to provide a stronger complex computing capability. An AnalyticDB for MySQL V3.0 cluster provides up to 1.5 times the write speed and up to 1.4 times the query speed (in the 100 GB TPC-H tests) of an AnalyticDB for MySQL V2.0 cluster that has the same specifications.
Higher availability and reliability
AnalyticDB for MySQL V3.0 allows you to deploy clusters within a zone or across zones. AnalyticDB for MySQL V3.0 features high availability (at least 99.95%) and can resume services within seconds upon failure. It can also automatically detect faults, remove faulty nodes, and rebuild replicas. AnalyticDB for MySQL V3.0 stores data in three replicas and backs up full and incremental data on a regular basis. It can provide you with the data reliability required in the finance industry.
AnalyticDB for MySQL V3.0 has an improved permission model, including whitelists and cluster-level RAM-based access control. The recycle bin retains data for up to 730 days. The execution of all SQL statements is recorded and audited.