GTID

[root@db2 shell]# mysql -uroot -p -S /home/mysql3309/run/mysql.sock < h20170817.sql
Enter password:
ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty.

reset master ;然后就能导入了。

 

Last_Errno: 1756
Last_Error: ... The slave coordinator and worker threads are stopped, possibly leaving data in inconsistent state. A restart should restore consistency automatically, although using non-transactional storage for data or info tables or DDL queries could lead to problems. In such cases you have to examine your data (see documentation for details).
Skip_Counter: 0
Exec_Master_Log_Pos: 545890511

........

Retrieved_Gtid_Set: 8a0446c4-cce4-11e5-865d-002564fbe7a0:360785790-360788963
Executed_Gtid_Set: 8a0446c4-cce4-11e5-865d-002564fbe7a0:1-360785789,

 

# at 545890480
#170820 13:51:48 server id 44 end_log_pos 545890511 CRC32 0xb095afd4 Xid = 2141399039
COMMIT/*!*/;
# at 545890511
#170820 13:51:48 server id 44 end_log_pos 545890576 CRC32 0xcbdc1a32 GTID last_committed=672196 sequence_number=672197
SET @@SESSION.GTID_NEXT= '8a0446c4-cce4-11e5-865d-002564fbe7a0:360785790'/*!*/;
# at 545890576
#170820 13:51:46 server id 44 end_log_pos 545890828 CRC32 0xf688b38f Query thread_id=35690799 exec_time=0 error_code=0
SET TIMESTAMP=1503208306/*!*/;
XA START X'6e61726973755f31302e382e302e375f313530333230383236363132395f31',X'6e61726973755f31302e382e302e375f313530333230383236363132395f5f6272616e63685f30',1
/*!*/;
# at 545890828
#170820 13:51:46 server id 44 end_log_pos 545891279 CRC32 0xfa89e96b Rows_query
# UPDATE `XR_tttt` SET............................

 

 

mysql> stop slave;

Query OK, 0 rows affected (0.03 sec)

 

mysql> SET GTID_NEXT='8a0446c4-cce4-11e5-865d-002564fbe7a0:360785790';

Query OK, 0 rows affected (0.00 sec)

 

mysql> BEGIN;

Query OK, 0 rows affected (0.00 sec)

 

mysql> COMMIT;

Query OK, 0 rows affected (0.00 sec)

 

mysql> SET GTID_NEXT='AUTOMATIC';

Query OK, 0 rows affected (0.00 sec)

 

#########Reset master ; SET @@GLOBAL.GTID_PURGED=

[root@dbs1 data]# more xtrabackup_binlog_info
mysql-bin.000572 654418578 8a0446c4-cce4-11e5-865d-002564fbe7a0:1-360906254

Reset master ; SET @@GLOBAL.GTID_PURGED='8a0446c4-cce4-11e5-865d-002564fbe7a0:1-360906254';

CHANGE MASTER 

 

 

#########3

Retrieved_Gtid_Set: fdcddc84-931c-11e5-8cd3-00e081d184a0:1-16

Executed_Gtid_Set: fdcddc84-931c-11e5-8cd3-00e081d184a0:1-9

STOP SLAVE;

RESET MASTER;

跳过10、11、12和13  4个事务。

SET @@GLOBAL.GTID_PURGED ='fdcddc84-931c-11e5-8cd3-00e081d184a0:10-13';

START SLAVE;