Tagged articles
204 articles
Page 2 of 3
HomeTech
HomeTech
Dec 14, 2021 · Databases

TiDB Cross-Data-Center High Availability Using Binlog Bidirectional Replication

This article summarizes the design, working principle, deployment steps, testing results, and future outlook of a TiDB cross-data-center high‑availability solution based on Binlog bidirectional replication, aiming to ensure rapid failover and continuous service between two data‑center clusters.

Bidirectional ReplicationBinlogCross‑Data‑Center
0 likes · 5 min read
TiDB Cross-Data-Center High Availability Using Binlog Bidirectional Replication
Top Architect
Top Architect
Dec 11, 2021 · Databases

Scaling Zhihu’s Moneta Service with TiDB: Architecture, Performance, and Lessons Learned

Zhihu’s Moneta service, handling over a trillion rows and billions of daily writes, migrated from MySQL to TiDB, achieving millisecond query latency, high availability, and horizontal scalability, and the article details the architecture, performance metrics, migration challenges, and lessons learned from this large‑scale deployment.

Data MigrationTiDBdatabase scalability
0 likes · 13 min read
Scaling Zhihu’s Moneta Service with TiDB: Architecture, Performance, and Lessons Learned
Ctrip Technology
Ctrip Technology
Dec 9, 2021 · Databases

TiDB Operational Practices at Ctrip: Architecture, Use Cases, Performance Tuning, Monitoring, and Tooling

This article details Ctrip's migration from MySQL to TiDB, describing the multi‑data‑center architecture, real‑world use cases such as the international CDP platform and hotel settlement, performance tuning measures, comprehensive monitoring and alerting, auxiliary tools, and future roadmap for the distributed NewSQL database.

HTAPTiDBmonitoring
0 likes · 16 min read
TiDB Operational Practices at Ctrip: Architecture, Use Cases, Performance Tuning, Monitoring, and Tooling
High Availability Architecture
High Availability Architecture
Dec 7, 2021 · Databases

Efficiency Choice: NetEase Internal Evaluation of Distributed Database TiDB

NetEase’s DBA team presents a comprehensive analysis comparing TiDB‑based innovative architecture with the traditional MySQL + DDB stack, detailing business fit, cost reduction, technical innovation, scalability, high availability, HTAP capabilities, migration strategies, and practical deployment experiences to justify adopting TiDB as a next‑generation distributed database solution.

HTAPTiDBdistributed database
0 likes · 35 min read
Efficiency Choice: NetEase Internal Evaluation of Distributed Database TiDB
Java Interview Crash Guide
Java Interview Crash Guide
Dec 2, 2021 · Databases

How Zhihu Scaled to Trillions of Rows with TiDB – Real‑Time Query Performance Insights

Zhihu’s Moneta service stores over a trillion rows and faces massive write and read loads; this article explains why TiDB was chosen, how its architecture and features such as HTAP, Raft, Titan and table partitioning enable millisecond‑level query latency, high availability, and seamless scaling.

HTAPPerformance OptimizationScalability
0 likes · 15 min read
How Zhihu Scaled to Trillions of Rows with TiDB – Real‑Time Query Performance Insights
DataFunTalk
DataFunTalk
Nov 13, 2021 · Cloud Native

Designing Cloud‑Native Distributed Database Architecture: Lessons from TiDB

This article explores how to design a cloud‑native distributed database architecture by examining TiDB’s current structure, proposing a storage‑compute separation that leverages cloud services like S3 and EBS, and discussing implications for cost, scalability, fault‑tolerance, and multi‑tenant deployment.

ScalabilityTiDBarchitecture
0 likes · 14 min read
Designing Cloud‑Native Distributed Database Architecture: Lessons from TiDB
DataFunSummit
DataFunSummit
Nov 13, 2021 · Cloud Native

Designing Cloud‑Native Distributed Database Architecture: Insights from TiDB

This article explores how to design a cloud‑native distributed database architecture using TiDB as a case study, discussing cost reduction, storage choices, compute‑storage separation, fault tolerance, scaling strategies, and the trade‑offs of caching and persistent storage in modern cloud environments.

ScalabilityTiDBarchitecture
0 likes · 15 min read
Designing Cloud‑Native Distributed Database Architecture: Insights from TiDB
Programmer DD
Programmer DD
Oct 17, 2021 · Databases

TiDB Architecture Explained: TiKV, PD, and Raft in Distributed Databases

TiDB is a distributed, MySQL-compatible database built from three core components—TiDB Server for stateless SQL processing, PD for global scheduling and metadata management, and TiKV for high‑performance key‑value storage—coordinated via the Raft consensus algorithm to ensure strong consistency and fault tolerance.

Database ArchitecturePDRaft
0 likes · 13 min read
TiDB Architecture Explained: TiKV, PD, and Raft in Distributed Databases
Xiaolei Talks DB
Xiaolei Talks DB
Sep 4, 2021 · Databases

