Changes between Version 5 and Version 6 of GROUPReplicate3

Timestamp:

07/16/22 14:07:00 (3 years ago)

Author:

krit

Comment:

--

GROUPReplicate3

@@ -2 +2 @@
 All node can write (primary)
 
+On nodedb1, just start docker with, pls download mysql-8.0.11 source 
+{{{
+docker run -d --name=nodedb1 --net=group1 --hostname=nodedb1 -p 3306:3306 \
+    -v $PWD/mysql-8.0.11/d1:/var/lib/mysql \
+    -e MYSQL_ROOT_PASSWORD=mypass   mysql/mysql-server:8.0.11 \
+    --server-id=1  \
+    --log-bin='mysql-bin-1.log' \
+    --enforce-gtid-consistency='ON' \
+    --log-slave-updates='ON'   \
+    --gtid-mode='ON' \
+    --transaction-write-set-extraction='XXHASH64' \
+    --binlog-checksum='NONE' \
+    --master-info-repository='TABLE' \
+    --relay-log-info-repository='TABLE' \
+    --plugin-load='group_replication.so' \
+    --relay-log-recovery='ON' \
+    --group-replication-start-on-boot='OFF' \
+    --group-replication-group-name='aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee' \
+    --group-replication-local-address="nodedb1:33061" \
+    --group-replication-group-seeds='nodedb1:33061,nodedb2:33061,nodedb3:33061' \
+    --loose-group-replication-single-primary-mode='OFF' \
+    --loose-group-replication-enforce-update-everywhere-checks='ON'
+}}}
 
-On nodedb2
+
+
+On nodedb2, start docker with above but change --name=nodedb2, --hostname=nodedb2, --server-id=2, -v $PWD/mysql-8.0.11/d2:/var/lib/mysql
 {{{
 mysql> SET @@GLOBAL.group_replication_group_name='aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee';