BestHub
Sign in
Tagged articles
33 articles
Page 1 of 1
Tencent Cloud Developer
Tencent Cloud Developer
Nov 1, 2024 · Databases

How TDSQL Dominated Global OLAP & OLTP Benchmarks: Inside the Technical Secrets

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.

Columnar StorageDatabase PerformanceMPP
0 likes · 7 min read
How TDSQL Dominated Global OLAP & OLTP Benchmarks: Inside the Technical Secrets
Tencent Cloud Developer
Tencent Cloud Developer
Jul 17, 2024 · Databases

Design and Implementation of a Payment Fund Account System

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.

System DesignTDSQLaccounting
0 likes · 34 min read
Design and Implementation of a Payment Fund Account System
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 23, 2024 · Databases

Changing a Primary Key to a Composite Key in TDSQL for MySQL: Dealing with sql_require_primary_key

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.

TDSQLcomposite keymysql
0 likes · 7 min read
Changing a Primary Key to a Composite Key in TDSQL for MySQL: Dealing with sql_require_primary_key
Refining Core Development Skills
Refining Core Development Skills
Dec 11, 2023 · Databases

Understanding Tencent Cloud's TDSQL Distributed Relational Database Architecture and Features

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.

TDSQLhigh availabilityintelligent DBA
0 likes · 8 min read
Understanding Tencent Cloud's TDSQL Distributed Relational Database Architecture and Features
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 22, 2023 · Databases

SQLE 2.2309.0-pre4 Release Notes – New Features, Rule Knowledge Base, and Full Release Information

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 AuditingRelease NotesRule Knowledge Base
0 likes · 8 min read
SQLE 2.2309.0-pre4 Release Notes – New Features, Rule Knowledge Base, and Full Release Information
Tencent Cloud Developer
Tencent Cloud Developer
Sep 13, 2023 · Cloud Native

Designing and Implementing a Payment Fund Account System

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.

AvailabilityConsistencySecurity
0 likes · 35 min read
Designing and Implementing a Payment Fund Account System
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 9, 2023 · Databases

SQLE 2.2306.0-pre1 Release Notes

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 AuditingMycatRelease Notes
0 likes · 8 min read
SQLE 2.2306.0-pre1 Release Notes
Tencent Cloud Developer
Tencent Cloud Developer
Mar 1, 2023 · Big Data

We Analysis User Profiling System: Architecture and Technical Implementation

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
We Analysis User Profiling System: Architecture and Technical Implementation
ITPUB
ITPUB
Dec 28, 2022 · Databases

How TDSQL‑PG Achieves Real‑Time HTAP: Architecture, Storage, and Optimization Insights

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 storageResource Isolation
0 likes · 18 min read
How TDSQL‑PG Achieves Real‑Time HTAP: Architecture, Storage, and Optimization Insights
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Sep 26, 2022 · Databases

Mastering Horizontal Scaling with TDSQL: Design, Practices, and Performance

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.

Performance OptimizationTDSQLdistributed database
0 likes · 24 min read
Mastering Horizontal Scaling with TDSQL: Design, Practices, and Performance
Tencent Cloud Developer
Tencent Cloud Developer
May 13, 2021 · Databases

Practice of Distributed Database Architecture in WeBank's Core Systems

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 TrendsTDSQL
0 likes · 18 min read
Practice of Distributed Database Architecture in WeBank's Core Systems
Tencent Cloud Developer
Tencent Cloud Developer
May 12, 2021 · Databases

Evolution and Architecture of Distributed Databases: A TDSQL Case Study

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
Evolution and Architecture of Distributed Databases: A TDSQL Case Study
Tencent Cloud Developer
Tencent Cloud Developer
May 11, 2021 · Databases

Database Technology Development and Future Directions: From Commercial Databases to Cloud-Native Era

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.

OracleTDSQLcloud database
0 likes · 21 min read
Database Technology Development and Future Directions: From Commercial Databases to Cloud-Native Era
ITPUB
ITPUB
Apr 9, 2021 · Databases

Tencent TDSQL Reveals Infinite Database Anomalies and a Hands‑On Learning Tool

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.

Concurrency ControlLinux toolTDSQL
0 likes · 11 min read
Tencent TDSQL Reveals Infinite Database Anomalies and a Hands‑On Learning Tool
ITPUB
ITPUB
Dec 24, 2020 · Databases

