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 SLAVEB.STOP SLAVE; BEGIN; SET GTID_IGNORE=aaa-bbb-ccc-ddd-eee: 3; COMMIT; START SLAVEC.STOP SLAVE; SETGTID_NEXT=aaa-bbb-ccc-ddd-eee: 3; BEGIN; COMMIT; SET GTID_NEXT=AUTOMATIC; START SLAVED.STOP SLAVE; RESET SLAVE; BEGIN; SKIP NEXT GTID; COMMIT; START SLAVE
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
相关考题:
May I take this book out of the reading room? No,you . You read it in here. ( )A. mightn’tB. won’tC. need’tD. mustn’t
”You ____ have a wrong number,” she said. “There’s no one of that name here.”A. needB. canC. mustD. would
7. If I _______ you,l_______ take an umbrella with me.A. was ; shouldB. was ; wouldC. were ; willD. were ; would
"You _________ finish your homework before the dinner." said mother. A.shouldB.have toC.mustD.would
– David, you've been losing your temper over nothing lately.– ( ).A. I haven’t been getting much sleep eitherB. You’d better not push yourself too hard, or you’ll get sickC. I’m sorry. I shouldn’t have blown up like thatD. You’d better do exercises regularly
“You ____ have a wrong number,” she said. “There’s no one of that name here.”A. needB. canC. mustD. would
你最好控制一下上网聊天的时间。(汉译英)A.You'd better set a limit for your online chat time.B.You'd better set a limit on your online chat time.C.You'd better set a limit on your online chatting time.D.You'd better set a limit for your online chatting time.