1Z0-888 Exam Dumps | An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed

<< Prev Question Next Question >>

Question 10/44

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 data.
The SHOW SLAVE STATUSindicates these values:
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; SET GLOBAL master_delay=0; START SLAVE;

D. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;

Question 10/44

LEAVE A REPLY

Download PDF File