Achieving RPO=0: How XiaoHongShu’s Binlog Server Boosts MySQL Replication Speed and Data Consistency

This article explains how XiaoHongShu’s database team built a lightweight Binlog Server to accelerate semi‑synchronous MySQL replication beyond 300 MB/s, achieve RPO=0 data‑loss‑free failover, and improve high‑availability without manual intervention, backed by performance tests and detailed architecture diagrams.

Binlog ServerRPO=0Semi‑synchronous Replication

0 likes · 15 min read

Achieving RPO=0: How XiaoHongShu’s Binlog Server Boosts MySQL Replication Speed and Data Consistency

Aikesheng Open Source Community

Jul 23, 2021 · Databases

Implementing Conversion Between MySQL Group Replication (MGR) and Semi‑Synchronous Replication

This guide demonstrates how to switch a MySQL 5.7.32 deployment between Group Replication (MGR) and semi‑synchronous replication, covering environment checks, node configuration, plugin installation, replication setup, validation, and the limitations encountered when combining the two modes.

ConfigurationGroup ReplicationSemi‑synchronous Replication

0 likes · 9 min read

Implementing Conversion Between MySQL Group Replication (MGR) and Semi‑Synchronous Replication

Aikesheng Open Source Community

Oct 23, 2020 · Databases

Diagnosing Slow Master Commit Performance in MySQL Semi‑Synchronous Replication

This article explains how to identify which slave in a MySQL one‑master‑multiple‑slave semi‑synchronous setup is slowing the master’s commit performance by using debug logging and examining the error log for the last ACK server ID.

Performance DiagnosisSemi‑synchronous Replicationdatabases

0 likes · 3 min read

Diagnosing Slow Master Commit Performance in MySQL Semi‑Synchronous Replication

Aikesheng Open Source Community

Mar 21, 2019 · Databases

Analysis of MySQL Bug #89370: Semi‑Synchronous Replication Stall

This article examines MySQL bug #89370, detailing how configuring semi‑synchronous replication with multiple slaves can cause a slave to stop receiving data for minutes despite normal replication status, and explains the underlying mechanisms, reproduction steps, and root cause of the issue.

BinlogSemi‑synchronous Replicationbug

0 likes · 8 min read

Analysis of MySQL Bug #89370: Semi‑Synchronous Replication Stall

WeChat Backend Team

Aug 24, 2016 · Databases

Understanding MySQL Semi‑Synchronous Replication and Master Switch Challenges

This article examines MySQL's semi‑synchronous replication, analyzes consistency scenarios across master‑slave failures and switches, and highlights the difficulties of data rollback and multi‑master conflicts that affect high‑availability clusters.

Data ConsistencySemi‑synchronous Replicationdisaster recovery

0 likes · 12 min read

Understanding MySQL Semi‑Synchronous Replication and Master Switch Challenges