Tencent Architect
Apr 9, 2021 · Databases
Analysis of Inconsistencies in MySQL Slave Crash Recovery and Sync Master/Relay Log Info
This article analyzes how MySQL slave crashes can cause inconsistencies between master info and relay log positions during sync_master_info and sync_relay_log_info processes, presents case studies of duplicated events, explains the impact of different storage repositories (FILE vs TABLE), and recommends configuration settings to achieve server‑crash‑safe replication.
Relay LogReplicationSlave Crash
0 likes · 15 min read