Tagged articles
TDSQL
34 articles · Page 1 of 1

ITPUBAug 21, 2026 · Industry Insights
The article chronicles the twelve‑year evolution of China’s Database Technology Conference (DTCC), showing how it transformed isolated DBA communities into a collaborative ecosystem, introduced new topics such as cloud and NoSQL, and enabled figures like 那海蓝蓝 to shape the nation’s database engineering landscape.
DTCCMySQLPostgreSQL
0 likes · 30 min read

Tencent Cloud's TDSQL shattered world records in both TPC‑DS (OLAP) and TPC‑C (OLTP) benchmarks, achieving a 7260 M QphDS score at a cost of 37.52 CNY/kQphDS, and the article explains the three self‑developed technologies—MPP execution, parallel execution framework, and columnar‑vectorized engine—that made this performance possible.
Database PerformanceMPPOLAP
0 likes · 7 min read

This article explains what NewSQL databases are, outlines their core characteristics, reviews major products such as Spanner, CockroachDB, TiDB, OceanBase and TDSQL, and discusses typical use cases ranging from financial services to HTAP workloads.
CockroachDBNewSQLOceanBase
0 likes · 8 min read

The article outlines the design and implementation of a secure, highly available payment fund account system, explaining core concepts of accounts and double‑entry bookkeeping, detailing architecture using TDSQL sharding, and describing security measures such as STRIDE analysis, HMAC‑SHA256, idempotency, distributed transactions, and comprehensive auditing to ensure fund integrity under high concurrency.
Financial SecurityTDSQLaccounting
0 likes · 34 min read

This article explains why TDSQL for MySQL refuses to drop a primary key when the sql_require_primary_key variable is ON, analyzes the underlying parameter behavior, and provides two practical solutions—temporarily disabling the variable or combining drop and add statements—to safely convert a single‑column primary key into a composite key.
MySQLPrimary KeyTDSQL
0 likes · 7 min read

This article explains the motivations behind distributed databases in high‑risk industries, introduces Tencent Cloud's TDSQL as a market leader, and details its architecture—including load balancing, SQL engine, compute and storage separation, raft‑based strong consistency, lossless upgrades, high‑availability failover, and an intelligent DBA platform.
High AvailabilityTDSQLintelligent DBA
0 likes · 8 min read

The SQLE 2.2309.0-pre4 release introduces an enterprise‑level SQL lifecycle management panel, a rule knowledge base, new TDSQL audit rules, and intelligent metadata scanning tasks, while providing links to the repository, documentation, and demo environments for both community and enterprise editions.
Database AuditingMySQLRule Knowledge Base
0 likes · 8 min read

The article details how to design and implement a cloud‑native payment fund account system on Tencent Cloud, covering account definitions, fund flow and multiple account types, TDSQL storage, separated fund and account services, robust security, distributed transactions, auditing, reconciliation, and high‑availability measures for high‑concurrency merchant payments.
ConsistencyDistributed DatabaseSecurity
0 likes · 35 min read

The SQLE 2.2306.0-pre1 release introduces support for TDSQL InnoDB and Mycat data sources in enterprise edition, adds new features, UI optimizations, bug fixes, and provides detailed usage instructions and links to documentation, source code, and demo environments.
Database AuditingMycatSQL
0 likes · 8 min read

We Analysis, the official data‑analysis platform for WeChat mini‑program providers, delivers a zero‑learning‑curve user‑profiling system that combines basic tag analysis and flexible, rule‑based segmentation, using an ETL pipeline to store pre‑computed data in TDSQL and online bitmap‑optimized queries in ClickHouse with RoaringBitmap, ensuring low‑latency, stable, and comprehensive analytics.
ClickHouseDataPipelineSpark
0 likes · 20 min read


ITPUBDec 28, 2022 · Databases
This article presents a comprehensive overview of TDSQL‑PG's HTAP capabilities, detailing the evolution of its storage, compute, transaction management, hybrid row‑column storage, cost‑based optimizer, vectorized execution, and resource isolation strategies for handling mixed OLTP and OLAP workloads.
HTAPHybrid storageTDSQL
0 likes · 18 min read

