Search across authors, categories, and technical themes. The layout mirrors the editorial references while staying responsive and fast.
This article analyzes a puzzling case where data consistency checks between a MySQL source and an OceanBase target report matching results despite visible record differences, explains the OMS ordinary and Inmode validation modes, and outlines scenarios that trigger Inmode verification.
Index Condition Pushdown (ICP) is a MySQL 5.6 feature that pushes part of WHERE filtering to the storage engine, reducing row reads and I/O; this article explains its principles, activation, usage examples, performance testing, and conditions under which ICP can be applied.
This article explores the problem of generating short, sequential numeric account IDs, evaluates the classic Snowflake algorithm, proposes a MySQL auto‑increment based solution with a dedicated ID‑generation table, analyzes deadlock issues, and finally presents a segment‑based ID allocation scheme that reduces waste and supports scaling.
This article explains what mysqldump is, describes its backup mechanism, lists command‑line options with detailed meanings, provides example commands for exporting databases or tables, and shows how to restore data using both system and source commands.
This guide explains why three servers are needed for high availability, walks through hardware and software preparation, network configuration, MySQL master‑slave replication setup, HAProxy load‑balancing, and firewall/SELinux adjustments, providing complete command‑line examples for each step.
This article explains why MySQL alone struggles with large‑scale queries, introduces Elasticsearch as a complementary search store, and compares several synchronization approaches—including synchronous write, asynchronous write, Logstash, binlog real‑time sync, Canal, and Alibaba Cloud DTS—detailing their implementation methods, advantages, disadvantages, and typical application scenarios.
The article combines practical advice for fresh graduates seeking internships and interview tips, shares a detailed ByteDance three‑round backend interview experience, explains MySQL master‑slave replication stages, binlog formats, and compares blocking, non‑blocking, multiplexed, and asynchronous I/O models.
This article reviews six mainstream solutions for keeping MySQL and Elasticsearch in sync—including synchronous double‑write, asynchronous MQ‑based double‑write, Logstash polling, Canal binlog listening, DataX batch migration, and Flink stream processing—detailing their scenarios, advantages, drawbacks, and practical code examples to guide optimal technical selection.
This article explores the evolution from using the Snowflake algorithm to a MySQL‑based short numeric ID generation scheme, detailing challenges such as long IDs, deadlocks with REPLACE INTO, and presenting a segment‑based solution that allocates ID blocks, tracks unused IDs, and avoids concurrency issues.
This article explains how to use MySQL's EXPLAIN command to analyze slow queries, interprets each field in the execution plan, provides practical examples and optimization techniques, and offers advanced diagnostics for improving index usage and overall SQL performance.