BestHub
Sign in
Tagged articles
204 articles
Page 1 of 3
Java Companion
Java Companion
Apr 26, 2026 · Databases

Is Sharding Ready to Retire? Why the Classic Split‑Database Approach Is Becoming Legacy

The article reviews the rise and decline of traditional database sharding, explains its technical pitfalls such as wrong shard keys, cross‑database joins, and distributed transactions, compares it with emerging NewSQL solutions like TiDB, OceanBase and PolarDB‑X, and offers practical criteria for choosing the right architecture.

NewSQLOceanBasePolarDB-X
0 likes · 14 min read
Is Sharding Ready to Retire? Why the Classic Split‑Database Approach Is Becoming Legacy
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Dec 15, 2025 · Databases

How TiDB Achieves Multi‑Datacenter High Availability with Multi‑Raft and TiCDC

This article explains TiDB's distributed, financial‑grade high‑availability architecture, covering single‑cluster same‑zone multi‑datacenter deployment, cross‑cluster DTS synchronization, underlying Raft and label mechanisms, configuration examples, performance trade‑offs, and real‑world monitoring results on the HULK cloud platform.

TiCDCTiDBdistributed database
0 likes · 16 min read
How TiDB Achieves Multi‑Datacenter High Availability with Multi‑Raft and TiCDC
Java Web Project
Java Web Project
Dec 7, 2025 · Databases

What Makes TiDB a NewSQL Powerhouse? A Deep Dive into Architecture, Features, and Use Cases

This article analyzes TiDB as a distributed NewSQL database, explaining the evolution from traditional SQL to NoSQL and NewSQL, detailing TiDB's core components, elastic scaling, ACID transactions, HTAP capabilities, high‑availability design, compatibility with MySQL, real‑world use cases, and its limitations compared to conventional databases.

HTAPMySQL compatibilityNewSQL
0 likes · 24 min read
What Makes TiDB a NewSQL Powerhouse? A Deep Dive into Architecture, Features, and Use Cases
DeWu Technology
DeWu Technology
Nov 10, 2025 · Databases

How TiDB v7 Upgrade Boosted Performance and Solved Real‑World Issues

This article details the TiDB upgrade journey from version 5.3.3 to 7.5.x, covering architecture, new v7 features, migration strategies, encountered problems with full‑table scans and inaccurate aggregation plans, the solutions applied, and the measurable performance and stability gains achieved after the upgrade.

Database UpgradeDistributed SQLNewSQL
0 likes · 15 min read
How TiDB v7 Upgrade Boosted Performance and Solved Real‑World Issues
Tech Freedom Circle
Tech Freedom Circle
Oct 23, 2025 · Databases

Why Consistent Hashing Fails: Why Redis, HBase, TiDB and Ceph Have Dropped It

The article examines the fundamental limitations of consistent hashing—its inability to preserve data locality, support range queries, and handle topology awareness—explaining why major storage systems such as Redis Cluster, TiDB, Ceph, and HBase have adopted alternative sharding strategies like hash slots, range partitioning, and CRUSH.

CRUSHCephHBase
0 likes · 45 min read
Why Consistent Hashing Fails: Why Redis, HBase, TiDB and Ceph Have Dropped It
Architect's Guide
Architect's Guide
Sep 29, 2025 · Databases

What Is NewSQL? Exploring TiDB’s Distributed Database Features

This article explains NewSQL concepts, compares traditional SQL, NoSQL and NewSQL, and provides an in‑depth overview of TiDB’s architecture, high‑availability design, HTAP capabilities, MySQL compatibility, configuration differences, and real‑world application scenarios.

HTAPMySQL compatibilityNewSQL
0 likes · 22 min read
What Is NewSQL? Exploring TiDB’s Distributed Database Features
Wukong Talks Architecture
Wukong Talks Architecture
Sep 24, 2025 · Databases

How Meiyou Scaled Overseas Messaging with TiDB Architecture

Meiyou, a leading women‑health platform, migrated its overseas messaging system and other core services from MySQL to TiDB, detailing the selection process, performance testing, deployment configurations, and the resulting gains in scalability, latency, high availability, and reduced operational costs.

TiDBdatabase migrationhigh availability
0 likes · 12 min read
How Meiyou Scaled Overseas Messaging with TiDB Architecture
Wukong Talks Architecture
Wukong Talks Architecture
Sep 22, 2025 · Databases

How AI‑Powered AIOps Transforms TiDB Database Operations

This article explores how integrating AI‑driven AIOps with the TiDB distributed database can automate monitoring, enable proactive anomaly detection, streamline root‑cause analysis, and optimize capacity planning, ultimately shifting database operations from manual firefighting to intelligent, data‑driven management.

Database operationsRoot Cause AnalysisTiDB
0 likes · 12 min read
How AI‑Powered AIOps Transforms TiDB Database Operations
macrozheng
macrozheng
Sep 19, 2025 · Databases

Master Database Sharding: Solving Read Diffusion with Range and Modulo Strategies

This article explains why large MySQL tables degrade performance, introduces vertical and horizontal sharding techniques—including range‑based and modulo‑based partitioning—covers the read‑diffusion problem caused by non‑sharding keys, and presents practical solutions such as auxiliary index tables, Elasticsearch integration, and TiDB as a distributed alternative.

ElasticsearchRange ShardingTiDB
0 likes · 15 min read
Master Database Sharding: Solving Read Diffusion with Range and Modulo Strategies
Sohu Tech Products
Sohu Tech Products
Jun 11, 2025 · Artificial Intelligence

How DeepSeek and TiDB AI Are Redefining Data Engines for the Large‑Model Era

