ITPUB

Oct 23, 2022 · Databases

Why Your Read Returns Stale Data After a Write in MySQL Replication and How to Fix It

After a write to the MySQL master, reads from a slave can return old or missing data due to replication lag, and this article explains the underlying asynchronous replication mechanisms, the involved threads, and presents practical solutions such as forcing master reads, delay detection, semi‑sync mode, GTID waiting, and middleware implementations like Sharding‑JDBC, MyCat, and MaxScale.