Sep 8, 2016 · Databases

Why Does CHANGE MASTER Trigger Traffic Spikes in MySQL GTID Replication?

After switching a MySQL master’s IP, the author observed unusually high traffic between master and slave, investigated the role of GTID, semi‑sync and the CHANGE MASTER command, and demonstrated that executing CHANGE MASTER on a lagging replica can clear the relay‑log and cause a temporary traffic surge as the missing binlog entries are re‑fetched.

Change MasterGTIDRelay Log

0 likes · 7 min read

Why Does CHANGE MASTER Trigger Traffic Spikes in MySQL GTID Replication?

ITPUB

May 9, 2016 · Databases

Why Does CHANGE MASTER Trigger Traffic Spikes in MySQL GTID Replication?

After switching a MySQL master’s IP, the author observed extreme master‑to‑slave traffic and investigated whether using CHANGE MASTER with auto_position=1 forces the replica to re‑fetch already executed binlogs, especially when the replica is lagging.

Change MasterGTIDRelay Log

0 likes · 7 min read