This article explores DeepSeek's open‑source large‑model breakthroughs, PingCAP's AI‑enhanced database roadmap, TiDB.AI's retrieval‑augmented generation framework, the unified TiDB data engine, and practical Q&A insights on knowledge‑graph construction, vector search, and AI‑driven SQL generation.

AIDeepSeekKnowledge Graph
0 likes · 15 min read
How DeepSeek and TiDB AI Are Redefining Data Engines for the Large‑Model Era
Architect's Guide
Architect's Guide
May 8, 2025 · Databases

An Overview of TiDB: NewSQL Distributed Database Architecture, Features, and MySQL Compatibility

This article provides a comprehensive introduction to TiDB, a NewSQL distributed database, covering its origins, core components, high‑availability design, NewSQL characteristics, differences from traditional SQL and NoSQL, compatibility with MySQL, configuration nuances, and typical use cases such as HTAP and cloud‑native deployments.

Cloud NativeHTAPMySQL compatibility
0 likes · 20 min read
An Overview of TiDB: NewSQL Distributed Database Architecture, Features, and MySQL Compatibility
转转QA
转转QA
Apr 27, 2025 · Databases

Design and Implementation of a General Data Synchronization Solution for Online and Offline Databases

This article analyzes the pain points of inconsistent online‑offline configurations, proposes three synchronization schemes—including timed batch sync, automatic real‑time binlog‑MQ sync, and manual selective sync—compares their applicability, risks and performance, and presents practical deployment results across multiple projects using MySQL and TiDB.

BinlogTiDBdata synchronization
0 likes · 14 min read
Design and Implementation of a General Data Synchronization Solution for Online and Offline Databases
JD Cloud Developers
JD Cloud Developers
Apr 21, 2025 · Databases

How ClickHouse Local Join Cuts Query Time and Memory Usage in Supply‑Chain Planning

This article explains how moving aggregation logic from in‑memory processing to ClickHouse SQL, synchronizing configuration data, and leveraging ClickHouse ReplacingMergeTree tables with local joins dramatically reduces query latency and memory consumption for large‑scale supply‑chain planning workloads.

ClickHouseDatabase EngineeringLocal Join
0 likes · 13 min read
How ClickHouse Local Join Cuts Query Time and Memory Usage in Supply‑Chain Planning
Selected Java Interview Questions
Selected Java Interview Questions
Feb 23, 2025 · Databases

TiDB Overview: Distributed NewSQL Database, Architecture, Features, and MySQL Compatibility

This article provides a comprehensive introduction to TiDB, a distributed NewSQL database that combines OLTP and OLAP capabilities, explains NewSQL concepts, compares traditional SQL, NoSQL and NewSQL, details TiDB's architecture and core components, highlights its high‑availability and scalability features, and outlines compatibility differences and practical use cases.

HTAPMySQL compatibilityNewSQL
0 likes · 21 min read
TiDB Overview: Distributed NewSQL Database, Architecture, Features, and MySQL Compatibility
High Availability Architecture
High Availability Architecture
Jan 17, 2025 · Databases

Design and Implementation of a Multi‑Level Comment Storage System for Bilibili

This article presents a comprehensive design of Bilibili's comment service architecture, detailing the transition from TiDB to a multi‑level storage system based on Taishan KV, the data models, consistency mechanisms, retry and versioning strategies, and a hedging‑based degradation policy to ensure high availability under heavy traffic.

Comment SystemTaishan KVTiDB
0 likes · 13 min read
Design and Implementation of a Multi‑Level Comment Storage System for Bilibili
Xiaolei Talks DB
Xiaolei Talks DB
Dec 20, 2024 · Databases

Deploy a Production‑Ready TiDB 8.4 Cluster on Kubernetes with TiDB Operator

This guide walks you through the complete process of setting up a production‑grade TiDB 8.4.0 cluster on a self‑managed Kubernetes environment using the latest TiDB Operator, covering environment prerequisites, PV pool initialization, operator installation, CRD creation, and full cluster deployment with detailed commands and configurations.

Database DeploymentKubernetesOperator
0 likes · 15 min read
Deploy a Production‑Ready TiDB 8.4 Cluster on Kubernetes with TiDB Operator
Bilibili Tech
Bilibili Tech
Dec 13, 2024 · Databases

Design and Implementation of a Multi-Level Storage Architecture for Bilibili Comment Service

The paper proposes a multi‑level storage architecture for Bilibili’s comment service that replaces TiDB with a custom KV store (Taishan) and Redis caching, introduces unstructured indexes, CAS‑based consistency, real‑time and offline reconciliation, and a hedged degradation strategy to boost reliability, read throughput, and scalability during traffic spikes.

Comment SystemData ConsistencyNoSQL
0 likes · 13 min read
Design and Implementation of a Multi-Level Storage Architecture for Bilibili Comment Service
Zhihu Tech Column
Zhihu Tech Column
Oct 28, 2024 · Databases

TiDB Architecture, Deployment Choices, and Zhihu’s Database Platform Practices

This article explains TiDB’s distributed relational database architecture, compares Kubernetes‑based and physical‑machine deployments, and describes Zhihu’s platform‑driven approach—including TiDB Operator, TiUP, self‑service tooling, monitoring, backup, security, and FinOps—to enable efficient database management for both developers and DBAs.

Data MigrationDatabase operationsFinOps
0 likes · 15 min read
TiDB Architecture, Deployment Choices, and Zhihu’s Database Platform Practices
Yum! Tech Team
Yum! Tech Team
Oct 17, 2024 · Databases

