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 guide explains why databases like TiDB have specific hardware requirements and provides detailed recommendations for CPU selection, memory tuning, storage choices, and network configuration to achieve optimal performance and cost efficiency.
This article walks through a real‑world TiDB PD cluster outage, explains how to diagnose the failure, retrieve necessary IDs, install and use the pd‑recover tool, and finally restore the cluster to a healthy state with detailed commands and screenshots.
This article traces the history of data management from manual storage and early file‑system models through the relational revolution to modern distributed databases, covering key concepts like CAP theory, distributed transactions, HTAP, and cloud‑native deployment trends.
This article explains what a distributed database ecosystem is, using TiDB as a case study to detail upstream/downstream tools, backup and monitoring solutions, automation platforms, and emerging projects that together form a comprehensive TiDB ecosystem.
This tutorial walks you through installing the Aerospike NoSQL database, tuning Linux system parameters, configuring a three‑node cluster, performing basic AQL operations, and setting up AMC monitoring, all within roughly ten minutes of setup time.
This article introduces Aerospike, a hybrid‑SSD, micro‑second, petabyte‑scale distributed real‑time NoSQL database, detailing its company background, architectural design, performance optimizations, and ideal use cases such as high‑throughput ad‑tech workloads.
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.
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.
