当前位置:百科知识 > 知到宏观经济学答案

问题描述:

[单选] You are using GTIDS in replication. You need to skip a transaction with the GTID of aaa-bbb-cccddd-eee : 3 on a slave.您正在复制中使用gtid。您需要跳过从机上GTID为aaa bbb cccddd eee:3的事务。Which command would you execute from a MySQL prompt?从MySQL提示符执行哪个命令?
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;
参考答案:查看
答案解析:
☆收藏

随机题目