可学答题网 > 问答 > 1z0-883题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

A simple master-to-slave replication


A simple master-to-slave replication is currently being used. The following information is extracted from the SHOW SLAVE STATUS output: Last_SQL_Error: Error 'Duplicate entry '8' for key 'PRIMARY' ' on query. Default database: 'mydb'. Query: 'insert into mytable VALUES ('8' , 'George') ' Skip_Counter: 0 Retrieved _Gtid_Set: 38f32e23480a7-32a1-c323f78067fd37821: 1-8 Auto _Position: 1 You execute a "SHOW CREATE TABLE mytable" on the slave: CREATE TABLE 'mytable' ( 'ID' int(11) NOT NULL DEFAULT '0', 'name' char(10) DEFAULT NULL, PRIMARY KEY ('ID') ) The table mytable on the slave contains the following: You have issued a STOP SLAVE command. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used?()

  • ASET GTID_NEXT="CONSISTENCY"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"
  • BSET GLOBAL enforce_gtid_consistency=ON
  • CSET GTID_EXECUTED="38f32e23480a7-32a1-c323f78067fd37821 : 9"
  • DSET GTID_NEXT="38f32e23480a7-32a1-c323f78067fd37821 : 9"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"
  • ESET GLOBAL SQL_SKIP_SLAVE_COUNTER=1
参考答案
参考解析:
分类:1z0-883题库
相关推荐

1、autonomous replicating sequence (ARS 序

autonomous replicating sequence (ARS 序列)

2、复制型转座(Replicative transposon)

复制型转座(Replicative transposon)

3、In a simple series circuit, the entire

In a simple series circuit, the entire source voltage will drop across ()Athe resistor next to the negative terminalBa short circuitCthe resistor next to the positive terminalDan open circuit

4、半保留复制(Semi-conservative replication)

半保留复制(Semi-conservative replication)

5、When backing up a replication slave, w

When backing up a replication slave, which three should also be backed up in addition to data?()AThe master.info and relay.info filesBThe rela...

6、In a simple mechanical governor, the (

In a simple mechanical governor, the ().Acentrifugal force rotates the ball-headBflyweight centrifugal force is balanced by spring forceCflyweight centrifugal force is balanced by hydraulic pressureDspeeder spring alone actuates the fuel control rod