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