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:http://www.cndba.cn/hbhe0316/article/22797http://www.cndba.cn/hbhe0316/article/22797http://www.cndba.cn/hbhe0316/article/22797http://www.cndba.cn/hbhe0316/article/22797http://www.cndba.cn/hbhe0316/article/22797http://www.cndba.cn/hbhe0316/article/22797http://www.cndba.cn/hbhe0316/article/22797http://www.cndba.cn/hbhe0316/article/22797http://www.cndba.cn/hbhe0316/article/22797

• RELAY_LOG_FILE=hostname-relay-bin.00004
• RELAY_LOG_POS=1383
  Which command set would make the slave current?
  A. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; RELAY_LOG_FILE ‘hostname-relay-bin.00004’, RELAY_LOG_POS = 1383;
  B. STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = ‘hostname-relay-bin.00004’,RELAY_LOG_POS = 1383;
  C. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;
  D. STOP SLAVE; SET GLOBAL master_delay=0; START SLAVE;
  Answer: C
  从库使用了延迟复制，延迟的时长为1小时。此时主库崩溃，从库需要进行前滚来应用最新的数据。SHOW SLAVE STATUS中的输出为：
• RELAY_LOG_FILE=hostname-relay-bin.00004
• RELAY_LOG_POS=1383
  下面哪一组命令能够实现此需求？
  C. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;

版权声明：本文为博主原创文章，未经博主允许不得转载。

MYSQL