thank you for support me. I means is if "SELECT @@global.gtid_executed;" have not only one values,it like this have the other server_uuid after switch,it can not insert the records with --history
SELECT @@global.gtid_executed;
+---------------------------------------------------------------------------------------------------+
| @@global.gtid_executed |
+---------------------------------------------------------------------------------------------------+
| 12361081-90f4-11e6-8413-0050569293fc:1-286495163,
59eaee0c-9289-11e5-8911-005056923a57:1-40235250 |
+---------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
12361081-90f4-11e6-8413-0050569293fc is master,59eaee0c-9289-11e5-8911-005056923a57 is slave.
thank you for support me. I means is if "SELECT @@global. gtid_executed; " have not only one values,it like this have the other server_uuid after switch,it can not insert the records with --history gtid_executed; ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- --+ gtid_executed | ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- --+ 90f4-11e6- 8413-0050569293 fc:1-286495163, 9289-11e5- 8911-005056923a 57:1-40235250 | ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- --+
SELECT @@global.
+------
| @@global.
+------
| 12361081-
59eaee0c-
+------
1 row in set (0.00 sec)
12361081- 90f4-11e6- 8413-0050569293 fc is master, 59eaee0c- 9289-11e5- 8911-005056923a 57 is slave.