Mastering TiDB Performance: Layered and Scenario‑Based Optimization Strategies

This article explores TiDB performance optimization by examining layered approaches—hardware, software, and SQL—and scenario‑specific tactics such as read/write hotspot handling, OLAP challenges, and distributed transaction tuning, offering practical insights and real‑world case studies from industry experts.

Database TuningHardwarePerformance Optimization
0 likes · 7 min read
Mastering TiDB Performance: Layered and Scenario‑Based Optimization Strategies
HomeTech
HomeTech
Sep 1, 2021 · Databases

Case Study: TiDB Deployment for the 2021 "818 Global Auto Festival"

This case study details how Car Home leveraged TiDB 5.1.1 with a three‑data‑center, five‑replica HTAP architecture to support the high‑traffic 818 Global Auto Festival, covering background, business requirements, database selection, system design, performance challenges, solutions, and post‑event insights.

HTAPPerformance TestingTiCDC
0 likes · 11 min read
Case Study: TiDB Deployment for the 2021 "818 Global Auto Festival"
Xiaolei Talks DB
Xiaolei Talks DB
Aug 30, 2021 · Backend Development

Unlocking TiCDC: Efficient Incremental Data Sync for TiDB in Real‑World Scenarios

This article explains how TiCDC, a change‑data‑capture tool for TiDB, addresses incremental extraction, cross‑region hot‑standby, and stream processing needs, outlines its architecture, discusses early‑version issues, and provides best‑practice recommendations for stable, high‑performance data synchronization.

Change Data CaptureKafkaTiCDC
0 likes · 13 min read
Unlocking TiCDC: Efficient Incremental Data Sync for TiDB in Real‑World Scenarios
Shopee Tech Team
Shopee Tech Team
Aug 26, 2021 · Databases

Database Architecture Evolution and Sharding Practice in Shopee's Logistics Service

Shopee’s Logistics Channel Service migrated from a shared‑cluster MySQL setup to dedicated clusters, added TiDB for transient tracking data, and ultimately adopted hash‑based sharding with separate order and tracking services plus an asynchronous compensation mechanism, enabling uniform data distribution, cross‑database consistency, six‑month archiving, and scalable growth without rebalancing.

Database ArchitectureDistributed SystemsTiDB
0 likes · 18 min read
Database Architecture Evolution and Sharding Practice in Shopee's Logistics Service
Trip Tech Team
Trip Tech Team
Aug 12, 2021 · Databases

Unlocking HTAP: Inside TiDB, TiKV, RocksDB, and LevelDB Architecture

This article introduces TiDB’s hybrid transactional‑analytical processing capabilities, explains TiKV’s region‑based storage built on RocksDB, and provides a detailed overview of RocksDB and LevelDB architectures, including their data structures, write‑read flows, and key optimizations for modern distributed database systems.

HTAPKV storageLevelDB
0 likes · 16 min read
Unlocking HTAP: Inside TiDB, TiKV, RocksDB, and LevelDB Architecture
Xiaolei Talks DB
Xiaolei Talks DB
Jul 21, 2021 · Databases

Optimistic vs Pessimistic Transactions in TiDB: 10x Performance Boost

This article compares TiDB's optimistic and pessimistic transaction models through a real‑world high‑concurrency write‑conflict scenario, showing how pessimistic locking can achieve over ten times higher throughput than optimistic retries.

Database ConcurrencyOptimistic TransactionPessimistic Transaction
0 likes · 14 min read
Optimistic vs Pessimistic Transactions in TiDB: 10x Performance Boost
ITPUB
ITPUB
Jun 21, 2021 · Databases

Mastering TiDB: Essential Naming, Design, and SQL Best Practices

This comprehensive guide provides TiDB developers and administrators with standardized naming conventions, object‑design principles, data‑model considerations, SQL development rules, transaction limits, implicit type‑conversion pitfalls, result‑set stability tips, index strategies, auto‑increment handling, timeout settings, JDBC configuration, hotspot mitigation, pagination techniques, and unique ID generation methods.

SQL Best PracticesTiDBTransaction Limits
0 likes · 53 min read
Mastering TiDB: Essential Naming, Design, and SQL Best Practices
DataFunTalk
DataFunTalk
Jun 20, 2021 · Databases

Xiaohongshu’s OLAP Architecture Evolution and DorisDB Adoption

This article details Xiaohongshu’s multi‑stage evolution of its OLAP infrastructure—from Redshift to Presto, ClickHouse, and finally DorisDB—describing the data pipeline, tool comparisons, advertising use‑case implementation, and the resulting performance and operational benefits.

Big DataClickHouseDorisDB
0 likes · 12 min read
Xiaohongshu’s OLAP Architecture Evolution and DorisDB Adoption
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 7, 2021 · Databases

Generating SQL Fingerprints with TiDB SQL Parser

This article explains how to use the TiDB SQL parser to create custom SQL fingerprints by traversing the abstract syntax tree, replacing literal values with placeholders, and restoring the modified tree back to SQL, offering a more maintainable alternative to string‑based approaches.

