Gtid_mode must be set to AUTO during point in time recoveries
Mysqlbinlog ignores arguments to – exclude-gtids-it means ignore all events with GTIDs
The server keeps track of which GTIDs have already been executed and skips those
Enforce_gtid_consistency is set to ON
第1题:
A.Both technologies guarantee an identical copy of data on the secondary node
B.Only MySQL can maintain a time-delayed copy of data on the secondary node
C.Both technologies use the TCP/IP stack as their primary transmission medium
D.DRBD uses shared-disk technology
第2题:
A.STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE
B.STOP SLAVE; BEGIN; SET GTID_IGNORE="aaa-bbb-ccc-ddd-eee: 3"; COMMIT; START SLAVE
C.STOP SLAVE; SETGTID_NEXT="aaa-bbb-ccc-ddd-eee: 3"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"; START SLAVE
D.STOP SLAVE; RESET SLAVE; BEGIN; SKIP NEXT GTID; COMMIT; START SLAVE
第3题:
A.Each extra column in the copy with more columns must not have a default value
B.Columns that are common to both versions of the table must be defined in the same order on the master and the slave
C.The slave database cannot have more columns than the master. Only the master database can have more columns
D.Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server
E.The master database cannot have more columns than the slave. Only the slave deatbase can have more columns
第4题:
第5题:
A.SET GTID_NEXT="CONSISTENCY"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"
B.SET GLOBAL enforce_gtid_consistency=ON
C.SET GTID_EXECUTED="38f32e23480a7-32a1-c323f78067fd37821 : 9"
D.SET GTID_NEXT="38f32e23480a7-32a1-c323f78067fd37821 : 9"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"
E.SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1
第6题:
A.The master.info and relay.info files
B.The relay log files
C.The relay index file
D.Mysql.slave_master_info table
E.Mysql.slave_relay_log_info table
F.Mysql.slave_worker_info table
第7题:
ROW-based replication has stopped working. You investigate the error log file and find the following entries: 2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1;Can‘t find record in ‘t1‘, Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event‘s master log 56_master-bin. 000003, end_log_pos 851, Error_code: 10322013-08-27 14:15:47 9056 [warning] Slave: Can‘t find record in ‘t1‘ Error_code: 10322013-08-27 14:15:47 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START".We stopped at log ‘56_masterbin. 000003‘ position 684 Why did you receive this error?()
A.The slave SQL thread does not have DELETE privileges to execute on test.t1 table.s
B.The table definition on the slave -litters from the master
C.Multi-threaded replication slaves can have temporary errors occurring for cross database updates
D.The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist
第8题:
A MySQL replication slave is set up as follows: User all InnoDB tablesReceives ROW-based binary logs Has the read-only optionThe replication slave has been found in an error state.You check the MySQL error log file and find the following entries:2013-08-27 13:55:44 9056 [ERROR] Slave SQL: Could not execute Write_rows event on table test.tl; Duplicate entry ‘3’ for key’PRIMARY’ , Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event’s master log 56_master-bin.000003, end_log_pas 653, Error_code: 10622013-08-27 13:55:44 9056 [Warning] Salve: Duplicate entry ‘3’ for key ‘PRIMARY’Error_code: 10622013-08-27 13:55:44 9056 [ERROR] Error running query, slave SQL thread aborted. Fix theproblem, and restart the slave SQL thread with SLAVE START”, We stopped at log ‘56_masterbin.000003’ position 496 What are two possible causes for this error to occur?()
A.The slave was created with mysqldump –u root –p – skip-lock-table—all-databases > /data/data.sql
B.The slave user does have INSERT, UPDATE, or DELETE permission and cannot execute the write_rows function
C.For tables with UNIQUE keys, statement-based replication must be used maintain integrity
D.The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite
E.The applications have the SUPER privilege, which allows them to update rows
第9题:
试题(71)~(75)
A Bluetooth device can be either a master or a slave and any of the devices within a (71)can be the master. There is only one master and there can be up to (72) active slave devices at a time within a single network. In addition, a device may be a standby slave or a parked slave. There can be up to (73) parked slaves. If there are already maximum number of active slaves, then a parked slave must wait until one of the active slaves switches to (74) mode before it can become active. Within a network, all (75) communications are prohibited.
(71)
A. Wireless LAN
B. Wireless MAN
C. Cellular radio network
D. Piconet
(72)
A. 7
B. 15
C. 63
D. 255
(73)
A. 127
B. 255
C. 511
D. 1023
(74)
A. master
B. standby slave
C. parked slave
D. active slave
(75)
A. master-to-master
B. master-to-slave
C. slave-to-slave
D. slave-to-master
第10题: