An Article to Help You Understand All TiDB Tools & Common Problem-Solving Guide

This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 一篇文章帮你解读所有 TiDB 工具&常见问题解决大全

| username: Billmay表妹


Technical Sharing | TiUP Tool - Core Process Analysis of TiDB Cluster Rolling Upgrade

TiUP Parameter Modification Shows Success but Does Not Take Effect

Practical Use of TiUP to Modify Cluster Directory

TiUP: Essential Tool for TiDB Aer

Experimental Process of Installing and Deploying TiDB Cluster Using TiUP

TiDB Upgrade - Summary of Using Ansible and TiUP

Three Accounts Used by TiUP Cluster

Experience of Semi-Automatic Upgrade of TiDB Cluster Using TiUP

Solution for Run Command Timeout/SSH Timeout Error During TiUP Cluster Upgrade

Node Destroy Issue Caused by Inadequate Directory Conflict Detection in TiUP and Its Solution

Solution for TiFlash Restart Failure During TiUP Upgrade

TiUP Usage Overview - 01

TiUP Usage Overview - 02


TiCDC Source Code Interpretation (2) - Introduction to TiKV CDC Module

TiKV Source Code Reading Trilogy (2) - Read Process

Three Key Techniques for Handling TiKV Decommissioning and Offline Anomalies

Offline Deployment Series Article 2: TiDB Cluster Upgrade (5.3.0->5.4.2) & Scaling TiDB Server, PD, TiKV, TiFlash

Summary of TiKV Main Memory Structure and OOM Troubleshooting

TiKV & TiFlash Accelerate Complex Business Queries

Production Environment TiKV IO-Util Approaching 100% Issue Troubleshooting Guide

Steps for Decommissioning TiKV in Production Environment TiDB Cluster

Comparison Test of Business Recovery Speed (Leader Balancing Speed) After TiKV Node Restart v6.0 vs v5.1.2

Experience with TiKV Leader Balancing Acceleration After Restart in v6.0

How to Solve TiKV Decommissioning Stuck Issue?

Disk Usage Issue in TiKV Caused by GC Inactivity Triggered by TiCDC Anomaly

TiDB Cluster Recovery - TiKV Cluster Unavailability

Summary of Adding TLS to TiKV & PD

Compilation Sharing of TiDB/PD/TiKV on CentOS7

Pitfalls Encountered When Expanding TiKV Nodes

Lessons Learned from Unsafe-Recover of TiKV Multi-Replica Loss

Practice of TiKV Multi-Replica Loss and Recovery

TiFlink: Implementing Strongly Consistent Materialized Views Using TiKV and Flink

Detailed Steps for Expanding TiKV Nodes in TiDB 4.0 Production Environment

Troubleshooting Ideas for TiKV Node Stuck in Pending Offline

Tuya Smart’s Journey of Choosing TiKV

High Memory Usage Issue in TiKV Nodes of TiDB Cluster

Troubleshooting High Memory Usage in TiKV Nodes in x86 and ARM Mixed Deployment Architecture

Brief Reading of TiKV Source Code - Server Start

Fault Recovery Drill for TiKV Multi-Replica Loss

Detailed Explanation of TiDB Cluster Availability and TiKV Label Planning

Brief Reading of TiKV Source Code - Config

Experience in Recovering from TiKV Node Disk Exhaustion

Some TiKV Nodes Fail to Connect to PD After pd-recovery

TiKV Notes - Raft Replication State Machine - Unfinished

High Availability Test: KILL TiKV-Server, Transaction TPS Drops to Zero Explained

TiKV Cluster Deployment Precautions

TiKV Architecture Principles (Notes)

038 - Saving Private Ryan: How TiDB Recovers When TiKV is Damaged

Single Machine Deployment of TiKV Development Environment

TiDB 3.0.2 Version TiKV Crash Test for a Certain Business

Comparison Test of TiKV Crash Between TiDB 3.0.1 and 3.0.2 Versions