GoSQL ParserSQL fingerprint
0 likes · 6 min read
Generating SQL Fingerprints with TiDB SQL Parser
360 Quality & Efficiency
360 Quality & Efficiency
Jun 4, 2021 · Fundamentals

Understanding the Snowflake Algorithm for Distributed Unique ID Generation

This article explains the background of migrating from MySQL to TiDB, introduces the Snowflake algorithm’s 64‑bit ID structure, discusses its advantages and disadvantages, provides a Python implementation, and highlights its impact on achieving globally unique, time‑ordered identifiers in distributed systems.

PythonTiDBdatabase migration
0 likes · 5 min read
Understanding the Snowflake Algorithm for Distributed Unique ID Generation
IT Architects Alliance
IT Architects Alliance
Jun 1, 2021 · Backend Development

Design and Implementation of Zhihu's High‑Throughput Read Service Using TiDB

This article presents a detailed case study of Zhihu's read‑service architecture, describing its high‑availability, high‑performance, and easy‑scalability design goals, key components such as Proxy, Cache and TiDB storage, performance metrics, and the migration from MySQL to TiDB with practical lessons learned.

Backend ArchitectureTiDBhigh availability
0 likes · 18 min read
Design and Implementation of Zhihu's High‑Throughput Read Service Using TiDB
ITFLY8 Architecture Home
ITFLY8 Architecture Home
May 31, 2021 · Backend Development

How Zhihu Scales Read Filtering: A Deep Dive into High‑Performance Backend Architecture

This article explains how Zhihu built a highly available, low‑latency read‑filtering service for its homepage, detailing the system’s design goals, architecture components such as proxy, cache and storage, massive data scale, migration from MySQL to TiDB, and performance results after adopting TiDB 3.0.

BackendScalabilityTiDB
0 likes · 21 min read
How Zhihu Scales Read Filtering: A Deep Dive into High‑Performance Backend Architecture
Big Data Technology & Architecture
Big Data Technology & Architecture
May 27, 2021 · Databases

Database Selection and TiDB Implementation in NetEase Interactive Entertainment Billing Group

This article details the billing group's challenges with single‑node MySQL, the evaluation of alternative databases such as TiDB and CockroachDB, performance testing, migration strategies, operational best practices, and the final decision to adopt TiDB for scalable, high‑availability data services.

Cloud NativeData ArchitectureDistributed SQL
0 likes · 15 min read
Database Selection and TiDB Implementation in NetEase Interactive Entertainment Billing Group
Architecture Digest
Architecture Digest
May 15, 2021 · Backend Development

Design and Migration of Zhihu's Read Service: High Availability, Performance, and TiDB Adoption

This article details Zhihu's read‑service architecture, covering its business requirements, high‑availability and high‑performance design goals, key components such as Proxy, Cache and Storage, extensive performance metrics, the migration from MySQL to TiDB, and the benefits brought by TiDB 3.0 features.

Backend ArchitectureScalabilityTiDB
0 likes · 18 min read
Design and Migration of Zhihu's Read Service: High Availability, Performance, and TiDB Adoption
DataFunTalk
DataFunTalk
Apr 23, 2021 · Big Data

Building and Evolving Zhihu’s Flink‑Based Data Integration Platform

This article details Zhihu’s transition from a Sqoop‑driven data integration system to a Flink‑centric platform, covering business scenarios, historical architecture, design goals, technology choices, performance optimizations, and future plans for unified streaming‑batch processing across diverse storage systems.

Batch ProcessingBig DataData Integration
0 likes · 14 min read
Building and Evolving Zhihu’s Flink‑Based Data Integration Platform
DataFunTalk
DataFunTalk
Apr 21, 2021 · Databases

TiDB Practices and Solutions for Core Banking and Financial Industry

This article presents a comprehensive technical overview of TiDB, an open‑source distributed NewSQL database, detailing its architecture, migration strategies, and real‑world deployments across core banking, payment, wealth‑management, risk‑control, and insurance scenarios, while highlighting its HTAP capabilities and upcoming TiDB 5.0 enhancements.

Financial ServicesHTAPTiDB
0 likes · 20 min read
TiDB Practices and Solutions for Core Banking and Financial Industry
360 Smart Cloud
360 Smart Cloud
Apr 1, 2021 · Databases

Using TiDB Data Migration (DM) for MySQL‑to‑TiDB Sync: Architecture, Features, Tuning and Troubleshooting

This article shares practical experience with TiDB Data Migration (DM), covering its background, architecture, key features, online DDL support, common error handling such as duplicate‑key issues, large‑scale import tuning, configuration limits, and cleanup recommendations for reliable MySQL‑to‑TiDB synchronization.

DMData MigrationDatabase Synchronization
0 likes · 16 min read
Using TiDB Data Migration (DM) for MySQL‑to‑TiDB Sync: Architecture, Features, Tuning and Troubleshooting
Top Architect
Top Architect
Feb 11, 2021 · Databases

