问题描述:
[单选]
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;
参考答案:查看无
答案解析:无
☆收藏
答案解析:无
☆收藏
上一篇:User A issues the command( )用户A发出命令( )mysql>LOCK TABLES pets READ;Which command can User B execute against the pets table?用户B可以对pets表执行哪个命令?
下一篇:Which two statements are true regarding partitioning in MySQL?关于MySQL中的分区,哪两种说法是正确的?()
- 我要回答: 网友(216.73.216.168)
- 热门题目: 1.以下4种不合理费用的计算公式 2.以下哪些不是监制章的特点?( 3.监制章具有以下哪些特点:()
