Listening to Tencent cloud experts' in-depth understanding of database technology at pgconf. Asia

In addition to the Tencent cloud database sub Forum (Focus on PGConf.Asia - Tencent Cloud sub forum, acquire a masterpiece of distributed database，https://www.postgresqlchina.com/newsDetails/102), the experts team of Tencent Cloud Database will also bring three sharing sessions in the Chinese Technology Forum - kernel direction and application practice direction at this pgconf.asia 2021 Asian technology conference.

The schedule of the speech is as follows

Live address：

https://2021.postgresconf.cn/liveEntry

Let's first introduce Tencent cloud database products mentioned in the above speech.

·      TDSQL-C product：

Cloud native database TDSQL-C is called TDSQL-C for short. TDSQL-C is a new generation of high-performance and highly available Enterprise Cloud native cloud database developed by Tencent Cloud. It combines the advantages of traditional database, cloud computing and new hardware technology, is 100% compatible with MySQL and PostgreSQL, realizes the high throughput of super million QPS, and 448TB massive distributed intelligent storage, so as to ensure the safety and reliability of data. The product has the following characteristics:

ü  Full compatibility: 100% compatible with open source database engines MySQL and PostgreSQL. Almost no need to change the code to complete the query, application and tool smooth migration of the existing database.

ü  Ultra high performance: it has the strong performance of commercial database. The maximum performance is 8 times that of MySQL database and 4 times that of PostgreSQL database.

ü  Mass storage: single instance supports 448TB mass storage, which can easily cope with the continuous growth of business data.

ü  Fast recovery: the computing node is stateless and supports second level failover and recovery locally and across devices; Support snapshot based second level backup and rollback.

ü  Highly reliable data: the cluster supports security group and VPC network isolation. Automatically maintain multiple copies of data and backup to ensure data security and reliability, with a reliability of 99.999999%.

ü  Elastic expansion: the computing node can be configured quickly according to the business needs, and the capacity can be expanded at the second level. It supports the serverless architecture without server, and automatically expands and shrinks the capacity to optimize the cost of computing resources.

·      TDSQL-C product：

Cloud native database TDSQL-C is called TDSQL-C for short. TDSQL-C is a new generation of high-performance and highly available Enterprise Cloud native cloud database developed by Tencent Cloud. It combines the advantages of traditional database, cloud computing and new hardware technology, is 100% compatible with MySQL and PostgreSQL, realizes the high throughput of super million QPS, and 448TB massive distributed intelligent storage, so as to ensure the safety and reliability of data. The product has the following characteristics:

ü  Full compatibility: 100% compatible with open source database engines MySQL and PostgreSQL. Almost no need to change the code to complete the query, application and tool smooth migration of the existing database.

ü  Ultra high performance: it has the strong performance of commercial database. The maximum performance is 8 times that of MySQL database and 4 times that of PostgreSQL database.

ü  Mass storage: single instance supports 448TB mass storage, which can easily cope with the continuous growth of business data.

ü  Fast recovery: the computing node is stateless and supports second level failover and recovery locally and across devices; Support snapshot based second level backup and rollback.

ü  Highly reliable data: the cluster supports security group and VPC network isolation. Automatically maintain multiple copies of data and backup to ensure data security and reliability, with a reliability of 99.999999%.

ü  Elastic expansion: the computing node can be configured quickly according to the business needs, and the capacity can be expanded at the second level. It supports the serverless architecture without server, and automatically expands and shrinks the capacity to optimize the cost of computing resources.

The speech theme of Xu Sun, an expert engineer of Tencent cloud, is < < TDSQL-C PostgreSQL master-slave architecture optimization > >. As we all know, PostgreSQL database realizes one master and multiple reads through data redundancy and log synchronization, and allows the standby machine to replace the host and continue to provide external services after the host is unavailable, so as to ensure the availability of the system. However,TDSQL-C is a computing storage separation architecture, and database instances share the same data. Therefore, the design of one master and multiple reads is also very different from the traditional database. In this topic, Xu Sun will share with you the design and optimization of tdsql-c PostgreSQL master-slave architecture. Database enthusiasts who pay attention to the design and optimization of cloud native database master-slave architecture must lock in the theme of this speech.

The speech theme of Xin Wu, an expert engineer of Tencent cloud, is < < evolution of TDSQL-A technical architecture of enterprise analytical database > >. TDSQL-A is specially designed for large-scale data scenarios in terms of kernel design and overall architecture, which mainly solves the problems of scalability of large-scale database clusters and efficient analysis of large-scale data. This time, we will share Mr. Wu Xin's detailed development history of enterprise level analytical distributed database, technical architecture innovation practice and our future vision of PG technology ecology in the future.

Hui Huang, a senior engineer of Tencent Cloud, gave a speech on < < how to build a cross computer room disaster recovery practice of ultra-high availability PostgreSQL > >. The reliability of data and the availability of database services are eternal topics in the field of database disaster recovery. Mr. Huang Hui's sharing mainly focuses on how to balance the two and some trade-offs in high availability design.