当前位置: 答题翼 > 问答 > 计算机类考试 > 正文
目录: 标题| 题干| 答案| 搜索| 相关
问题

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

参考答案
您可能感兴趣的试题
  • You are calling another vessel by radiotelephone using the International Code of Signals.H

  • Horses are used in guarding herbs, carrying men in lands where there are no roads, and hel

  • ● The screen saver you are using is (71) protected. (71)A. disk B. password C. comput

  • The author uses " You are the salt of the earth" in the first paragraph to imply that_____

  • You are to write in 100-120 words about the title "Is It Useful to Go to University Nowl"

  • There are a large number of reference books ______ to you; you can make use of them at any