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

 

背景：

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