dbaplus Community

Jul 18, 2017 · Databases

Why MySQL Relay Logs Lost Thousands of Rows: A Real‑World Investigation

A senior MySQL engineer recounts a puzzling case where a custom script flushing relay logs caused the first transaction in each relay log to be skipped, leading to daily loss of nearly ten thousand rows in a rapidly growing production environment.