Case Study: Scaling Zhihu’s Moneta Application with TiDB

This article details how Zhihu’s Moneta service, handling over a trillion rows of user‑read data, migrated from MySQL sharding and MHA to the open‑source NewSQL database TiDB, achieving millisecond‑level query latency, high write throughput, and improved scalability through a layered architecture and TiDB’s advanced features.

HTAPMonetaNewSQL
0 likes · 13 min read
Case Study: Scaling Zhihu’s Moneta Application with TiDB
DeWu Technology
DeWu Technology
Dec 18, 2020 · Databases

TiDB Architecture, Design, and Real‑World Application

TiDB is a distributed NewSQL database that combines MySQL compatibility with a stateless SQL layer, a PD metadata manager, and a transactional key‑value store, offering automatic scaling, multi‑data‑center Raft replication, global secondary indexes, Percolator‑style 2PC, HTAP via TiFlash, and a rich ecosystem of migration, backup, CDC, and monitoring tools, as demonstrated by its large‑scale deployment at DeWu.

Data MigrationDatabase ArchitectureHTAP
0 likes · 18 min read
TiDB Architecture, Design, and Real‑World Application
360 Tech Engineering
360 Tech Engineering
Dec 4, 2020 · Databases

Practical Experience and Tips with TiDB Data Migration (DM) Tool

This article shares a comprehensive overview of TiDB Data Migration (DM), covering its architecture, configuration, online DDL support, common pitfalls such as duplicate‑key errors, large‑scale import tuning, version limits, and cleanup recommendations to help DBAs efficiently migrate MySQL/MariaDB workloads to TiDB.

DMData MigrationOnline DDL
0 likes · 16 min read
Practical Experience and Tips with TiDB Data Migration (DM) Tool
JD Cloud Developers
JD Cloud Developers
Dec 4, 2020 · Databases

How TiDB Solves High‑Traffic Database Challenges: Architecture, Features, and Real‑World Cases

This article summarizes a JD Cloud‑TiDB live webcast, explaining why JD Cloud chose TiDB, detailing its distributed architecture (TiDB Server, TiKV storage, PD), highlighting features such as horizontal scaling, strong consistency, real‑time analytics, backup, migration, and showcasing multiple enterprise migration case studies that demonstrate TiDB’s ability to overcome traditional database bottlenecks.

Data MigrationReal-time analyticsScalability
0 likes · 13 min read
How TiDB Solves High‑Traffic Database Challenges: Architecture, Features, and Real‑World Cases
Programmer DD
Programmer DD
Nov 27, 2020 · Databases

Why TiDB Is Revolutionizing Distributed Databases: Architecture, Use Cases, and HTAP

TiDB, an open‑source distributed relational database, separates compute and storage, offers MySQL compatibility, supports both OLTP and OLAP workloads, and provides HTAP capabilities, with real‑world use cases ranging from MySQL sharding to full replacement, data warehousing, and serving as a modular component.

Data WarehousingHTAPMySQL compatibility
0 likes · 8 min read
Why TiDB Is Revolutionizing Distributed Databases: Architecture, Use Cases, and HTAP
Architect
Architect
Sep 24, 2020 · Databases

Overview of TiDB Architecture: TiKV, PD, TiDB Server, and TiSpark

This article provides a comprehensive overview of TiDB's architecture, detailing the roles of TiKV Server, Placement Driver (PD), TiDB Server, and the TiSpark component, and explains how Raft ensures data consistency across the distributed database system.

Placement DriverRaftTiDB
0 likes · 11 min read
Overview of TiDB Architecture: TiKV, PD, TiDB Server, and TiSpark
HomeTech
HomeTech
Sep 9, 2020 · Databases

Using TiDB for High-Concurrency Event Management

The article details how TiDB was deployed for the high-concurrency '818 Global Car Night' event, providing robust database solutions for real-time transactions and analytics.

Database ManagementEvent TechnologyTiDB
0 likes · 10 min read
Using TiDB for High-Concurrency Event Management
360 Tech Engineering
360 Tech Engineering
Aug 10, 2020 · Databases

TiDB Cluster Write‑Write Conflict Investigation and Resolution

This article analyzes a TiDB cluster performance incident where QPS dropped and duration spiked due to write‑write conflicts, detailing the monitoring data, root‑cause investigation of server‑busy and scheduler latch issues, and the attempted mitigation steps such as enabling txn‑local‑latches and adjusting insert statements.

Cluster TroubleshootingDatabase operationsPerformance Monitoring
0 likes · 10 min read
TiDB Cluster Write‑Write Conflict Investigation and Resolution
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Aug 5, 2020 · Databases

How a TiDB Write Conflict Crashed a Cluster and What Fixed It

This article analyzes a TiDB production cluster outage caused by write‑write conflicts, walks through the monitoring data and log investigation, explains the underlying transaction model differences, and shares the step‑by‑step troubleshooting process that led to the final resolution.

