can you test when master/slave Switching occurs,and i found when SELECT @@global.gtid_executed; have not only one record like :
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)
when i use --history ,it can not insert record,but when table no exist,it will create. and i see the binlog have not some insert record.
if i reset the gtid_executed when i have only one records like:
SELECT @@global.gtid_executed;
+---------------------------------------------------------------------------------------------------+
| @@global.gtid_executed |
+---------------------------------------------------------------------------------------------------+
| 12361081-90f4-11e6-8413-0050569293fc:1-234 |
+---------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
it can insert the records.
i try to use 2.3.7,2.3.8 version and the results is the same.
xtrabackup have not --history, is it have any other way can insert the backup record into database?
can you test when master/slave Switching occurs,and i found when SELECT @@global. gtid_executed; have not only one record like : 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)
when i use --history ,it can not insert record,but when table no exist,it will create. and i see the binlog have not some insert record.
if i reset the gtid_executed when i have only one records like: gtid_executed; ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- --+ gtid_executed | ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- --+ 90f4-11e6- 8413-0050569293 fc:1-234 | ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- --+
SELECT @@global.
+------
| @@global.
+------
| 12361081-
+------
1 row in set (0.00 sec)
it can insert the records.
i try to use 2.3.7,2.3.8 version and the results is the same.
xtrabackup have not --history, is it have any other way can insert the backup record into database?