Looking Back: ApsaraDB RDS for MySQL Was On a Roll in 2019

Image for post
Image for post

Looking back, 2019 was one big year for Alibaba Cloud ApsaraDB RDS for MySQL. We released core features, upgraded its performance, and even launched innovative new products. So, with all of that said, let’s look at the year-end results of this stellar product.

The Industry’s First Commitment of 99.99% Availability SLA

The First Chinese Cloud Vendor to Supports MySQL 8.0

Image for post
Image for post

ApsaraDB RDS for MySQL 8.0 offers the Basic Edition (Single-node) that is applicable to development and testing environments, and the High-availability Edition (Dual-node) that is applicable to the general production environment of enterprises and offers dedicated instances to ensure higher security and SLA assurance. It also provides the Enterprise Edition (Three-node) that ensures 100% data security and is applicable to transaction and accounting systems with high requirements for data reliability and to sectors such as finance, securities, government, and healthcare. Currently, ApsaraDB RDS for MySQL 8.0 covers the most product formats and meets all of the database requirements of a modern enterprise.

The Fully Upgraded Enterprise Edition (Three-Node)

ApsaraDB RDS for MySQL 5.7 Enterprise Edition (Three-node) and ApsaraDB RDS for MySQL 8.0 Enterprise Edition (Three-node) provide general-purpose instances to further reduce enterprise expenditures. An entry-level instance with a single-core CPU and 2 GB of memory costs only RMB 300 a month. After some technical optimizations, the original limits on local storage space have been significantly reduced for dedicated instances so that they can meet various needs of enterprises.

The Launch of New AliSQL Kernel

Image for post
Image for post
  • Dynamic Thread Pool (DTP): It dynamically manages the database thread pool in the kernel. It also uses limited resources to support a large number of requests for creating database connections, and maintains the ability to handle requests efficiently and stably.
  • Index Mutex Tuning (IMT): IMT-based optimization has significantly reduced the cost of splitting inodes and therefore greatly improved the ability to handle TPC-C-like scenarios. In full-memory testing, a single node can provide 390,000 transactions per minute, which is 35% to 50% higher than that of the native edition.
  • TDE and SM4: This feature provides optimized Transparent Data Encryption (TDE) and supports the SM4 encryption algorithm.
  • Performance Insight: It displays a wide range of information about the database SQL performance, which includes table statistics, index statistics, execution time of a single SQL statement, I/O statistics, and key performance data output.
  • AsyncFile Purge: It optimizes the deletion of large tables and therefore effectively reduces the impact of system I/O jitter.
  • Slow Log Rotate: It designs a switching mechanism for slow logs and therefore effectively reduces the instability caused by a large number of slow logs.
  • SQL Outline: It uses Hint to optimize the execution plans for SQL statements. As such, it ensures that the plans remain unchanged in the case of various environment changes such as major version upgrades and changes in statistics.
  • Statement Concurrency Control (SCC): Database administrators (DBA) uses SCC to intervene in the execution of system statements, throttle the traffic of specific SQL statements to control concurrency, and ensure that databases run stably during emergencies.
  • DDLRecycle Bin: A bin is added to the kernel to prevent the accidental execution of DROP TABLE or TRUNCATE TABLE, which may cause irreparable damage.

Support for ESSD Storage

Image for post
Image for post

The Major Upgrade in the Security System

Database Table Restoration

Cross-region Backup

Dedicated Proxy

Fully Upgraded CloudDBA and Performance Insight

Image for post
Image for post

X-Engine, a Database Engine with a High Compression Ratio

If your applications use a MySQL database with a large number of write operations and if you want to significantly reduce storage costs and have a certain demand for query due to logs, message archiving, or order data storage, X-Engine is your best choice.

Currently, the entire historical database for Alibaba’s internal DingTalk message platform runs on X-Engine, which has reduced our overall costs by 60% compared with InnoDB.

Dedicated Host Groups

  • User-controlled management: You can log on to the underlying operating system (OS) of your database, run OS commands to manage your database, deploy in-house management systems, and enjoy more permissions to support efficient management of your cloud database.
  • Flexible adjustment of instances: You can freely adjust the resource quota for a single instance, such as the CPU resources, input/output operations per second (IOPS), and maximum number of connections. As such, you can easily manage your database instances.
  • Cost-effective overcommitment: Through resource overcommitment, dedicated host groups support the hybrid deployment in offline databases and low-performance databases. As such, computing resources are fully utilized, and the overall costs are reduced by about 50%.
  • Dedicated physical environment: You own all database host resources, which are completely isolated from the external environment.
  • Hybrid deployment of various databases: Dedicated host groups support the hybrid deployment of various databases, such as ApsaraDB RDS for MySQL, ApsaraDB RDS for PostgreSQL, and ApsaraDB for Redis. This meets various needs of enterprises.

In 2019, ApsaraDB RDS for MySQL continued to develop rapidly. In addition to the preceding key features, hundreds of other improvements were made to build core database capabilities based on enterprises’ requirements. These improvements cover many aspects such as security, reliability, availability, scalability, and performance.

Conclusion

Original Source:

Follow me to keep abreast with the latest technology news, industry insights, and developer trends.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store