Friday’s Blow: TiKV Node Crash and Failure to Start Normally


Implementation and Design of TiFlash Expressions

Introduction to TiFlash Proxy Module

Offline Deployment Series Article 2: TiDB Cluster Upgrade (5.3.0->5.4.2) & Scaling TiDB Server, PD, TiKV, TiFlash

Step-by-Step Guide to Implementing TiFlash Vectorized Functions | Become a TiFlash Contributor in Ten Minutes

Design and Implementation Analysis of TiFlash DeltaTree Index

TiKV & TiFlash Accelerate Complex Business Queries

Compiler-Oriented Automatic Vectorization Acceleration in TiFlash

TiFlash 6.0 on K8s Expansion and New Features Practice

Exploring the Use of TiFlash in Multi-Label Combination Scenarios Based on TiDB V6.0

Interpretation of New Features in TiDB 6.0 | New Operators and Function Pushdown in TiFlash

Fault Interpretation: v5.1.1 - Adjusting Variable TiDB_isolation_read_engines Affects TiFlash SQL Execution Plan

Scalability Test Report of TiFlash Under TPC-H - v5.1.0

Comparison Test Between TiFlash 5.0.1 and 4.0.10

TiDB HTAP Getting Started Guide | Working Principle of Adding TiFlash Replicas

TiDB Upgrade, TiFlash Testing, and Comparison with ClickHouse

TiFlash Trial Case

Comparison Test Between TiFlash 5.x and 4.x

TiFlash Operations and Maintenance Discussion

Solution for TiFlash Restart Failure During TiUP Upgrade

Exploring TiDB - TiFlash

TiDB 4.0 Trial Experience - TiFlash

TiDB Operator

TiDB Operator Configures Automatic Failover for TiDB Cluster

TiDB Operator Data Import

TiDB Operator Scaling and Cluster Management

Monitoring and Alerting for TiDB Cluster Deployed by TiDB Operator

TiDB on Cloud with TiDB Operator

Local Kind Experience TiDB Operator Minimal Practice

Building TiDB Cluster Using TiDB Operator on Minikube (Continuously Updated)

Practical Use of TiDB Operator in Native K8s Environment


Review and Learn | Summary of Mydumper & Dumpling Knowledge Points

Optimization of Concurrent Export Within Table by Dumpling

TiDB Basic Operations and Maintenance Video Tutorial (3) - Export Tool Dumpling

TiDB Lightning

Practical Case of Lightning Checksum Failed Error

Handling Incident of TiDB Cluster Restart Failure Caused by Lightning Import Failure

TiDB - Hard to Detect Lightning TiDB-backend Mode Import Optimization

Lightning for CSV: Quick Guide

TiDB Data Migration (DM)

Data Migration High Availability Drill

Data Migration Function Test

Common Issues in Data Migration Operations and Maintenance

DM Practical Manual

Fault Handling | DM Setup MySQL 8.0 Sync Link Error: code=26005

TiDB-DM Alarm DM_sync_process_exists_with_error Troubleshooting

How DM Handles DML

TiDB DM Practical Use

DM Sync Modify Column Statement to TiDB 5.3 Pitfall 1: Data Garbled

DM Sync Modify Column Statement to TiDB 5.3 Pitfall 2: DDL Statement Replay

Introduction to “Optimistic Coordination” Mode for DM Sharding DDL

Introduction to “Pessimistic Coordination” Mode for DM Sharding DDL

Solution for DM Relay Processing Unit Error

DM - V1.0.5 Usage Summary

DM Multiple Databases Merged into TiDB

Various Ways to Calculate DM Sync Data Latency to TiDB

TUG Topic Discussion 005: Usage Scenarios and Common Issues of TiDB Ecosystem Tools (DM, TiCDC, etc.)

Common Issue Troubleshooting - DM Primary Key Conflict Causes and Troubleshooting Ideas

Adding Aliyun RDS/DM S Online DDL Support to TiDB DM

