You are using CTIDS in replication. You need to skip a transaction with the CTID of aaa-bbb-cccddd-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;
Explanation:
Reference: http://blog.secaserver.com/2011/11/resync-mysql-masterslave-replication/
The answer is A
http://dev.mysql.com/doc/refman/5.6/en/replication-gtids-failover.html#replication-gtids-failover-empty
I am wondering if the use of CTID and not GTID is meant to make it a trick question where B would be correct.
The answer is A
I search for CTID, but not find any item. When invez of CTID right is GTID.
A
The answer would be B as here CTIDs(Classic) replication is getting used not Transaction based.