MySQL Forums
Forum List  »  InnoDB clusters

MySQL Group Replication 8.0 - how to rebuild a node?
Posted by: Robert Cross
Date: April 01, 2019 08:35AM

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?

Options: ReplyQuote

Written By
MySQL Group Replication 8.0 - how to rebuild a node?
April 01, 2019 08:35AM

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.