MySQL 5.6 Database Administrator-001-Which statement should be used?
royalwzy发表于 2015-09-01 22:54:05
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 GLOBAL SQL_SKIP_SLAVE_COUNTER=1
B.
SET GTID_NEXT=”CONSISTENCY”;
BEGIN; COMMIT;
SET GTID_NEXT=” AUTOMATIC’;
C.
SET GLOBAL enforce_gtid_consistency=ON
D.
SET GTID_EXECUTED=”38f32e23480a7-32a1-c323f78067fd37821 : 9”;
E.
SET GTID_NEXT=”38f32e23480a7-32a1-c323f78067fd37821 : 9”;
BEGIN; COMMIT;
SET GTID_NEXT=”AUTOMATIC”;
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 GLOBAL SQL_SKIP_SLAVE_COUNTER=1
B.
SET GTID_NEXT=”CONSISTENCY”;
BEGIN; COMMIT;
SET GTID_NEXT=” AUTOMATIC’;
C.
SET GLOBAL enforce_gtid_consistency=ON
D.
SET GTID_EXECUTED=”38f32e23480a7-32a1-c323f78067fd37821 : 9”;
E.
SET GTID_NEXT=”38f32e23480a7-32a1-c323f78067fd37821 : 9”;
BEGIN; COMMIT;
SET GTID_NEXT=”AUTOMATIC”;