Changes between Version 11 and Version 12 of GROUPReplicate3

Timestamp:

07/18/22 00:42:42 (2 years ago)

Author:

krit

Comment:

--

GROUPReplicate3

@@ -41 +41 @@
 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;
+mysql> SET GLOBAL group_replication_bootstrap_group=ON;
 }}}
 Then you can start replication for the initial group member:
 {{{
-    START GROUP_REPLICATION;
+mysql> 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;
+mysql> 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;
+mysql> SELECT * FROM performance_schema.replication_group_members;
 }}}