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; 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;



Leave a Reply 2

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