Cluster TroubleshootingSchedulerTiDB
0 likes · 11 min read
How a TiDB Write Conflict Crashed a Cluster and What Fixed It
MaGe Linux Operations
MaGe Linux Operations
Jun 26, 2020 · Databases

What Makes TiDB a Cloud‑Native HTAP Database? An In‑Depth Overview

TiDB is an open‑source, cloud‑native distributed relational database that combines OLTP and OLAP capabilities, offers horizontal elasticity, strong ACID transactions, MySQL compatibility, and is suited for high‑availability, large‑scale, real‑time analytics scenarios across various industries.

Cloud NativeHTAPMySQL compatibility
0 likes · 9 min read
What Makes TiDB a Cloud‑Native HTAP Database? An In‑Depth Overview
360 Tech Engineering
360 Tech Engineering
Jun 19, 2020 · Databases

TiDB Overview: Architecture, Deployment, Advantages, and Practical Tips

This article explains how TiDB, a MySQL‑compatible distributed NewSQL database, solves large‑table performance issues with horizontal scaling, describes its core components, deployment guidelines, key advantages, and practical tips such as avoiding auto‑increment IDs, handling hotspots, version quirks, backup strategies, and monitoring with Grafana.

MySQL compatibilityPerformance OptimizationTiDB
0 likes · 12 min read
TiDB Overview: Architecture, Deployment, Advantages, and Practical Tips
360 Quality & Efficiency
360 Quality & Efficiency
Jun 19, 2020 · Databases

TiDB Overview: Architecture, Deployment, Advantages, and Practical Tips

This article introduces TiDB, an open‑source distributed HTAP database compatible with MySQL, explains its architecture—including TiDB Server, PD, TiKV, and TiSpark—covers deployment requirements, highlights key advantages such as elastic scaling, fault‑tolerance, strong consistency, and provides practical tips and common pitfalls for production use.

DeploymentHTAPMySQL compatibility
0 likes · 13 min read
TiDB Overview: Architecture, Deployment, Advantages, and Practical Tips
HomeTech
HomeTech
Apr 29, 2020 · Databases

Optimizing Write Hotspots in TiDB: Architecture Overview, Problem Analysis, and Solution

This article details a real‑world case of write‑hotspot performance degradation in a TiDB 3.0.9 cluster, explains TiDB’s architecture, analyzes monitoring data and hot‑region tables, and presents a redesign using varchar primary keys and SHARD_ROW_ID_BITS to disperse writes and dramatically improve latency.

Database OptimizationTiDBWrite Hotspot
0 likes · 16 min read
Optimizing Write Hotspots in TiDB: Architecture Overview, Problem Analysis, and Solution
Java Backend Technology
Java Backend Technology
Mar 21, 2020 · Databases

How Zhihu Scaled to Trillions of Rows with TiDB: Lessons from Moneta

Zhihu’s Moneta service, handling over 1.3 trillion rows and billions of daily writes, migrated from MySQL sharding to TiDB, achieving millisecond query latency, high availability, and horizontal scalability, while sharing architectural choices, performance metrics, migration challenges, and future expectations for TiDB 3.0.

HTAPMySQL MigrationPerformance Optimization
0 likes · 16 min read
How Zhihu Scaled to Trillions of Rows with TiDB: Lessons from Moneta
360 Tech Engineering
360 Tech Engineering
Mar 12, 2020 · Databases

TiDB on 360 Cloud Platform: Deployment, Migration, and Performance Tuning

This article shares the experience of deploying TiDB on the 360 Cloud Platform, covering background challenges with massive tables, TiDB's online DDL and high‑performance features, cluster architecture, DM migration workflow, common operational issues, and detailed tuning parameters to improve latency, QPS, and resource utilization.

DMData MigrationSQL
0 likes · 22 min read
TiDB on 360 Cloud Platform: Deployment, Migration, and Performance Tuning
Big Data Technology & Architecture
Big Data Technology & Architecture
Feb 28, 2020 · Databases

TiDB Technical Deep Dive – Storage, Compute, and Scheduling Architecture

This article provides a comprehensive technical overview of TiDB, covering its HTAP design, TiKV storage engine with RocksDB and Raft replication, the mapping of relational tables to key‑value pairs, MVCC implementation, transaction handling, and the PD scheduler that balances replicas, leaders, and hot spots across a distributed cluster.

HTAPKV storageRaft
0 likes · 31 min read
TiDB Technical Deep Dive – Storage, Compute, and Scheduling Architecture
Programmer DD
Programmer DD
Dec 25, 2019 · Databases

Deploying a TiDB Cluster with Ansible: A Complete Step‑by‑Step Guide

This article walks through the entire process of installing and configuring a TiDB cluster using Ansible, covering component overview, environment preparation, detailed deployment commands, common pitfalls, and verification steps to help readers avoid common mistakes.

