Sharing daily database operations insights, from distributed databases to cloud migration. Author: Dai Xiaolei, with 10+ years of DB ops and development experience. Your support is appreciated.
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.
After a network disruption caused Paxos messages to be ignored and memory shortages prevented data migration, this article details how the Aerospike cluster became unavailable, the diagnostic logs, and the step‑by‑step remediation involving node restarts, memory tuning, and adding new nodes for load balancing.
This article walks through a real‑world case where a simple INSERT in TiDB runs for tens of seconds, explains how transaction modes and write conflicts trigger SQL retries, and outlines how to diagnose and configure retry behavior to avoid slow writes.
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.
