For resolving the problems follow below steps:
1.       Stop & Reset slave
mysql> stop slave;
mysql> reset slave;
2.       Change log position & master log file name
mysql> CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.0000xx', MASTER_LOG_POS=xxxx;
3.       Start slave
mysql> start slave;
4.       Check slave status
mysql> show slave status\G;
Output include below output:
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
No comments:
Post a Comment