Cluster SetupDatabase DeploymentDistributed SQL
0 likes · 9 min read
Deploying a TiDB Cluster with Ansible: A Complete Step‑by‑Step Guide
Architecture Digest
Architecture Digest
Dec 19, 2019 · Databases

Design and Migration of Zhihu's Read Service: From Bloom Filter to TiDB

This article details Zhihu's read‑service architecture, its massive data scale and performance challenges, early Bloom‑filter and HBase solutions, the design goals of high availability, high performance and scalability, and the subsequent migration from MySQL to TiDB with cloud‑native practices.

TiDBcloud-nativedistributed database
0 likes · 25 min read
Design and Migration of Zhihu's Read Service: From Bloom Filter to TiDB
dbaplus Community
dbaplus Community
Dec 3, 2019 · Databases

How iQIYI Selects, Optimizes, and Manages Its Diverse Database Stack

This article explains iQIYI's multi‑dimensional approach to database selection, details the practical use and optimization of MySQL, TiDB, Redis, Couchbase, and the internally built HiKV, and offers concrete recommendations for choosing the right database in different scenarios.

CouchbaseHiKVTiDB
0 likes · 20 min read
How iQIYI Selects, Optimizes, and Manages Its Diverse Database Stack
HomeTech
HomeTech
Nov 27, 2019 · Databases

Migrating AutoHome Community from SQL Server to TiDB: Architecture, Testing, and Lessons Learned

This article details the AutoHome community's migration from a monolithic SQL Server database to the distributed TiDB platform, covering the performance bottlenecks that prompted the change, the evaluation of candidate databases, extensive OLTP/OLAP testing, the full‑ and incremental‑sync migration strategy, rollback mechanisms, and the resulting operational improvements.

ETLPerformance TestingSQL Server
0 likes · 15 min read
Migrating AutoHome Community from SQL Server to TiDB: Architecture, Testing, and Lessons Learned
dbaplus Community
dbaplus Community
Nov 13, 2019 · Databases

Scaling TiDB to 200TB at Zhuanzhuan: Key Performance and Management Lessons

Zhuanzhuan’s adoption of TiDB addressed sharding challenges and massive data storage needs, and the team shares six common issues encountered in large‑scale online deployments—including performance diagnosis, cluster management, log inconsistencies, slow‑SQL impact, optimizer limitations, and transaction conflicts—along with their standardized solutions for deployment, monitoring, alerting, and business rollout.

Cluster ManagementSQL OptimizationTiDB
0 likes · 12 min read
Scaling TiDB to 200TB at Zhuanzhuan: Key Performance and Management Lessons
21CTO
21CTO
Oct 26, 2019 · Databases

How We Migrated a Billion‑Transaction Payment Platform from MySQL to TiDB

This article details the challenges and solutions encountered when migrating Fengchao's high‑throughput payment platform—handling over a hundred‑billion rows and millions of QPS—from a sharded MySQL architecture to TiDB, covering performance bottlenecks, TiDB advantages, migration steps, tooling, pitfalls, and optimization recommendations.

TiDBdatabase migrationdistributed database
0 likes · 20 min read
How We Migrated a Billion‑Transaction Payment Platform from MySQL to TiDB
Beike Product & Technology
Beike Product & Technology
Aug 29, 2019 · Big Data

TiSpark Integration with TiDB/TiKV for Efficient Data Synchronization and OLAP in the Databus Project

This article introduces TiSpark—an extension of Spark that tightly integrates with TiDB/TiKV to enable high‑performance, scalable data synchronization and OLAP queries, details its architecture, key configuration, performance advantages over Spark SQL and Sqoop, and outlines its role in the Databus data‑integration platform.

Big DataData IntegrationPerformance Optimization
0 likes · 10 min read
TiSpark Integration with TiDB/TiKV for Efficient Data Synchronization and OLAP in the Databus Project
Alibaba Cloud Native
Alibaba Cloud Native
Aug 12, 2019 · Cloud Native

What’s New in Cloud Native: Kubernetes Security Fixes, Project Updates, and Must‑Read Resources

This week’s cloud‑native roundup covers Mesosphere’s rebranding to D2iQ, two critical Kubernetes CVEs with remediation steps, upcoming CNCF Kubernetes summits, the Knative 0.8 release, curated open‑source project recommendations, and a selection of in‑depth reading on multi‑cluster, serverless, and API‑gateway technologies.

CNCFFluxKnative
0 likes · 11 min read
What’s New in Cloud Native: Kubernetes Security Fixes, Project Updates, and Must‑Read Resources
Tencent Cloud Developer
Tencent Cloud Developer
Jul 18, 2019 · Big Data

Tencent iData Analysis Center: Why We Chose Spark as Our Computing Platform

Tencent’s iData analysis center selected Spark as its new computing platform because, unlike ElasticSearch, TiDB, and other MPP solutions, Spark offers iterative processing, shuffle support, robust SQL and DAG scheduling, and flexible SMP‑style data exchange, enabling efficient OLAP on billions of game‑user records.