How TDSQL Achieves Multi‑Level Strong Consistency with 4×‑3× Performance Gains

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 ResearchDistributed TransactionsTDSQL
0 likes · 12 min read
How TDSQL Achieves Multi‑Level Strong Consistency with 4×‑3× Performance Gains
Tencent Cloud Developer
Tencent Cloud Developer
May 7, 2020 · Databases

TDSQL Horizontal Scaling: Design Principles and Practice for Non‑Disruptive Linear Expansion

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.

TDSQLcloud video conferencedistributed database
0 likes · 17 min read
TDSQL Horizontal Scaling: Design Principles and Practice for Non‑Disruptive Linear Expansion
Tencent Cloud Developer
Tencent Cloud Developer
Sep 4, 2019 · Databases

Lightweight and Efficient Temporal Database Management System in TDSQL (T‑TDSQL) – VLDB 2019 Industry Track Paper

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 ProcessingPerformance EvaluationTDSQL
0 likes · 12 min read
Lightweight and Efficient Temporal Database Management System in TDSQL (T‑TDSQL) – VLDB 2019 Industry Track Paper
Tencent Cloud Developer
Tencent Cloud Developer
Aug 16, 2019 · Databases

WeBank’s Deployment of Tencent TDSQL: Distributed Database Architecture, High Availability, and Scaling

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.

DCNTDSQLWeBank
0 likes · 15 min read
WeBank’s Deployment of Tencent TDSQL: Distributed Database Architecture, High Availability, and Scaling
dbaplus Community
dbaplus Community
Jul 4, 2019 · Databases

How Tencent’s TDSQL Multi‑Source Sync Achieves High‑Performance, Consistent Data Distribution

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
How Tencent’s TDSQL Multi‑Source Sync Achieves High‑Performance, Consistent Data Distribution
Tencent Cloud Developer
Tencent Cloud Developer
Jun 27, 2019 · Databases

Evolution and Technical Analysis of Tencent Cloud Databases: TDSQL and CynosDB

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.

Cloud NativeCynosDBDistributed Systems
0 likes · 17 min read
Evolution and Technical Analysis of Tencent Cloud Databases: TDSQL and CynosDB
Tencent Cloud Developer
Tencent Cloud Developer
May 16, 2019 · Operations

TDSQL Intelligent Operation Platform – Bianque Architecture and Practice

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.

AutomationDatabase operationsIntelligent Diagnosis
0 likes · 17 min read
TDSQL Intelligent Operation Platform – Bianque Architecture and Practice
Tencent Cloud Developer
Tencent Cloud Developer
Oct 16, 2018 · Databases

MSQL+: A Plugin Toolkit for Similarity Search in Distributed Relational Database Systems (VLDB 2018 Demo)

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
MSQL+: A Plugin Toolkit for Similarity Search in Distributed Relational Database Systems (VLDB 2018 Demo)
ITPUB
ITPUB
Jul 3, 2018 · Databases

How T‑TDSQL Implements Dual‑Temporal Data Management in Distributed Environments

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
How T‑TDSQL Implements Dual‑Temporal Data Management in Distributed Environments
ITPUB
ITPUB
Jun 5, 2018 · Databases

How T‑TDSQL Enables Full‑Temporal Data Management in Distributed 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.

MVCCTDSQLTemporal Database
0 likes · 15 min read
How T‑TDSQL Enables Full‑Temporal Data Management in Distributed Databases
Tencent Cloud Developer
Tencent Cloud Developer
Feb 14, 2017 · Databases

TDSQL Audit Capability: Architecture, Kafka Integration, and Consistency Hash Implementation

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.

KafkaMongoDBTDSQL
0 likes · 7 min read
TDSQL Audit Capability: Architecture, Kafka Integration, and Consistency Hash Implementation
Qunar Tech Salon
Qunar Tech Salon
Nov 5, 2015 · Databases

Design and Architecture of TDSQL: A Distributed MySQL‑Based SQL System

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.

ScalabilityTDSQLdistributed database
0 likes · 19 min read
Design and Architecture of TDSQL: A Distributed MySQL‑Based SQL System
Art of Distributed System Architecture Design
Art of Distributed System Architecture Design
Jul 5, 2015 · Databases

Design and Implementation of TDSQL: A Distributed High‑Consistency MySQL‑Based Storage System

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.

ReplicationTDSQLdistributed database
0 likes · 18 min read
Design and Implementation of TDSQL: A Distributed High‑Consistency MySQL‑Based Storage System