MySQL Forums
Forum List  »  Replication

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

Hi,

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;
START GROUP_REPLICATION;
SET GLOBAL group_replication_bootstrap_group=OFF;

After this the other servers only need to join:
START GROUP_REPLICATION;

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,
Ricardo

Options: ReplyQuote


Subject
Views
Written By
Posted
Create Group Script
611
December 07, 2017 04:23AM
342
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.