You are using CTIDS in replication. You need to skip a transaction with the CTID of aaa-bbb-ccc-ddd-eee : 3 on a slave.
Which command would you execute from a Mysql prompt?
A. STOP SLAVE;
SETGTID_NEXT="aaa-bbb-ccc-ddd-eee: 3";
BEGIN;
COMMIT;
SET GTID_NEXT="AUTOMATIC";
START SLAVE
B. STOP SLAVE;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
START SLAVE;
C. STOP SLAVE;
BEGIN;
SET GTID_IGNORE="aaa-bbb-ccc-ddd-eee: 3";
COMMIT;
START SLAVE;
D. STOP SLAVE;
RESET SLAVE;
BEGIN;
SKIP NEXT GTID;
COMMIT;
START SLAVE;
|
Download Printable PDF. VALID exam to help you PASS. |
 |