Tencent Database Technology
May 15, 2018 · Databases
Improving MySQL Asynchronous Replication by Aligning Read_Master_Log_Pos with Exec_Master_Log_Pos
This article analyzes a MySQL master‑crash scenario where mismatched Read_Master_Log_Pos and Exec_Master_Log_Pos prevent HA failover, explains binlog event structures, and proposes updating Read_Master_Log_Pos only after a full transaction is received to ensure reliable asynchronous replication.
BinlogExec_Master_Log_PosHA
0 likes · 9 min read