BestHub
search
Sign in
Tag

Slave Crash

0 views collected around this technical thread.

Tencent Architect
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
Analysis of Inconsistencies in MySQL Slave Crash Recovery and Sync Master/Relay Log Info
Tencent Database Technology
Tencent Database Technology
Apr 7, 2021 · Databases

Analysis of Inconsistencies in MySQL Replication after Slave Crash and Configuration Recommendations

This article examines how slave crashes in MySQL replication can cause inconsistencies between master info and relay log positions, leading to duplicate events and errors such as 1062 and 1032, analyzes underlying mechanisms, presents case studies, and proposes configuration settings to achieve server‑crash‑safe replication.

Database ConfigurationMaster InfoRelay Log
0 likes · 17 min read
Analysis of Inconsistencies in MySQL Replication after Slave Crash and Configuration Recommendations