Leveraging Distributed Database Technology (TiDB) for Digital Transformation in the Restaurant Industry: A Joint Innovation Lab Case Study

This report examines how Yum China and PingCAP’s joint innovation lab applies TiDB’s distributed database capabilities—such as elastic scaling, real‑time analytics, HTAP architecture, and multi‑region high availability—to address the restaurant sector’s operational challenges, improve customer experience, and drive data‑driven business growth.

Digital TransformationHTAPTiDB
0 likes · 16 min read
Leveraging Distributed Database Technology (TiDB) for Digital Transformation in the Restaurant Industry: A Joint Innovation Lab Case Study
DaTaobao Tech
DaTaobao Tech
Sep 20, 2024 · Databases

Database Technology Evolution: From Hierarchical to Vector Databases

The article chronicles the evolution of database technology from early hierarchical and network models through relational, column‑store, document, key‑value, graph, time‑series, HTAP, and finally vector databases, detailing each system’s architecture, strengths, limitations, typical uses, and future trends toward specialization, distributed cloud‑native designs, and AI‑driven applications.

HBaseHTAPInfluxDB
0 likes · 52 min read
Database Technology Evolution: From Hierarchical to Vector Databases
Xiaolei Talks DB
Xiaolei Talks DB
Sep 4, 2024 · Databases

Master Online TiDB Migration: Step‑by‑Step Guide for Cross‑Data‑Center Moves

This guide details three online TiDB migration scenarios—including placement‑rule replica placement, TiCDC with BR backup, and hybrid strategies—covering preparation, network and resource requirements, configuration commands, region balancing, PD leader transfer, and post‑migration cleanup for seamless cross‑data‑center database relocation.

BR BackupKubernetesPlacement Rules
0 likes · 19 min read
Master Online TiDB Migration: Step‑by‑Step Guide for Cross‑Data‑Center Moves
Zhuanzhuan Tech
Zhuanzhuan Tech
Jul 17, 2024 · Databases

Data Migration Strategies: Dual‑Write and Gray‑Scale Switch Approaches

This article presents two practical database migration schemes—dual‑write and a gray‑scale switch—detailing their workflows, code refactoring, data synchronization using Syncer, consistency verification with sync‑diff‑inspector, and operational trade‑offs for minimizing downtime and ensuring data integrity.

Dual WriteGray SwitchSyncer
0 likes · 13 min read
Data Migration Strategies: Dual‑Write and Gray‑Scale Switch Approaches
ITPUB
ITPUB
Jun 24, 2024 · Databases

What Is HTAP? Exploring Architecture Types, Key Technologies, and China’s Leading Databases

This article provides a comprehensive overview of Hybrid Transactional/Analytical Processing (HTAP) databases, detailing the four architectural patterns, five core technologies, and a comparative analysis of major Chinese HTAP products such as TiDB, OceanBase, PolarDB‑X, TDSQL, GaussDB and GreatSQL, while also discussing their characteristics and remaining challenges.

Database ArchitectureHTAPHybrid Transactional Analytical Processing
0 likes · 22 min read
What Is HTAP? Exploring Architecture Types, Key Technologies, and China’s Leading Databases
Architect's Guide
Architect's Guide
Jun 22, 2024 · Databases

Understanding TiDB: NewSQL Features, Architecture, and Comparison with MySQL and NoSQL

This article provides a comprehensive overview of TiDB, a cloud‑native NewSQL database that combines the scalability of NoSQL with the strong consistency of traditional relational databases, detailing its architecture, high‑availability design, HTAP capabilities, MySQL compatibility, and practical application scenarios.

Cloud NativeHTAPMySQL compatibility
0 likes · 23 min read
Understanding TiDB: NewSQL Features, Architecture, and Comparison with MySQL and NoSQL
Beijing SF i-TECH City Technology Team
Beijing SF i-TECH City Technology Team
Jun 18, 2024 · Databases

TiDB Operational Practices and Performance Benchmarking at Beijing Shunfeng Tongcheng Technology

This article presents a comprehensive case study of TiDB deployment at Beijing Shunfeng Tongcheng Technology, covering application scenarios, TiDB features, detailed performance benchmarks, operational challenges, optimization techniques, ecosystem tools, and best‑practice recommendations for large‑scale distributed database management.

ScalabilityTiDBdistributed database
0 likes · 19 min read
TiDB Operational Practices and Performance Benchmarking at Beijing Shunfeng Tongcheng Technology
360 Smart Cloud
360 Smart Cloud
May 27, 2024 · Databases

Deployment, Optimization, and Management of TiDB Service in 360 Zhihui Cloud

This article details the product models, usage scenarios, and a series of performance and operational optimizations—including query plan health checks, space reclamation, resource isolation, cloud‑native deployment, cross‑region high availability, and unified monitoring—implemented for the TiDB service operated by 360 Zhihui Cloud since its launch in April 2023.

Cloud NativeKubernetesPerformance Optimization
0 likes · 17 min read
Deployment, Optimization, and Management of TiDB Service in 360 Zhihui Cloud
Zhuanzhuan Tech
Zhuanzhuan Tech
Apr 17, 2024 · Databases

Database Storage Optimization and Migration Strategy for ZhaiZhai Financial System

This article presents a comprehensive analysis of the ZhaiZhai financial system's growing data volume and slow‑query issues, evaluates four storage solutions—including sharding, hot‑cold separation, TiDB, and OceanBase—selects TiDB as the optimal choice, and details the migration steps and Elasticsearch integration to improve performance and scalability.

