ITPUB

Jul 11, 2016 · Databases

Why Does MySQL Replication Throw ER_MASTER_HAS_PURGED_REQUIRED_GTIDS and How to Fix It?

In a MySQL 5.7 GTID setup with dual masters, a network glitch caused the slave to switch masters, leading to the ER_MASTER_HAS_PURGED_REQUIRED_GTIDS error because the new master had purged GTIDs the slave still needed, and the article explains the root cause and step‑by‑step fix.