在使用GTIDS的复制中,若需要在从服务器上跳过GTID为aaa-bbb-cccddd-eee:3 的事务。可以执行下列哪个命令( )
(A)STOP SLAVE; SET GTID_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;
参考答案
继续答题:下一题