This article explains the background, challenges, and design principles of horizontal scaling for TDSQL, detailing its architecture, scaling process, shard‑key selection, high availability, distributed transactions, performance optimization, practical case studies, and a Q&A section.
High AvailabilityHorizontal ScalingSharding
0 likes · 24 min read

This article explains the motivations, challenges, and design principles of horizontal scaling for databases, using TDSQL as a case study to illustrate architecture, scaling procedures, shard key selection, high‑availability mechanisms, distributed transactions, and performance optimization techniques.
Distributed DatabaseHorizontal ScalingTDSQL
0 likes · 24 min read

At the 2021 ACM SIGMOD conference in Xi'an, Tencent Cloud Database TDSQL team had two papers accepted, introducing the innovative Spitfire three-tier buffer manager and adaptive multilevel serializability models, marking significant breakthroughs in database technology.
ACM SIGMODAI IntegrationNVM
0 likes · 5 min read

WeBank replaced traditional IOE systems with a Tencent‑based distributed platform using TDSQL and a unitized DCN architecture, where each Data Center Node serves a fixed user base, enabling linear horizontal scaling, fault isolation, rapid provisioning, and simplified single‑instance databases while handling billions of daily transactions.
DCN architectureDatabase TrendsDistributed Database
0 likes · 18 min read

The talk traces the evolution of distributed databases—from early shared‑memory and shared‑nothing designs through New‑SQL breakthroughs—to Tencent’s HTAP‑oriented TDSQL, highlighting its strong‑consistency architecture, anomaly taxonomy, and performance advantages over systems like Google Spanner while addressing modern scalability and hardware challenges.
ConsistencyDatabase ArchitectureHTAP
0 likes · 22 min read

The article traces database technology from the commercial Oracle era through open‑source and the emerging cloud‑native phase, highlights cloud as the primary battleground and the importance of the to‑B market, reviews historic academic contributions, examines Oracle and China’s TDSQL evolution, and outlines five future directions—distributed, intelligent, multi‑model, hardware‑software integration, and cloud convergence—while urging DBAs to adapt their full‑stack skills.
Cloud DatabaseDistributed DatabaseOracle
0 likes · 21 min read


ITPUBApr 30, 2021 · Databases
Tencent's TDSQL team introduces a groundbreaking theory that precisely classifies an infinite number of transaction‑related data anomalies, explains the underlying conflict‑ring model, and provides a Linux‑based open‑source tool with step‑by‑step instructions for practical anomaly detection.
C++17LinuxTDSQL
0 likes · 11 min read

Tencent Cloud's TDSQL team systematically proves that data anomalies are infinite, defines them formally, classifies them into three core types and detailed sub‑types, and releases an open‑source mini‑program for precise detection, advancing concurrency control theory and practice.
TDSQLTransaction Consistencydata anomalies
0 likes · 6 min read


ITPUBApr 9, 2021 · Databases
Tencent’s TDSQL team introduces a groundbreaking theory that precisely classifies an infinite set of database transaction anomalies, defines their categories via conflict‑graph analysis, and provides an open‑source Linux tool with step‑by‑step compilation instructions for interactive anomaly exploration.
Linux toolTDSQLconcurrency control
0 likes · 11 min read


ITPUBDec 24, 2020 · Databases
This article explains how Tencent's TDSQL database tackles the combined challenges of transaction and distributed consistency by introducing a multi‑level strong consistency model that delivers several‑fold performance improvements over Spanner, CockroachDB, and native Greenplum while preserving ACID guarantees.
Database ResearchTDSQLdistributed transactions
0 likes · 12 min read

TDSQL enables Tencent Meeting’s non‑disruptive, linear horizontal scaling by using a stateless SQL engine, shard‑key selection, two‑phase distributed transactions, and one‑click set expansion, delivering near‑linear performance growth, high availability, and seamless capacity increase for millions of daily users worldwide.
Distributed DatabaseHigh AvailabilityHorizontal Scaling
0 likes · 17 min read

The VLDB 2019 Industry Track paper presents T‑TDSQL, a lightweight full‑temporal extension of Tencent’s distributed OLTP database TDSQL that separates current and historical data, uses a hybrid storage model, rewrites temporal predicates, and achieves under 10% performance overhead while halving business execution time in production.
Hybrid Transactional Analytical ProcessingTDSQLTemporal Database
0 likes · 12 min read

