Replicating Master-slave on mysql using gtid in mysql-5.6

211 views Asked by At

When replicating MySQL Master-Slave using GTID, is it necessary to set the binlog and relay_log on the slave since GTID does not depend on the binlog-file and binlog_position, and instead uses auto_position?

1

There are 1 answers

0
Aman Aggarwal On BEST ANSWER

In GTID based replication binlog file and position is not needed to start the slave, but files are needed.

The process of reading binlog file and replicating commands into relay log at slave is same so that slave mysqld process can write to its own data set.