Changes between Version 13 and Version 14 of GROUPReplicate3

Timestamp:

07/25/22 15:34:42 (2 years ago)

Author:

krit

Comment:

--

GROUPReplicate3

@@ -90 +90 @@
 == Multiple hosts on Docker Container ==
 
-At nodedb1 192.168.81.36 file start.sh
+At nodedb1 192.168.81.36 file start.sh where the network share with host ( --net=host )
 {{{
 node=1
-#docker run -it --name=nodedb1 --net=group1 --hostname=nodedb1 -p 3306:3306 \
-#docker run -d --name=nodedb$node --hostname=nodedb$node --network host -p 3306:3306 -p 33061:33061 \
 docker run -d --name=nodedb$node --hostname=nodedb$node --net=host \
     -v $PWD/mysql-8.0.11/d$node:/var/lib/mysql \
@@ -119 +117 @@
     --loose-group-replication-enforce-update-everywhere-checks='ON'
 }}}
+
+
+
+On nodedb2 192.168.81.11, 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.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_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;
+}}}