DM Filter Practical Summary

Summary of DM Operations and Maintenance Pitfalls

Discussion on Auto_Increment Primary Key Conflict Caused by DM Sync

Small Test of Migrating MySQL Data to TiDB Using DM

Issues Encountered When Syncing Aliyun DRDS 5.7 with DM 1.0.5 and TiDB 3.0.15

TiDB DM Scaling and Monitoring

DM 2.0 Initial Test

DM 2.0 First Experience

Summary of Issues During DM Sync Process


TiCDC Practice: TiDB Cluster Merge

Application of New Features of TiCDC in Various Scenarios

Master-Slave Cluster Data Verification Based on TiCDC Sync

TiCDC Migration - TiDB to MySQL Test

Handling TiCDC Sync Delay Issues

TiCDC Architecture and Data Sync Link Analysis

First Experience with TiDB TiCDC 6.0

TiCDC 6.0 Principle - Sorter Evolution

Practical Application of TiCDC Canal_JSON

TiCDC Series Sharing - Open API and Business System Integration

TiCDC Series Sharing - 02 - Analysis of Sync Model and Basic Architecture

TiCDC Series Sharing - 01 - Brief Introduction to Background and Usage Overview

Experience TiDB v6.0.0 - TiCDC

Application of TiDB Online DDL in TiCDC

TiDB v5.1.2 - TiCDC Not Syncing, checkpointTs Not Advancing Issue Troubleshooting

Disk Usage Issue in TiKV Caused by GC Inactivity Triggered by TiCDC Anomaly

TiDB TiCDC Practical Use

Strange Phenomenon of TiCDC Without Errors but TSO Not Changing

First Experience with TiCDC 4.0.15

Analysis of TiCDC Application Scenarios

Practical Implementation of Dual-Cloud Architecture Based on TiCDC

TUG Topic Discussion 005: Usage Scenarios and Common Issues of TiDB Ecosystem Tools (DM, TiCDC, etc.)

Practical Use of TiCDC for Real-Time Sync of TiDB Data to Backup Escape Environment

TiCDC Implementation of TiDB Backup Solution

Flink Best Practices - Streaming TiDB Data to Flink via TiCDC

TiDB Instance Data Sync Practice with TiCDC

TiCDC Usage Insights

TiDB Binlog

TiDB Binlog User Manual for Oracle Target Database Support

TiDB 4.0 Cross-Datacenter Cluster Deployment Based on Binlog

Supplementary RECOVER Leading to TiDB Binlog Sync Error Handling

TiDB Binlog Practical Use


EMR with TiSpark (on EKS)

[TiDB + TiSpark Deployment -

| username: 春风十里 | Original post link

Very comprehensive, thanks for organizing.

| username: 考试没答案 | Original post link

It needs to be studied carefully.

| username: ShawnYan | Original post link

Several additional articles on TiCDC.

TiDB CDC v6.5.0 New Features Practice - Data Xiaohei’s Column - 专栏 - TiDB CDC v6.5.0 新特性实践 | TiDB 社区
TiDB Database Major Version Upgrade - Cross-Machine Upgrade Based on TiCDC - Gary’s Column - 专栏 - TiDB 数据库大版本升级-基于TiCDC异机升级 | TiDB 社区
TiCDC+Confluent Synchronize Data to Oracle - Qingfeng Mingyue’s Column - 专栏 - TiCDC+Confluent同步数据到Oracle | TiDB 社区
Planned and Unplanned Switch Verification Steps for TiDB Replication Cluster Based on TiCDC - Pepezzzz’s Column - 专栏 - 基于 TiCDC 的 TiDB 复制集群的计划内和计划外切换验证步骤 | TiDB 社区
First Experience of TiCDC Data Synchronization to MySQL - Zjhangzhou2022’s Column - 专栏 - TICDC 数据同步至 MySQL初体验 | TiDB 社区

| username: Billmay表妹 | Original post link

Thumbs up!