单项选择题
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
相关考题
-
单项选择题
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.STOP SLAVE; CHANGE MASTER TO MASTER_DELAY =0, RELAY_LOG_FILE = 'hostnamerelay- 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 -
多项选择题
What are three methods to reduce Mysql server exposure to remote connections?（）
A.Setting — skip-networking when remote connections are not required
B.Using the sql_mode=STRICT_SECURE after connections are established for encrypted communications
C.Setting specific GRANT privilege to limit remote authentication
D.Setting – mysql_secure_configuration to enable paranoid mode
E.Using SSL when transporting data over remote networks -
单项选择题
Following a server crash, the automatic recovery of InnoDB fails. How would you begin to manually repair the InnoDB tables?（）
A.Start the server with the – innodb_recover_options option set to FORCE
B.Start the server with the – innodb_force_recovery option set to a non-zero value
C.Start the server as usual, and then execute the REPAIR TABLE command
D.Start the server as usual, and then execute the CHECK TABLE command
