Mysql 8 group replication sync problem
I have mySQL 8.0.16 with a Innodb cluster configured with 3 servers.
I backed up a DB with mysql dump, removed the database and created a new database, and tried reimported the database again from sql file on to the R/W master instance.
The first time I tried I got this error:
ERROR 13176 (HY000) at line 24: Cannot update GTID_PURGED with the Group Replication plugin running
So the DB was created but no tables imported.
I tried again using the mysql 'source filename' command and got this error:
"ERROR 3546 (HY000): @@GLOBAL.GTID_PURGED cannot be changed: the added gtid set must not overlap with @@GLOBAL.GTID_EXECUTED
So it seems not possible to restore the databases using normal mysqldump, and mysql command method.
One of the R/O instances is now out of sync, it still shows the empty database in the list and I cannot seem to force the instance to sync with the master properly. I played about with 'reset master' and gtid_purged variables with no look.
Is there any good instructions on getting replication working again in innodb group replication? Or would it be best to rebuild mysql again on the mysql instance to fix it?
Subject
Views
Written By
Posted
Mysql 8 group replication sync problem
11806
June 19, 2019 04:55AM
3071
June 21, 2019 02:08AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.