How Can We Combine PostgreSQL and MySQL to Make the Whole Greater than the Sum of the Parts? (Part 1)

Image for post
Image for post

Digoal, a senior product expert in the Database Business Group of Alibaba Cloud Intelligence, introduced ways to combine ApsaraDB for PostgreSQL and ApsaraDB for MySQL.

MySQL is currently the most popular open-source database product, and PostgreSQL is the most advanced open-source database product. The combination of the two can make the whole greater than the sum of the parts and solve problems that could not have been solved by individual applications. This two-part article details how to combine both the PostgreSQL and MySQL versions of ApsaraDB RDS to enhance the application value. It also explains five business scenarios and joint applications.

1. What Is ApsaraDB for RDS?

Users of ApsaraDB for RDS usually do not care about underlying database operating principles, such as how the database product implements high availability, backup, and security audit. All of these are managed by ApsaraDB for RDS so that it becomes a product that covers the full database lifecycle.

Image for post
Image for post

2. Product Forms of ApsaraDB for RDS

Image for post
Image for post

3. Technical Architecture of ApsaraDB RDS for PostgreSQL

Image for post
Image for post

4. Features of ApsaraDB RDS for PostgreSQL

Product Features

Image for post
Image for post

Performance Insights

Image for post
Image for post

Parallel Computing for Supporting Hybrid Load Business

In 32-thread and 64-thread editions, we tested 39 scenarios, for which the speed increased by 20 times on average. These scenarios cover almost all complex query conditions. In other words, parallel computing is available for any query. In addition, the parallelism is completely automatic.

Also, you can manually set the parallelism for SQL statements. For example, you need to generate a report in the middle of the night, or your analysts must respond to the boss’s need during the daytime to generate a report for some factories. In this case, you can manually set the parallelism so the database can run as fast as expected.

Image for post
Image for post

Multi-Modal Application Enhancements

Image for post
Image for post

Continue reading Part 2 of this article series to learn more about the benefits of combining ApsaraDB for PostgreSQL and ApsaraDB for MySQL.

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