Data MigrationDatabase OptimizationScalability
0 likes · 13 min read
Database Storage Optimization and Migration Strategy for ZhaiZhai Financial System
Selected Java Interview Questions
Selected Java Interview Questions
Apr 1, 2024 · Databases

Understanding NewSQL and TiDB: Architecture, Features, and Comparison with Traditional Databases

TiDB, an open‑source NewSQL distributed database, combines the strong consistency and ACID guarantees of traditional relational databases with the scalability of NoSQL, offering cloud‑native architecture, HTAP capabilities, high availability, and seamless MySQL compatibility, while highlighting NewSQL concepts, design trade‑offs, and migration scenarios.

Cloud NativeHTAPMySQL compatibility
0 likes · 22 min read
Understanding NewSQL and TiDB: Architecture, Features, and Comparison with Traditional Databases
Architects' Tech Alliance
Architects' Tech Alliance
Mar 8, 2024 · Databases

What’s Driving the Rise of China’s Home‑grown Databases in 2024?

The article reviews the rapid emergence of high‑performance domestic databases such as OceanBase, TiDB, MaxCompute and TDEngine, outlines their development history, compares strengths and weaknesses, discusses suitable scenarios for TiDB, and forecasts future trends for China’s database ecosystem, while providing a curated list of further readings.

ChinaMaxComputeOceanBase
0 likes · 5 min read
What’s Driving the Rise of China’s Home‑grown Databases in 2024?
MaGe Linux Operations
MaGe Linux Operations
Feb 21, 2024 · Backend Development

Is There a One‑Size‑Fits‑All Backend Architecture? Exploring Minimalist Solutions

This article examines the diversity of enterprise backend architectures, proposes a simple "universal" stack of MySQL, Redis, and Elasticsearch, evaluates its cost‑effectiveness and scalability limits, and presents extended designs—including Nginx clustering, multi‑master MySQL, sharding, MQ, Sentinel, TiDB, and micro‑service patterns—to guide choosing the most suitable solution for a given workload.

BackendTiDBarchitecture
0 likes · 15 min read
Is There a One‑Size‑Fits‑All Backend Architecture? Exploring Minimalist Solutions
IT Services Circle
IT Services Circle
Feb 8, 2024 · Databases

TiDB Overview: Architecture, Core Features, and Performance Compared with MySQL

The article explains why traditional MySQL sharding is discouraged, introduces the distributed database TiDB, details its architecture, core capabilities such as HTAP and Raft‑based consistency, compares feature support and resource usage with MySQL, and presents benchmark results demonstrating TiDB’s advantages at large scale.

HTAPMySQL ComparisonRaft
0 likes · 12 min read
TiDB Overview: Architecture, Core Features, and Performance Compared with MySQL
vivo Internet Technology
vivo Internet Technology
Dec 27, 2023 · Databases

Evolution of Vivo's Database Backup and Recovery System

Vivo replaced its fragile Python‑Celery backup system on GlusterFS—characterized by two‑day MySQL backups, single‑point failures, and weak security—with a Java‑based architecture using a Redis cluster and object storage, adding automated copying, verification, point‑in‑time recovery and migration, cutting backup windows to about ten hours and achieving near‑100 % success.

Data RecoveryDatabase BackupMongoDB
0 likes · 28 min read
Evolution of Vivo's Database Backup and Recovery System
Su San Talks Tech
Su San Talks Tech
Oct 19, 2023 · Databases

Mastering Database Sharding: Solving Read Amplification and Partition Strategies

This article explains database sharding concepts, compares vertical and horizontal partitioning, details ID‑range and modulo sharding methods, discusses the read‑amplification issue caused by non‑shard queries, and presents solutions such as auxiliary index tables, Elasticsearch integration, and TiDB as alternatives.

TiDBmysqlread amplification
0 likes · 13 min read
Mastering Database Sharding: Solving Read Amplification and Partition Strategies
Java Architect Essentials
Java Architect Essentials
Oct 12, 2023 · Databases

TiDB Overview: Architecture, Features, Compatibility, and Use Cases

This article provides a comprehensive overview of TiDB, an open‑source distributed NewSQL database, covering its origins, architecture components, high‑availability design, HTAP capabilities, MySQL compatibility, differences from traditional SQL and NoSQL, and practical deployment scenarios.

Cloud NativeDatabase ArchitectureHTAP
0 likes · 22 min read
TiDB Overview: Architecture, Features, Compatibility, and Use Cases
ITPUB
ITPUB
Sep 29, 2023 · Big Data

How Vivo Scaled Hive Metastore Using TiDB: A Deep Dive into Big Data Metadata

This article recounts Vivo’s journey to horizontally scale its Hive Metastore service by evaluating MySQL sharding, the open‑source Waggle‑Dance gateway, and ultimately selecting TiDB, detailing the migration process, configuration tweaks, performance benchmarks, encountered issues such as primary‑key conflicts, index choices, memory spikes, and the solutions implemented to ensure stable, high‑performance metadata storage for massive data volumes.

Big DataHive MetastorePerformance Optimization
0 likes · 22 min read
How Vivo Scaled Hive Metastore Using TiDB: A Deep Dive into Big Data Metadata
vivo Internet Technology
vivo Internet Technology
Sep 27, 2023 · Big Data

Horizontal Scaling of Hive Metastore Service at Vivo: Evaluation, TiDB Migration, and Lessons Learned

Vivo’s big‑data team horizontally scaled its Hive Metastore by evaluating MySQL sharding (Waggle‑Dance) against a TiDB migration, ultimately adopting TiDB, which after a synchronized cut‑over delivered ~15% faster queries, 80% DDL latency reduction, linear scaling, low resource use, and valuable operational lessons.

