Changes between Version 16 and Version 17 of GROUPReplicate3

Timestamp:

11/28/22 08:16:34 (2 years ago)

Author:

krit

Comment:

--

GROUPReplicate3

@@ -113 +113 @@
     --group-replication-group-name='aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee' \
     --group-replication-local-address="192.168.81.36:33061" \
-    --group-replication-group-seeds='192.168.81.36:33061,192.168.81.11:33061,192.168.81.10:33061' \
+    --group-replication-group-seeds='192.168.81.36:33061,192.168.81.11:33061,192.168.81.10:33061,192.168.81.12:33061' \
     --loose-group-replication-single-primary-mode='OFF' \
     --loose-group-replication-enforce-update-everywhere-checks='ON'
@@ -124 +124 @@
        SET @@GLOBAL.group_replication_group_name='aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee';
        SET @@GLOBAL.group_replication_local_address='192.168.81.36:33061';
-       SET @@GLOBAL.group_replication_group_seeds='192.168.81.36:33061,192.168.81.11:33061,192.168.81.10:33061';
+       SET @@GLOBAL.group_replication_group_seeds='192.168.81.36:33061,192.168.81.11:33061,192.168.81.10:33061,192.168.81.12:33061';
        SET @@GLOBAL.group_replication_bootstrap_group=1;
        change master to master_user='repl' for channel 'group_replication_recovery';
@@ -136 +136 @@
 mysql>  SET @@GLOBAL.group_replication_group_name='aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee';
         SET @@GLOBAL.group_replication_local_address="192.168.81.11:33061";
-        SET @@GLOBAL.group_replication_group_seeds="192.168.81.36:33061,192.168.81.11:33061,192.168.81.10:33061";
+        SET @@GLOBAL.group_replication_group_seeds="192.168.81.36:33061,192.168.81.11:33061,192.168.81.10:33061,192.168.81.12:33061";
         SET @@GLOBAL.group_replication_bootstrap_group=0;
         SET @@global.group_replication_recovery_retry_count=5;
@@ -148 +148 @@
 mysql>  SET @@GLOBAL.group_replication_group_name='aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee';
         SET @@GLOBAL.group_replication_local_address="192.168.81.10:33061";
-        SET @@GLOBAL.group_replication_group_seeds="192.168.81.36:33061,192.168.81.11:33061,192.168.81.10:33061";
+        SET @@GLOBAL.group_replication_group_seeds="192.168.81.36:33061,192.168.81.11:33061,192.168.81.10:33061,192.168.81.12:33061";
         SET @@GLOBAL.group_replication_bootstrap_group=0;
         SET @@global.group_replication_recovery_retry_count=5;
@@ -155 +155 @@
         SELECT * FROM performance_schema.replication_group_members;
 }}}
+
+On nodedb3 192.168.81.12, use mysql cmd to do
+{{{
+mysql>  SET @@GLOBAL.group_replication_group_name='aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee';
+        SET @@GLOBAL.group_replication_local_address="192.168.81.12:33061";
+        SET @@GLOBAL.group_replication_group_seeds="192.168.81.36:33061,192.168.81.11:33061,192.168.81.10:33061,192.168.81.12:33061";
+        SET @@GLOBAL.group_replication_bootstrap_group=0;
+        SET @@global.group_replication_recovery_retry_count=5;
+        change master to master_user='repl' for channel 'group_replication_recovery';
+        START GROUP_REPLICATION;
+        SELECT * FROM performance_schema.replication_group_members;
+}}}