Changes between Version 12 and Version 13 of GROUPReplicate3

Timestamp:

07/25/22 15:29:07 (2 years ago)

Author:

krit

Comment:

--

GROUPReplicate3

@@ -86 +86 @@
 mysql> FLUSH PRIVILEGES;
 }}}
+
+------------------------------------------------------------------------------------------
+== Multiple hosts on Docker Container ==
+
+At nodedb1 192.168.81.36 file start.sh
+{{{
+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 \
+    -e MYSQL_ROOT_PASSWORD=mypass   mysql/mysql-server:8.0.11 \
+    --server-id=$node  \
+    --bind-address="0.0.0.0" \
+    --report_host="192.168.81.36"  \
+    --loose-group_replication_local_address="192.168.81.36:33061" \
+    --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="192.168.81.36:33061" \
+    --group-replication-group-seeds='192.168.81.36:33061,192.168.81.11:33061,192.168.81.10:33061' \
+    --loose-group-replication-single-primary-mode='OFF' \
+    --loose-group-replication-enforce-update-everywhere-checks='ON'
+}}}