Big DataHive MetastoreSQL
0 likes · 19 min read
Horizontal Scaling of Hive Metastore Service at Vivo: Evaluation, TiDB Migration, and Lessons Learned
HomeTech
HomeTech
Sep 27, 2023 · Backend Development

Design and Evolution of a High‑Availability SMS Platform at AutoHome

This article details the architectural evolution, high‑availability strategies, fault‑monitoring mechanisms, and performance optimizations of AutoHome's enterprise SMS platform, covering its migration from .Net to Java, service decomposition with Kafka, multi‑datacenter deployment, and operational safeguards for large‑scale events.

BackendKafkaSMS
0 likes · 9 min read
Design and Evolution of a High‑Availability SMS Platform at AutoHome
Java Architect Essentials
Java Architect Essentials
Sep 10, 2023 · Databases

Why TiDB Is the NewSQL Database Redefining OLTP & OLAP

This article provides a comprehensive technical overview of NewSQL concepts and TiDB, covering its origins, core features, distributed architecture, high‑availability design, MySQL compatibility, unsupported MySQL functionalities, configuration defaults, and real‑world application scenarios for both OLTP and OLAP workloads.

HTAPMySQL compatibilityNewSQL
0 likes · 24 min read
Why TiDB Is the NewSQL Database Redefining OLTP & OLAP
ITPUB
ITPUB
Aug 23, 2023 · Databases

Why TiDB Is the Leading NewSQL Database for HTAP Workloads

TiDB is an open‑source NewSQL database that combines horizontal scalability, strong ACID guarantees, MySQL compatibility, and cloud‑native design to support both OLTP and OLAP workloads, offering high availability and real‑time HTAP capabilities for large‑scale applications.

Cloud NativeHTAPMySQL compatibility
0 likes · 22 min read
Why TiDB Is the Leading NewSQL Database for HTAP Workloads
MaGe Linux Operations
MaGe Linux Operations
Aug 10, 2023 · Databases

What Is NewSQL? Exploring TiDB’s Distributed Database Features

This article explains the evolution from traditional SQL and NoSQL to NewSQL, outlines the limitations of each, and provides an in‑depth look at TiDB—a cloud‑native, distributed NewSQL database—covering its architecture, core features, high‑availability design, compatibility with MySQL, and typical use cases.

Database ArchitectureHTAPMySQL compatibility
0 likes · 24 min read
What Is NewSQL? Exploring TiDB’s Distributed Database Features
Top Architect
Top Architect
Jul 31, 2023 · Databases

TiDB Overview: NewSQL Features, Architecture, Compatibility, and Application Scenarios

This article provides a comprehensive introduction to TiDB, a distributed NewSQL database, covering the evolution from traditional SQL to NoSQL, NewSQL characteristics, TiDB’s origin, core components, high‑availability design, cloud‑native architecture, compatibility with MySQL, unsupported features, and typical use cases such as sharding, data warehousing, and HTAP workloads.

HTAPMySQL compatibilityNewSQL
0 likes · 24 min read
TiDB Overview: NewSQL Features, Architecture, Compatibility, and Application Scenarios
Su San Talks Tech
Su San Talks Tech
Jul 24, 2023 · Databases

How TiDB’s NewSQL Design Solves Traditional Database Limits

This article explains the evolution from traditional SQL to NewSQL, outlines the shortcomings of classic relational databases and NoSQL, and details TiDB’s architecture, core features, high‑availability design, and practical use cases as a cloud‑native, MySQL‑compatible HTAP solution.

Cloud NativeHTAPMySQL compatibility
0 likes · 28 min read
How TiDB’s NewSQL Design Solves Traditional Database Limits
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 7, 2023 · Databases

OceanBase vs MySQL/TiDB: Performance Evaluation, Deployment Guide, and Migration Practices

This article presents a comprehensive performance comparison of OceanBase with MySQL and TiDB, details step‑by‑step deployment of OceanBase (both single‑node and cluster), explains configuration and resource‑pool management, and shares practical migration techniques and troubleshooting tips for production workloads.

OceanBaseSQLTiDB
0 likes · 23 min read
OceanBase vs MySQL/TiDB: Performance Evaluation, Deployment Guide, and Migration Practices
ITPUB
ITPUB
May 21, 2023 · Databases

Mastering Database Sharding: When, How, and Pitfalls of Partitioning

This article explains the concept, motivations, design methods, common patterns, and trade‑offs of database sharding (both table and database level), offering practical code examples, scalability criteria, and guidance on avoiding over‑engineering while considering alternatives like TiDB.

Hash ShardingPartitioningRange Sharding
0 likes · 19 min read
Mastering Database Sharding: When, How, and Pitfalls of Partitioning
Su San Talks Tech
Su San Talks Tech
Apr 11, 2023 · Databases

Why TiDB Leads the NewSQL Landscape for HTAP and Cloud‑Native Workloads

This article explains the evolution from traditional SQL to NewSQL, outlines the limitations of classic relational and NoSQL databases, and details TiDB's architecture, core features, high‑availability design, compatibility with MySQL, and real‑world use cases for both OLTP and OLAP workloads.

Cloud NativeHTAPNewSQL
0 likes · 24 min read
Why TiDB Leads the NewSQL Landscape for HTAP and Cloud‑Native Workloads
ITPUB
ITPUB
Apr 5, 2023 · Operations

Automating TiDB Operations: From Manual Pain Points to a Scalable Platform

