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

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.

2. Product Forms of ApsaraDB for RDS

3. Technical Architecture of ApsaraDB RDS for PostgreSQL

4. Features of ApsaraDB RDS for PostgreSQL

Product Features

Performance Insights

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.

Multi-Modal Application Enhancements

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.