Big DataData PlatformMPP
0 likes · 13 min read
Tencent iData Analysis Center: Why We Chose Spark as Our Computing Platform
dbaplus Community
dbaplus Community
Jun 1, 2019 · Databases

What Drives TiDB’s Architecture? The Philosophy Behind a NewSQL Database

The article explores TiDB’s evolution philosophy, detailing its core beliefs, early user stories, and the three‑step "Make it work, make it right, make it fast" approach, while covering technical choices such as cloud‑first design, hardware‑agnosticism, formal verification, massive testing, performance tuning, and cost‑effective scaling.

NewSQLTiDBarchitecture
0 likes · 32 min read
What Drives TiDB’s Architecture? The Philosophy Behind a NewSQL Database
NetEase Media Technology Team
NetEase Media Technology Team
May 16, 2019 · Backend Development

Design and Implementation of a Configurable, Extensible Content Processing System (Apollo)

Apollo is a configurable, extensible content‑processing platform that models each step as a node defined in a configuration file, supports multiple implementations for A/B testing, decouples producers and consumers via Kafka, ensures fault‑tolerant retries and replay, captures fine‑grained metrics through Canal‑to‑TiDB pipelines, and cuts new‑type development effort to roughly ten percent of the original cost while delivering high‑quality data to downstream teams.

Backend ArchitectureKafkaTiDB
0 likes · 9 min read
Design and Implementation of a Configurable, Extensible Content Processing System (Apollo)
DataFunTalk
DataFunTalk
Apr 22, 2019 · Databases

Deep Dive into TiDB SQL Optimizer and Execution Engine

This article provides a comprehensive technical overview of TiDB's architecture, its SQL optimizer—including logical and physical optimization phases, rule‑based transformations, join ordering, and statistics collection—and outlines future work to improve query planning stability and performance.

Database InternalsQuery PlanningSQL Optimizer
0 likes · 16 min read
Deep Dive into TiDB SQL Optimizer and Execution Engine
Beike Product & Technology
Beike Product & Technology
Feb 21, 2019 · Big Data

DATABUS Data Integration Platform: Architecture, Capabilities, and TiDB Ecosystem

The article presents an in‑depth overview of the DATABUS data integration platform, detailing its background, current challenges, core capabilities such as data syncing, metadata automation, real‑time subscriptions, and its reliance on TiDB, TiSpark, Hudi, and related big‑data technologies to enable near‑real‑time data warehousing.

Big DataData IntegrationHive
0 likes · 13 min read
DATABUS Data Integration Platform: Architecture, Capabilities, and TiDB Ecosystem
Zhuanzhuan Tech
Zhuanzhuan Tech
Jan 11, 2019 · Databases

Differences Between TiDB and MySQL: Transactions, Queries, Server‑Side Prepared Statements, and Batch Processing

This article examines TiDB, a world‑class open‑source distributed NewSQL database, comparing its transaction and query behavior with MySQL, discussing underlying Percolator model, server‑side prepared statements, batch processing techniques, and practical optimization strategies for developers.

Batch ProcessingTiDBdistributed database
0 likes · 10 min read
Differences Between TiDB and MySQL: Transactions, Queries, Server‑Side Prepared Statements, and Batch Processing
Meituan Technology Team
Meituan Technology Team
Nov 22, 2018 · Databases

Meituan's TiDB Adoption: Architecture, Deployment, and Operational Practices

Facing MySQL limits, Meituan selected TiDB for its MySQL compatibility, strong consistency, and online scaling, deploying it on ten clusters and 200 nodes, building automated deployment, monitoring, and data‑sync tools, resolving performance issues, and planning broader adoption and joint development of future TiDB features.

MeituanPerformance OptimizationTiDB
0 likes · 20 min read
Meituan's TiDB Adoption: Architecture, Deployment, and Operational Practices
High Availability Architecture
High Availability Architecture
Nov 15, 2018 · R&D Management

Interview with PingCAP CTO Huang Dongxu on Building and Managing an Open‑Source Distributed Database Team

In this interview, PingCAP co‑founder and CTO Huang Dongxu shares how his team recruits talent, cultivates engineers through open‑source contributions, uses OKR instead of KPI for performance, and leverages community events to grow the TiDB distributed database project, while also promoting the upcoming GIAC conference.

Community BuildingOKRTiDB
0 likes · 9 min read
Interview with PingCAP CTO Huang Dongxu on Building and Managing an Open‑Source Distributed Database Team
Tongcheng Travel Technology Center
Tongcheng Travel Technology Center
Sep 26, 2018 · Databases

Design and Implementation of the Thor System for Containerized Management of TiDB

This article describes the challenges of scaling MySQL workloads, introduces TiDB’s distributed architecture, and details the Thor system’s container‑orchestrated design—including scheduling, cluster and database management, data synchronization with Hamal, and integrated monitoring and alerting—to achieve efficient, automated operation of large‑scale TiDB clusters.

