Re: Replication Issues
Yes, you should run the command CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.001952',MASTER_LOG_POS=13086021; to set the correct starting position for the slave.
The slave binlogs can be different in sequence to the master binlogs, so have the slave start at 00001 and the master at 001952 is not a problem. The slave will read the binary log from the master and write it into the current relay log on the slave, again which could be a totally different number e.g. mysql-relay-log.000145
The binary logs exist on the slave since you have turned on binary logging. This will show changes made directly on the slave and/or through replication if the --log-slave-updates option is active.
I would suggest you stop the slave, do the change master command and then start slave again and see how it goes from there.
Subject
Views
Written By
Posted
2509
December 16, 2009 03:19PM
Re: Replication Issues
1476
December 29, 2009 09:59PM
1352
December 30, 2009 08:31AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.