Which statement should be used?

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?

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?

A.
SET GTID_NEXT=”CONSISTENCY”; BEGIN; COMMIT; SET GTID_NEXT=”
AUTOMATIC’;

B.
SET GLOBAL enforce_gtid_consistency=ON

C.
SET GTID_EXECUTED=”38f32e23480a7-32a1-c323f78067fd37821 : 9”;

D.
SET GTID_NEXT=”38f32e23480a7-32a1-c323f78067fd37821 : 9”; BEGIN; COMMIT;
SET GTID_NEXT=”AUTOMATIC”;

E.
SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1



Leave a Reply 3

Your email address will not be published. Required fields are marked *


igbinigun

igbinigun

Using A simple master-to-slave replication not Gtid replication

I believe E will be the right answer

omid

omid

The right answer is D
Becouse in the error text we find:

Retrieved _Gtid_Set: 38f32e23480a7-32a1-c323f78067fd37821: 1-8

It means that MYSQL is using GTID REPLICATION (not SIMPLE REPLICATION).