TiDBcontainer orchestrationdistributed database
0 likes · 9 min read
Design and Implementation of the Thor System for Containerized Management of TiDB
dbaplus Community
dbaplus Community
Sep 23, 2018 · Operations

Key Takeaways from the 2018 Gdevops Global Agile Operations Summit in Beijing

The 2018 Gdevops Global Agile Operations Summit in Beijing gathered experts who shared practical insights on AIOps, DevOps, cloud‑native databases, MongoDB, TiDB on Kubernetes, SQL optimization, and operational best practices, providing a comprehensive snapshot of modern enterprise operations trends.

Cloud NativeDevOpsMongoDB
0 likes · 13 min read
Key Takeaways from the 2018 Gdevops Global Agile Operations Summit in Beijing
iQIYI Technical Product Team
iQIYI Technical Product Team
Sep 21, 2018 · Databases

Case Study of iQIYI’s Adoption of TiDB for Scalable High‑Availability Database Services

iQIYI migrated its critical Edge Control, Video Transcoding, and User Login services from MySQL to TiDB, gaining automatic sharding, high‑availability multi‑datacenter replication, and stable query performance that eliminated storage bottlenecks, complex sharding logic and frequent downtime, while enabling future OLTP/OLAP integration.

Data MigrationScalabilityTiDB
0 likes · 10 min read
Case Study of iQIYI’s Adoption of TiDB for Scalable High‑Availability Database Services
Youzan Coder
Youzan Coder
Aug 4, 2018 · Databases

Key Takeaways from the 2018 Youzan PaaS Tech Meetup: TiDB, Zankv & Search

The 2018 Youzan PaaS meetup in Hangzhou featured deep dives into TiDB's distributed SQL architecture and performance gains in version 2.1, introduced the open‑source Zankv KV store built on Raft, and shared practical Elasticsearch search‑engine optimizations used at Youzan.

ElasticsearchKV StoreTech Meetup
0 likes · 4 min read
Key Takeaways from the 2018 Youzan PaaS Tech Meetup: TiDB, Zankv & Search
Architecture Digest
Architecture Digest
Apr 21, 2018 · Databases

Case Study: Scaling Ticketing System with TiDB at Tongcheng

Facing rapid traffic growth and MySQL limitations, Tongcheng migrated its ticketing order database to a sharded MySQL cluster combined with TiDB, achieving transparent sharding, real‑time synchronization, high‑availability monitoring, and seamless handling of billions of rows and peak QPS over 10,000.

KubernetesMySQL compatibilityTiDB
0 likes · 8 min read
Case Study: Scaling Ticketing System with TiDB at Tongcheng
ITPUB
ITPUB
Jan 27, 2018 · R&D Management

Unlocking the Secrets of Successful Open‑Source Projects: Lessons from PingCAP

This guide explores why open‑source matters, shares PingCAP’s practical experience running TiDB, TiKV, and PD, and provides step‑by‑step advice on choosing licenses, managing repositories, fostering community contributions, and effectively participating in open‑source projects.

GitHubProject ManagementTiDB
0 likes · 14 min read
Unlocking the Secrets of Successful Open‑Source Projects: Lessons from PingCAP
High Availability Architecture
High Availability Architecture
Dec 19, 2017 · Databases

Interview with Liu Qi, Co‑founder and CEO of PingCAP, on TiDB’s Origin, Roadmap, and Database Trends

PingCAP co‑founder and CEO Liu Qi discusses the motivation behind creating TiDB, its evolution into a HTAP NewSQL database, key development priorities such as SQL enhancements, storage engine innovation, cloud‑native integration, and shares insights on open‑source project management and future database trends.

Cloud NativeHTAPNewSQL
0 likes · 9 min read
Interview with Liu Qi, Co‑founder and CEO of PingCAP, on TiDB’s Origin, Roadmap, and Database Trends
Qunar Tech Salon
Qunar Tech Salon
Dec 14, 2017 · Databases

TiDB Architecture, Deployment, and Monitoring Practices at Qunar

This article explains Qunar's transition from MySQL, Redis, and HBase to TiDB, detailing the background of distributed databases, TiDB's architecture, hardware selection, deployment automation, monitoring setup, and real‑world usage scenarios to address scalability and high‑availability challenges.

Big DataDatabase ArchitectureDeployment
0 likes · 14 min read
TiDB Architecture, Deployment, and Monitoring Practices at Qunar
UCloud Tech
UCloud Tech
Nov 14, 2017 · Databases

Unlocking Cloud TiDB: Kubernetes‑Powered Scaling for Distributed NewSQL

This article explains how Cloud TiDB, a cloud‑native NewSQL database launched by UCloud and PingCAP, leverages Kubernetes integration, operators, and custom volume management to provide elastic scaling, high availability, and efficient lifecycle management for distributed workloads.

Cloud-ComputingDistributed-DatabaseKubernetes
0 likes · 9 min read
Unlocking Cloud TiDB: Kubernetes‑Powered Scaling for Distributed NewSQL