Changes between Version 10 and Version 11 of GROUPReplicate3

Timestamp:

07/18/22 00:41:24 (3 years ago)

Author:

krit

Comment:

--

GROUPReplicate3

@@ -39 +39 @@
        SELECT * FROM performance_schema.replication_group_members;
 }}}
+On nodedb1, we need to set the group_replication_bootstrap_group variable tells a member that it shouldn’t expect to receive information from peers and should instead establish a new group and elect itself the primary member. You can turn this variable on with the following command:
+{{{
+    SET GLOBAL group_replication_bootstrap_group=ON;
+}}}
+Then you can start replication for the initial group member:
+{{{
+    START GROUP_REPLICATION;
+}}}
+Following that, you can set the group_replication_bootstrap_group variable back to OFF, since the only situation where this is appropriate is when there are no existing group members:
+{{{
+    SET GLOBAL group_replication_bootstrap_group=OFF;
+}}}
+The group will be started with this server as the only member. Verify this by checking the entries within the replication_group_members table in the performance_schema database:
+{{{
+    SELECT * FROM performance_schema.replication_group_members;
+}}}