WeBank adopted Tencent TDSQL, a MySQL‑based distributed database with strong‑consistency replication, auto‑sharding, read/write separation, automatic failover, and a management platform; deployed across two IDC regions using a 3+2 replica model, supporting petabyte data, billions of daily transactions, and high availability.
DCNDistributed DatabaseTDSQL
0 likes · 15 min read

This article explains the financial‑industry driven requirements for real‑time data sync, describes the TDSQL‑MULTISRCSYNC architecture—including producer, store, and consumer components—and details core designs such as row‑hash concurrency, idempotent binlog handling, and a lock‑based ordering mechanism that ensure high throughput and consistency.
Database ReplicationIdempotencyKafka
0 likes · 13 min read

Tencent Cloud’s database evolution progressed from early open‑source integration to self‑developed, cloud‑native solutions, producing the distributed, high‑availability TDSQL and the compute‑storage‑separated, log‑sinking CynosDB, each featuring advanced scheduling, sharding, cost‑based optimization, and asynchronous log replay to deliver scalable, low‑latency performance for diverse workloads.
CynosDBTDSQLcloud-native
0 likes · 17 min read

Bianque, TDSQL’s intelligent operation platform, automatically collects and indexes database metrics, applies a knowledge‑base‑driven analysis engine to diagnose availability, performance and reliability issues, issue risk warnings and optimization recommendations, dramatically cutting DBA effort and support tickets across Tencent’s cloud services.
Fault AnalysisPerformance MonitoringTDSQL
0 likes · 17 min read

Amid accelerating enterprise cloud adoption, Tencent Cloud has leveraged high‑performance, cost‑effective products such as CynosDB, TDSQL, CTSDB, and MongoDB, combined with open‑source collaborations, to capture a dominant share of the Chinese cloud database market in 2018‑2019.
CynosDBTDSQLTencent Cloud
0 likes · 13 min read

MSQL+ is a plugin toolkit that embeds similarity‑search capabilities directly into distributed relational databases such as Tencent’s TDSQL, using B‑tree indexes on generated signatures, customizable DIST functions, and various pivot‑selection strategies to enable scalable, SQL‑standard, approximate queries across sharded data.
MSQL+RDBMSTDSQL
0 likes · 12 min read


ITPUBJul 3, 2018 · Databases
This article details the architecture and implementation techniques of T‑TDSQL’s dual‑temporal database system, covering full‑state data reading, history‑table creation, snapshot query syntax, transaction snapshot attributes, visibility algorithms, transaction‑state management, index design, and valid‑time creation, query, update, and delete operations.
MVCCSQLTDSQL
0 likes · 17 min read


ITPUBJun 5, 2018 · Databases
T‑TDSQL, a temporal extension of Tencent's TDSQL, introduces a full‑temporal data model, scalable distributed architecture, MVCC‑based history visibility algorithms, and rich temporal features that address financial audit, data lineage, and high‑performance analytics for massive historical datasets.
Distributed DatabaseMVCCTDSQL
0 likes · 15 min read

TDSQL’s cloud‑based audit solution combines a three‑proxy high‑availability layer, Kafka’s O(1) persistent messaging, and a distributed audit‑server that uses consistent hashing and multi‑coroutine processing to consume data within seconds, while fault‑tolerant offsets, majority acknowledgments, and Tencent Cloud MongoDB storage ensure secure, ordered, scalable, and highly reliable audit logging.
Consistent HashingKafkaMongoDB
0 likes · 7 min read

The article describes how the limitations of an in‑memory NoSQL HOLD platform led to the creation of TDSQL, a distributed MySQL‑based SQL system featuring ZooKeeper‑coordinated Scheduler, Agent, and Gateway modules, automatic cross‑IDC disaster recovery, transparent horizontal scaling, strong synchronous replication, and future integration with container technologies.
Distributed DatabaseHigh AvailabilityMySQL
0 likes · 19 min read

The article describes the evolution, architecture, automatic scaling, sharding, disaster‑recovery mechanisms, and strong synchronous replication strategy of TDSQL, a MySQL‑engine based distributed database built to meet the high‑availability and high‑consistency requirements of Tencent's billing platform.
Distributed DatabaseMySQLReplication
0 likes · 18 min read