This article details how Zhaozhuan's DBA team transformed TiDB cluster management by addressing metadata, resource allocation, upgrade, and alert challenges through a comprehensive automation platform that streamlines work orders, node operations, scaling, monitoring, and alert handling, ultimately reducing manual effort and improving reliability.

AlertingCluster ManagementTiDB
0 likes · 22 min read
Automating TiDB Operations: From Manual Pain Points to a Scalable Platform
Code Ape Tech Column
Code Ape Tech Column
Mar 28, 2023 · Databases

Understanding TiDB: NewSQL Features, Architecture, and Comparison with MySQL

This article provides a comprehensive overview of TiDB, a NewSQL distributed database, covering its origins, core features such as horizontal scaling, ACID transactions, HTAP support, cloud‑native design, MySQL compatibility, architectural components, high‑availability mechanisms, application scenarios, and differences from traditional MySQL implementations.

HTAPMySQL compatibilityNewSQL
0 likes · 26 min read
Understanding TiDB: NewSQL Features, Architecture, and Comparison with MySQL
Su San Talks Tech
Su San Talks Tech
Mar 14, 2023 · Databases

How to Solve Read‑Amplification in MySQL Sharding: Strategies & Tips

This article explains the concepts of database sharding, compares vertical and horizontal partitioning, discusses ID‑range and modulo sharding methods, analyzes the read‑amplification problem caused by non‑sharding keys, and presents practical solutions such as auxiliary index tables, Elasticsearch integration, and TiDB adoption.

ElasticsearchTiDBdatabase scaling
0 likes · 14 min read
How to Solve Read‑Amplification in MySQL Sharding: Strategies & Tips
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 28, 2023 · Databases

Using sync-diff-inspector for MySQL/TiDB Data Validation and Repair

This article introduces the open‑source sync‑diff‑inspector tool, explains how to download and install it, and provides detailed configuration and command‑line examples for schema‑level, table‑level, and range‑based data validation between MySQL instances, including automatic SQL repair generation and common troubleshooting tips.

ConfigurationDatabase ToolsSQL repair
0 likes · 15 min read
Using sync-diff-inspector for MySQL/TiDB Data Validation and Repair
Zhuanzhuan Tech
Zhuanzhuan Tech
Feb 15, 2023 · Operations

Automating TiDB Operations at ZuanZuan: From Manual Management to Platform‑Based Automation

This article details ZuanZuan's journey of automating TiDB operations, covering the initial operational pain points, the implementation of metadata and resource management, comprehensive upgrades, alarm redesign, and the development of a work‑order‑driven platform that streamlines node, scaling, decommission, and monitoring tasks while significantly reducing manual effort and costs.

AutomationDatabase ManagementOperations
0 likes · 18 min read
Automating TiDB Operations at ZuanZuan: From Manual Management to Platform‑Based Automation
HomeTech
HomeTech
Feb 1, 2023 · Databases

TiDB Database Deployment and Operational Practices at AutoHome

This article presents a comprehensive case study of TiDB, an open‑source distributed relational database, detailing its features, architecture, evolution within AutoHome, key business applications such as recommendation pools, financial reporting, and interactive events, as well as the automated operations and troubleshooting practices adopted to ensure high availability and scalability.

AutohomeDatabase operationsHTAP
0 likes · 6 min read
TiDB Database Deployment and Operational Practices at AutoHome
DeWu Technology
DeWu Technology
Dec 16, 2022 · Databases

TiDB Adoption and Operational Practices at Dewu

Dewu transitioned from a single‑instance MySQL setup to a distributed TiDB architecture—using three TiDB, PD, and TiKV/TiFlash nodes, automated backups, Prometheus monitoring, and chaos‑engineering controls—which delivered linear scalability, eliminated slow queries, cut infrastructure costs by about 58 % and maintained stable performance during major sales events.

MySQL ComparisonTiDBdistributed database
0 likes · 28 min read
TiDB Adoption and Operational Practices at Dewu
ITPUB
ITPUB
Nov 19, 2022 · Databases

Choosing Between OceanBase and TiDB: Architecture, Performance, and Trade‑offs

This article compares the architectures of OceanBase and TiDB, explaining how their sharding and compute‑storage separation designs affect high availability, latency, and workload suitability, and offers guidance on selecting the right distributed database for complex enterprise applications.

Compute-Storage SeparationOceanBaseTiDB
0 likes · 12 min read
Choosing Between OceanBase and TiDB: Architecture, Performance, and Trade‑offs
DeWu Technology
DeWu Technology
Nov 11, 2022 · Databases

TiDB Overview: Architecture, Storage Model, and Execution Plan

TiDB is an open‑source, MySQL‑compatible distributed database that unifies OLTP and OLAP by using a stateless SQL layer, a Placement Driver for metadata and Raft‑managed TiKV/TiFlash storage, key‑value mapping with RocksDB, and a push‑down execution engine that splits work between coprocessor and root tasks for scalable, highly available workloads.

HTAPSQL Execution PlanStorage Engine
0 likes · 17 min read
TiDB Overview: Architecture, Storage Model, and Execution Plan
Xiaolei Talks DB
Xiaolei Talks DB
Oct 19, 2022 · Databases

How to Deploy TiDB on Private or Public Cloud with TiDB Operator

This article explains how TiDB, a cloud‑native distributed database, can be deployed on private or public clouds using the TiDB Operator, covering Kubernetes basics, operator concepts, TiDB Operator features, architecture, and upcoming deployment guides.

Database DeploymentKubernetesOperator
0 likes · 10 min read
How to Deploy TiDB on Private or Public Cloud with TiDB Operator
360 Smart Cloud
360 Smart Cloud
Sep 8, 2022 · Databases

