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
答案解析:有

微信扫一扫手机做题