Changes between Version 5 and Version 6 of GROUPReplicate

Timestamp:

06/11/22 02:39:09 (2 years ago)

Author:

krit

Comment:

--

GROUPReplicate

@@ -46 +46 @@
 }}}
 
-5. On replicate node2, node3, pls change '''node2''' to docker id ex. ac87f41b140c which can be checked with '''docker ps''' on swarm node n1, n2
+5. On replicate node2, node3, pls change '''node2''' to docker id ex. ac87f41b140c which can be checked with '''docker ps''' on swarm node n1, n2. We also do above command with node3 (replicate node)
 {{{
 root@n1:/home/ubuntu/GR# docker exec -it ac87f41b140c mysql -uroot -pmypass \
@@ -52 +52 @@
    -e "START GROUP_REPLICATION;"
 }}}
-We also do above command with node3 (replicate node)
+  
 
 6. Check all nodes status on node1 
@@ -65 +65 @@
 | group_replication_applier | 8ef43b09-e92c-11ec-936c-02420a000b09 | node1       |        3306 | ONLINE       | PRIMARY     | 8.0.29         | XCom                       |
 +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+
-root@n3:/home/ubuntu# 
 }}}
+
+7. Create TEST database with table  on node1
+{{{
+root@n3:/home/ubuntu# docker exec -it 26 mysql -uroot -pmypass   -e "create database TEST; use TEST; CREATE TABLE t1 (id INT NOT NULL PRIMARY KEY) ENGINE=InnoDB; show tables;"
+mysql: [Warning] Using a password on the command line interface can be insecure.
++----------------+
+| Tables_in_TEST |
++----------------+
+| t1             |
++----------------+
+}}}