How to re-sync the Mysql DB if Master and slave ha

2019-01-09 20:43发布

Mysql Server1 is running as MASTER.
Mysql Server2 is running as SLAVE.

Now DB replication is happening from MASTER to SLAVE.

Server2 is removed from network and re-connect it back after 1 day. After this there is mismatch in database in master and slave.

How to re-sync the DB again as after restoring DB taken from Master to Slave also doesn't solve the problem ?

13条回答
ら.Afraid
2楼-- · 2019-01-09 21:29

Following up on David's answer...

Using SHOW SLAVE STATUS\G will give human-readable output.

查看更多
登录 后发表回答