This title may be suitable for the new age MySQL Users. Because
in 5.7 onwards its already supported to enable GTID online. But
still few of my mission critical databases are in 5.6 and
handling 70k QPS
. So I know enabling GTID needs
downtime for this. But in my case, the GTID has been already
implemented. But still the replication is using Binlog file name
and position for replicating the data.
This is my slave status. You can see the GTID has been enabled
but the Auto_Position
is still 0 which means still
my replication is binlog filename and position. No issues with
the replication. But the MySQL world already moved to GTID for
better control on replication and Failover.
Master_Server_Id: 10010
Master_UUID: c924545b-a3e3-11e8-8a39-42010a280410
Master_Info_File: mysql.slave_master_info
SQL_Delay: 0
SQL_Remaining_Delay: NULL …
[Read more]