Which command would you execute from a Mysql prompt?

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?

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/



Leave a Reply 5

Your email address will not be published. Required fields are marked *


Steve

Steve

I am wondering if the use of CTID and not GTID is meant to make it a trick question where B would be correct.

Jose Wilson

Jose Wilson

The answer is A

I search for CTID, but not find any item. When invez of CTID right is GTID.

AJ

AJ

The answer would be B as here CTIDs(Classic) replication is getting used not Transaction based.