master-slave情况下，将slave追平到master状态

最新推荐文章于 2021-11-03 11:23:40 发布

原创最新推荐文章于 2021-11-03 11:23:40 发布 · 243 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #master-slave

MySQL 专栏收录该内容

38 篇文章

订阅专栏

本文介绍了如何在 master 主机故障后，使用 STOP SLAVE, CHANGE MASTER TO MASTER_DELAY=0, START SLAVE 这一命令序列，使 slave 奴隶机从已有的 relay log 文件（hostname-relay-bin.00004）中追赶最新的数据，确保数据一致性。

背景：

An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest dats.

The SHOW SLAVE STATUS indicates these values:

* RELAY_LOG_FILE=hostname-relay-bin.00004

* RELAY_LOG_POS=1383

Which command set would make the slave current?

干货：STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;

===========End，=============