CDB for TDSQL

CDB for Tencent Distribute SQL (TDSQL) is applicable to OLTP scenarios and is compatible with MySQL 5.5 and MySQL 5.6 relational databases. It combines availability and reliability of high-end commercial databases, and delivers cost effective solutions for open source databases.

Data security: File-level encryption capability allows for flexible configuration of encrypted content, tables, or database files. The performance consumption is only 3-5%, which is much lower than the application-layer encryption overhead.

Follow-up tracking: Compliance audit can be conducted on database operations on a fine granularity basis, alerts are generated if risky behavior is detected. Audit logs are securely stored in accordance with national information security regulations.

Consistency and Availability

Forced synchronization is used in combination with high availability to ensure complete consistency between the master and slave databases under the premise of 99.99% availability.

Forced synchronous replication: The Multi-thread Asynchronous Replication (MAR) is adopted between active and standby databases. After the standby database is synchronized with the active one, the active standby gives application transaction responses in an effort to ensure that data is not lost or incorrect. MAR greatly improves synchronization performance and delay in inter-data center synchronization is lower than 30 ms.

High availability scheduling: High Availability Scheduling (HAS) implements switching and scheduling inside database node groups, between multiple database node groups and between multiple network lines. The scheduling cluster is determined and the cluster election mechanism is configured to ensure complete disaster recovery. When an exception occurs, the access gateway cluster completes route switching within 500 ms, achieving availability as high as 99.99%.

Three data centers in two regions and disaster backup: Database node groups can be deployed in different data centers and architecture of three data centers in two regions covering the remote disaster backup node is supported. CDB for TDSQL provides flexible disaster backup modes for users. In addition to inter-data center deployment, CDB for TDSQL uses the Hadoop distributed file system (HDFS) to implement database disaster backup, with more than 6 copies of duplicated data, thereby achieving data reliability of up to 99.99999%.

Exception recovery: When a node malfunctions, CDB for TDSQL automatically re-creates a node within 30 minutes, without affecting normal services.

High Performance

Hardware and architecture are comprehensively improved, making the performance 10 times better than your self-built databases.

PCI-e SSD: Enterprise-level solid state disks (SSD) are based on high-speed PCIExpress architecture and relevant controllers to provide hardware acceleration capabilities; Thread pool technology is also adopted to resolve restrictions on the maximum number of connections and system overhead caused by excessive threads.

Read/write splitting: Read/write splitting is supported, and the standby devices can be used to read data (not writable) for services, thereby greatly improving performance.