Semi-synchronous replication

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.

DatabaseGroup ReplicationHigh Availability

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.

MySQLPerformance DiagnosisSemi-synchronous replication

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.

Database PerformanceMySQLSemi-synchronous replication

0 likes · 8 min read

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