At pgconf Asia Chinese technology forum, listen to Tencent cloud experts' in-depth understanding of database technology

Current PGConf.Asia 2021 Asian technology conference , In addition to Tencent cloud database sub Forum （ focusing PGConf.Asia- Tencent cloud sub Forum ,Get A masterpiece of financial distributed database ） Outside , Tencent cloud database expert team will also be in the Chinese Technology Forum - Kernel special session and application practice special session bring 3 Field sharing .

Broadcast address ：

https://2021.postgresconf.cn/liveEntry

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

TDSQL-C product ：

Cloud native database TDSQL-C（Cloud NativeDatabase TDSQL-C） abbreviation TDSQL-C.TDSQL-C It is a new generation of high-performance and highly available Enterprise Cloud native cloud database developed by Tencent cloud . A fusion of traditional databases 、 Advantages of cloud computing and new hardware technology ,100% compatible MySQL and PostgreSQL, To achieve a million level QPS High throughput ,448TB Massive distributed intelligent storage , Secure data . The product has the following characteristics ：

Full compatibility ：100% Compatible with open source database engine MySQL and PostgreSQL. There is little need to change the code , You can complete the query of the existing database 、 Smooth migration of applications and tools .

Ultra high performance : Strong performance of commercial database , The highest performance is MySQL database 8 times 、PostgreSQL Database 4 times .

Mass storage : Single instance support 448TB Mass storage , Easily cope with the continuous growth of business data .

Fast recovery : Compute nodes implement stateless , Support local and cross device second level failover and recovery ; Support snapshot based second level backup and rollback .

Data is highly reliable ： Clusters support security groups and VPC Network isolation . Automatically maintain multiple copies of data and backups , Secure data , Reliability up to 99.9999999%.

Elastic expansion ： The computing node can quickly move up and down according to business needs , Second to complete the expansion , Support no server Serverless framework , Automatic volume expansion and shrinkage , To achieve the optimal cost of computing resources .

TDSQL-A product ：

Analytical database （Analytical Datbase TDSQL-A,TDSQL-A） It is a distributed analytical database system independently developed by Tencent , It provides you with efficient massive data storage and online analysis and processing capabilities . The product has the following characteristics ：

Self developed in-line storage ： Provide efficient row column hybrid query capability , Provide column storage capacity , High compression ratio , Save storage space .

High compatibility : Support SQL 2003 and PostgreSQL grammar , Highly compatible Oracle grammar , Support stored procedures and complete distributed transaction capabilities .

Enterprise data security : With the separation of powers 、 Data desensitization 、 Data encryption 、 Enterprise level security capabilities such as data audit .

Mass data storage :MPP No shared architecture , Elastic expansion node , Can support PB Level mass storage and large-scale cluster communication , Data interconnection of large-scale clusters 、 Association query, etc .

Efficient complex query : Millisecond processing of trillion wide table data , Correlation analysis second response , The performance is several times to hundreds of times higher than that of open source and traditional databases ; Have a strong OLAP Analytical ability .

Strong data governance capabilities : Efficient elastic online capacity expansion 、 Long tail data cold and hot separation 、 Multi level table partition and multi level table partition are supported .

With the above knowledge to pave the way , Let's look at the speeches of the three engineers ：

The speech theme of sun Xu, an expert engineer of Tencent cloud is << TDSQL-C PostgreSQL Master slave architecture optimization >>. Mr. Sun Xu has 10 Experience in database kernel development ; Familiar with database query processing , concurrency control , Log and storage systems ; be familiar with PostgreSQL（Greenplum,PGXC etc. ）、Teradata Such as the database kernel implementation mechanism . as everyone knows ,PostgreSQL The database realizes one master and multiple reads through data redundancy and log synchronization , The standby machine is allowed to run after the host is unavailable , Replace the host and continue to provide services , Ensure the availability of the system . however TDSQL-C It's calculation - Storage separation architecture , 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 , Sun Xu will share with you TDSQL-C PostgreSQL Design and optimization of master-slave architecture , Database enthusiasts who pay attention to the design and optimization of cloud native database master-slave architecture , Please be sure to lock in the theme of this speech .

The speech theme of Wu Xin, an expert engineer of Tencent cloud is << Enterprise level analytical database TDSQL-A Technology architecture evolution >>. Mr. Wu Xin is in the database 、 Data replication 、 He has rich experience in big data computing and other fields , He has published many related papers 、 patent . Before joining Tencent, I was in IBM The big data analysis team has worked for many years , Then add Hashdata Database startups . After joining Tencent , be responsible for TDSQL-A Analytical database optimizer 、 actuator 、 R & D level design of multiple core functions such as distributed transactions .TDSQL-A In terms of kernel design and overall architecture, we have designed a large-scale data scenario , It mainly solves the scalability problem of large-scale database cluster and the efficient analysis problem of large-scale data . This time, I will share the detailed development history of enterprise analytical distributed database 、 Technology architecture, innovative practices and our vision for the future PG Future prospects of technology ecology .

The speech theme of Huang Hui, senior engineer of Tencent cloud is << How to build ultra high availability PostgreSQL Disaster recovery construction practice across computer rooms >>. Mr. Huang Hui has been working in the field of database since graduation , Familiar with database high availability 、 Control structure 、 Data backup and recovery . 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 .

TIPS
stay 12 month 14 The main forum of the day , Mr. Liu Shaorong, head of Tencent cloud database technology expert group, will also bring you Tencent cloud PostgreSQL Lecture on ecological evolution and technology architecture , Please look forward to revealing .

Thank you very much