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
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
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 …