MySQL Forums
Forum List  »  Replication

Create Group Script
Posted by: Ricardo Parra
Date: December 07, 2017 04:23AM


I have some doubts about the process of creating a group for Group Replication. In MySQL FAQ we have this:

"What is the group_replication_bootstrap_group option used for?
The bootstrap flag instructs a member to create a group and act as the initial seed server. The second member joining the group needs to ask the member that bootstrapped the group to dynamically change the configuration in order for it to be added to the group.
A member needs to bootstrap the group in two scenarios. When the group is originally created, or when shutting down and restarting the entire group."

So to start a Group we need to:
SET GLOBAL group_replication_bootstrap_group=ON;
SET GLOBAL group_replication_bootstrap_group=OFF;

After this the other servers only need to join:

But is there a way to automate the process of checking if there is any active group, otherwise creating one (in settings or by script)? I want to deploy this to two servers without human interference.

Thank You,

Options: ReplyQuote

Written By
Create Group Script
December 07, 2017 04:23AM
January 05, 2018 03:05AM

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.