Tag

slave_io_thread

1 views collected around this technical thread.

Aikesheng Open Source Community

Jun 30, 2022 · Databases

Handling Replication Anomalies in MySQL Slave IO Thread

This article analyzes MySQL replication anomalies caused by master failures or network interruptions that lead to incomplete transaction replay on slaves, demonstrates a reproducible experiment using network delay and iptables, and provides practical guidance for both recovering and permanently handling stalled slave IO threads.

DatabaseGTIDMySQL

0 likes · 6 min read

Handling Replication Anomalies in MySQL Slave IO Thread

Aikesheng Open Source Community

Dec 30, 2018 · Databases

Root Cause Analysis of Slave IO Thread Hang in MySQL Semi‑Sync Replication with Multiple Slaves

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.

MySQLPerformanceReplication

0 likes · 8 min read

Root Cause Analysis of Slave IO Thread Hang in MySQL Semi‑Sync Replication with Multiple Slaves