Integrating TiDB Multi‑Cluster Monitoring with Prometheus, Consul, and VictoriaMetrics

This article presents a step‑by‑step solution for consolidating TiDB multi‑cluster monitoring by deploying Consul for service registration, configuring Prometheus to discover services via Consul, and optionally replacing Prometheus with VictoriaMetrics to achieve unified dashboards, scalable data collection, and easier health inspection across dozens or hundreds of instances.

ConsulGrafanaPrometheus
0 likes · 10 min read
Integrating TiDB Multi‑Cluster Monitoring with Prometheus, Consul, and VictoriaMetrics
ITPUB
ITPUB
Aug 13, 2022 · Databases

Why HTAP Databases Matter: Inside Oracle HeatWave, Google AlloyDB, TiDB, and OceanBase

The article examines the growing demand for HTAP databases, comparing cloud‑native solutions such as Google AlloyDB, Oracle MySQL HeatWave, Amazon Aurora, and domestic offerings like TiDB and OceanBase, analyzing their architectures, offload mechanisms, performance claims, and trade‑offs for mixed OLTP/OLAP workloads.

Cloud NativeGoogleHTAP
0 likes · 11 min read
Why HTAP Databases Matter: Inside Oracle HeatWave, Google AlloyDB, TiDB, and OceanBase
Dada Group Technology
Dada Group Technology
Aug 10, 2022 · Databases

Evolution of JD.com Delivery Review System Architecture and Storage Strategy

This article details the JD.com delivery review system's business scenarios, architectural evolution from a MySQL‑based design to a diversified storage stack using HBase, Redis, Elasticsearch and TiDB, and discusses the performance challenges, solutions, and future outlook for scalable, high‑availability data management.

HBaseScalabilityTiDB
0 likes · 15 min read
Evolution of JD.com Delivery Review System Architecture and Storage Strategy
Xiaolei Talks DB
Xiaolei Talks DB
Aug 8, 2022 · Databases

Mastering TiDB Upgrades: Strategies, Risks, and Real‑World Case Studies

This comprehensive guide explains why TiDB upgrades are essential, compares offline, forced, and smooth upgrade methods, outlines detailed step‑by‑step procedures, highlights advantages and risks, and shares practical check‑points and real‑world case studies to help DBAs ensure a safe, performant migration.

TiDBdatabaseperformance
0 likes · 21 min read
Mastering TiDB Upgrades: Strategies, Risks, and Real‑World Case Studies
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 29, 2022 · Databases

SQLE 1.2207.0 Release Notes and Feature Summary

The SQLE 1.2207.0 release introduces a redesigned dashboard, incremental intelligent scanning for slow‑log and TiDB audit logs, OceanBase MySQL‑mode audit plugin, JetBrains IDE audit plugin, along with numerous optimizations, bug fixes, and detailed release information for both community and enterprise editions.

Database AuditingIDE pluginOceanBase
0 likes · 7 min read
SQLE 1.2207.0 Release Notes and Feature Summary
DataFunSummit
DataFunSummit
Jul 28, 2022 · Databases

TiDB HTAP for Financial Intelligent Risk Control: Architecture, Challenges, and Solutions

This article presents a comprehensive overview of how TiDB's HTAP capabilities enable real‑time multi‑source data processing for financial intelligent risk control, detailing the overall risk‑control architecture, digital transformation challenges, TiDB‑based solutions, practical implementations, and future outlooks.

Database ArchitectureHTAPIntelligent Risk Control
0 likes · 12 min read
TiDB HTAP for Financial Intelligent Risk Control: Architecture, Challenges, and Solutions
ITPUB
ITPUB
Jul 8, 2022 · Databases

Uncovering the Flaws: Why No Distributed Database Architecture Is Perfect

This article examines the most common Chinese distributed database architectures, comparing integrated SHARDING designs like OceanBase with separated compute‑storage models such as TiDB and SQL‑proxy based systems, highlighting their inherent trade‑offs, performance challenges, and practical considerations for choosing the right solution.

OceanBaseSQL proxyTiDB
0 likes · 11 min read
Uncovering the Flaws: Why No Distributed Database Architecture Is Perfect
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 17, 2022 · Databases

SQLE 1.2206.0-pre1 Release Notes and New Feature Overview

The preview release SQLE 1.2206.0-pre1 introduces TiDB audit plugin support, TiDB‑specific rules, enhanced SQL syntax checks, and recommendations on primary‑key usage, while providing full release details, documentation links, and references to prior versions for database administrators and developers.

Database AuditingRelease NotesSQLE
0 likes · 6 min read
SQLE 1.2206.0-pre1 Release Notes and New Feature Overview
Xiaolei Talks DB
Xiaolei Talks DB
Jun 6, 2022 · Databases

Master TiDB 6.0 Troubleshooting with PingCAP Clinic and Diag

This article explains how to streamline TiDB 6.0 fault diagnosis by replacing manual screenshot and log collection with PingCAP's Clinic service and the TiUP Diag tool, covering data collection, upload procedures, security considerations, and additional diagnostic capabilities.

ClinicTiDBTiUP
0 likes · 19 min read
Master TiDB 6.0 Troubleshooting with PingCAP Clinic and Diag
Xiaolei Talks DB
Xiaolei Talks DB
May 15, 2022 · Databases

How TiDB Achieves Multi-Active High Availability Across Multiple Data Centers

This article explains TiDB's multi‑active high‑availability architectures—including same‑city dual‑center, triple‑center, and two‑region three‑center deployments—detailing hard requirements, RPO/RTO goals, placement‑rule configurations, and practical disaster‑recovery recommendations for distributed database clusters, and how adaptive sync modes affect failover performance.

