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 STATUS indicates the following values: RELAY_LOG_FILE =
hostname-relay-bin.00004 RELAY_LOG_POS = 1383 Which command set would make the
slave current?
A.
Gtid_mode must be set to AUTO during point in time recoveries.
B.
Mysqlbinlog ignores arguments to – exclude-gtids-it means ignore all events with GTIDs.
C.
The server keeps track of which GTIDs have already been executed and skips those.
D.
Enforce_gtid_consistency is set to ON.
C
c