0 views collected around this technical thread.
This tutorial walks through preparing the Linux environment, installing MySQL 5.7, configuring master and slave servers, creating replication users, verifying synchronization, troubleshooting common issues, and applying advanced options such as GTID and semi‑synchronous replication, all with complete command examples.
This article presents a detailed experiment comparing graceful and kill‑9 shutdown methods on a MySQL 5.7 semi‑synchronous master‑slave cluster, analyzes their impact on data consistency, and outlines the official shutdown sequence with practical observations and recommendations for production environments.
The article investigates a MySQL 8.0.18 crash that occurs when importing a large create.sql containing longblob data under semi‑synchronous replication, reveals that enabling slave_compressed_protocol together with high‑availability latency checks triggers the failure, and provides a concrete fix by disabling the compressed protocol.
When using MySQL 5.7 with rpl_semi_sync_master_wait_for_slave_count=1, starting a second semi‑sync replica often causes the slave_io_thread to stall because the master cannot launch the corresponding dump thread, a bug that was later fixed in MySQL 5.7.23.