1 views collected around this technical thread.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.