当前位置: 代码迷 >> 综合 >> master-slave情况下,将slave追平到master状态
  详细解决方案

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

热度:87   发布时间:2024-01-15 05:46:44.0

 

背景:

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,=============

  相关解决方案