Placement RuleTiDBhigh availability
0 likes · 12 min read
How TiDB Achieves Multi-Active High Availability Across Multiple Data Centers
Xiaolei Talks DB
Xiaolei Talks DB
Apr 16, 2022 · Databases

Why TiKV Scale‑In Stuck After Expansion? Diagnosis and Fix

This guide explains why a TiKV node remains pending offline after a scale‑out and scale‑in operation, walks through detailed log inspection, region checks, and command‑line troubleshooting, and provides a step‑by‑step solution to forcefully remove the problematic region and clean up the store.

ClusterTiDBTiKV
0 likes · 13 min read
Why TiKV Scale‑In Stuck After Expansion? Diagnosis and Fix
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 7, 2022 · Databases

TiDB 2.1.x to 4.0.13 Upgrade and Data Migration Guide

This article provides a comprehensive step‑by‑step guide for senior DBAs to upgrade an online TiDB 2.1.x cluster to version 4.0.13 via data migration, detailing environment assessment, configuration changes, component deployment, full and incremental data transfer, consistency verification, permission synchronization, and traffic switchover.

AnsibleCluster ManagementDatabase Upgrade
0 likes · 26 min read
TiDB 2.1.x to 4.0.13 Upgrade and Data Migration Guide
Xiaolei Talks DB
Xiaolei Talks DB
Mar 26, 2022 · Databases

Why TiDB’s GC Stalled and How to Fix Disk Space Alarms

This article walks through a real‑world TiDB/TiKV disk‑space alarm case, diagnosing why the GC worker got stuck, how TiCDC’s lingering changefeed caused outdated MVCC versions, and the step‑by‑step commands and monitoring tricks used to restore normal GC and reclaim storage.

TiCDCTiDBTiKV
0 likes · 15 min read
Why TiDB’s GC Stalled and How to Fix Disk Space Alarms
Xiaolei Talks DB
Xiaolei Talks DB
Mar 16, 2022 · Operations

How to Recover a TiKV Cluster After Multiple Node Failures

This article demonstrates how to simulate and recover TiKV cluster failures by shutting down one, two, or three nodes, explains the impact on Raft groups and region availability, and provides step‑by‑step commands for disabling PD scheduling, using tikv‑ctl, and restoring data integrity.

Cluster RecoveryData lossPD
0 likes · 28 min read
How to Recover a TiKV Cluster After Multiple Node Failures
DataFunTalk
DataFunTalk
Mar 15, 2022 · Big Data

Bilibili's Billion‑Scale Data Synchronization Using Apache SeaTunnel

This article details Bilibili's implementation of a hundred‑terabyte‑per‑day data synchronization pipeline, covering tool selection between DataX‑based Rider and SeaTunnel‑based AlterEgo, architecture design, performance tuning, logging optimization, rate‑limiting strategies, and comprehensive monitoring for large‑scale offline data ingestion and export.

Apache SeaTunnelBig DataClickHouse
0 likes · 13 min read
Bilibili's Billion‑Scale Data Synchronization Using Apache SeaTunnel
DataFunSummit
DataFunSummit
Feb 20, 2022 · Databases

Understanding TiDB Architecture and Real‑Time Application Scenarios

This article explains TiDB's HTAP architecture, covering industry challenges, the row‑store TiKV and column‑store TiFlash design, MPP integration in TiDB 5.0, and a range of real‑time use cases such as dashboards, reporting, and data‑warehouse pipelines.

Database ArchitectureHTAPMPP
0 likes · 16 min read
Understanding TiDB Architecture and Real‑Time Application Scenarios
Cloud Native Technology Community
Cloud Native Technology Community
Jan 24, 2022 · Cloud Native

Building a Unified Cross‑Cluster Network Plane with Kube‑OVN for TiDB Deployment

The article explains how Kube‑OVN can create a flexible, efficient, and secure cross‑Kubernetes‑cluster network plane to meet user demands such as high availability, multi‑cloud separation, disaster‑recovery, and hybrid‑cloud compliance, and demonstrates its use with TiDB, MySQL, and WordPress workloads.

Cloud NativeCross-Cluster NetworkingKube-OVN
0 likes · 8 min read
Building a Unified Cross‑Cluster Network Plane with Kube‑OVN for TiDB Deployment
JD Cloud Developers
JD Cloud Developers
Jan 21, 2022 · Databases

Mastering TiDB SQL Layer: Architecture, Optimization, and Real-World Cases

This article explains TiDB's SQL layer architecture, details how SQL requests are processed and optimized, demonstrates the use of EXPLAIN and EXPLAIN ANALYZE, and presents two real‑world case studies that illustrate common performance pitfalls and practical optimization techniques.

Database PerformanceSQL LayerSQL Optimization
0 likes · 8 min read
Mastering TiDB SQL Layer: Architecture, Optimization, and Real-World Cases
ITPUB
ITPUB
Jan 7, 2022 · Databases

Exploring the TiDB Ecosystem: Tools, Automation, and Operations for Distributed Databases

The article explains what an ecosystem means, then defines a distributed‑database ecosystem and uses TiDB as a case study to detail upstream/downstream migration tools, backup and recovery solutions, monitoring and alerting, daily operational utilities, the TiDB Operator for Kubernetes, automation platforms, and emerging projects built on TiDB components.

BackupEcosystemTiDB
0 likes · 8 min read
Exploring the TiDB Ecosystem: Tools, Automation, and Operations for Distributed Databases