0 views collected around this technical thread.
The article explains how Baidu Cloud Redis's Data Flashback feature combines RDB snapshots with timestamped AOF logs to provide fast, space‑efficient, point‑in‑time data recovery, overcoming the limitations of native Redis persistence in high‑traffic scenarios.
The article summarizes Lai Kunchi's presentation at the 24th GOPS Global Operations Conference, covering the current state and challenges of database development, Guangdong Mobile's database operation system, and future directions for managing heterogeneous databases in evolving business architectures.
This article explains how to use PHP's mysqli_num_rows function to retrieve the number of rows in a MySQL result set, providing a complete example that connects to a database, executes a query, checks for errors, obtains the row count, and outputs it.
This article explains how to handle MySQL disk‑space alerts by using the pt‑online‑schema‑change (pt‑osc) tool to selectively retain needed rows, migrate data to a temporary table, and drop the original table, thereby achieving fast, low‑impact data cleanup.
This article analyzes why OceanBase backup clean tasks become stuck, examines log and query evidence of scheduler failures and NFS I/O errors, and recommends correcting NFS configuration to resolve the backup cleanup problem.
This guide walks through accessing a production TiDB cluster via pod IP, Service ClusterIP, or DNS, initializing users and databases, and performing scaling and version upgrades by editing the cluster's YAML configuration in Kubernetes.
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.
This article provides 10 detailed Python code examples demonstrating how to connect to, query, insert, update, delete, and manage MySQL databases with proper error handling and resource management.
This article details a step‑by‑step recovery of a ClickHouse 4‑shard, 3‑replica cluster after a node’s disks failed, covering verification of residual data, Zookeeper metadata cleanup, table reconstruction, distributed table restoration, and validation of synchronization across replicas.
This article details Qunar.com's Redis automation operations system, covering background challenges, the high‑availability cluster architecture, resource management, automated deployment, various migration strategies, scaling mechanisms with RedisGate, inspection processes, and future AI‑driven enhancements.
The paper details Baidu Intelligent Cloud’s design and deployment of a domain‑specific knowledge‑base Q&A system for database operations, combining prompt‑engineered LLMs with hybrid vector‑search using LangChain, BES vector store, and custom ingestion, addressing recall, token limits, and hallucination challenges across dashboard and IM bot interfaces.
This article analyzes why the MariaDB audit plugin crashes on MySQL 5.7, presents compatibility tables before and after source modification, details the verification steps, and provides a step‑by‑step solution including source code changes and recompilation to make the plugin work reliably.
An original case study examines a MongoDB 4.0.14 replica set crash triggered by exceeding the WiredTiger session limit when a primary creates a background index and subsequently drops it, causing blocking on the secondary, leading to connection saturation, session exhaustion, and instance failure.
This article explains what SQL injectors are in MyBatis‑Plus, lists the built‑in extended injectors, shows how to configure them globally, demonstrates custom mapper creation, provides complete code examples and test cases, and guides readers through building their own SQL injector for full‑field updates and batch operations.
The article details Huolala’s comprehensive approach to managing diverse databases across multiple clouds, covering systematic stability engineering, automated SQL governance, Redis and Kafka reliability strategies, cost‑optimization tactics, and the evolving roles of modern DBAs in a complex, high‑scale environment.
This article provides a step‑by‑step guide for scaling an OceanBase cluster, covering both white‑screen and black‑screen methods to add zones (replicas) and resources (OBServers), including configuration file preparation, deployment commands, zone addition, verification queries, and procedures for both expansion and contraction.
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.
This article analyzes ClickHouse distributed DDL execution by presenting typical failure scenarios, dissecting the underlying Zookeeper‑based workflow, and offering practical mitigation steps to avoid DDL timeouts and improve cluster stability for large‑scale data operations.
Bigkeys—Redis values over 1 MB or structures with more than 2,000 elements—cause memory imbalance, command blocking, network overload, and migration failures, so DBAs must detect them using built‑in commands or RDB analysis, split or partition oversized keys, and tune migration settings to preserve performance and availability.
The article analyzes a MySQL MGR cluster failover incident caused by a VM pause and system time jump, explains the underlying detection mechanisms, presents detailed source code excerpts, and demonstrates through debugging that time changes alone do not trigger MGR failover.