tl;dr version: what's the correct process for adding a new node to an existing MySQL Group Replication cluster? (scale-out)
Longer version: got a three node MGR 8.0.13 multi-primary cluster here and one node had a disk crash. Got a replacement disk, but had to start from scratch with that node. I'd assumed that doing a restore of a mysqldump backup (made with --set-gtid-purged=OFF) would've bootstrapped the server enough to switch on GROUP_REPLICATION to pull it the rest of the way, getting the post-backup data from the other two nodes in the cluster.
Attempting to restore gives a stream of errors about duplicate primary keys in the user databases before eventually crashing.
Is there a FAQ I'm missing because I'd have thought scale-out was a pretty normal requirement?
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.