Changes between Version 8 and Version 9 of GROUPReplicate

Timestamp:

06/11/22 02:46:13 (3 years ago)

Author:

krit

Comment:

--

GROUPReplicate

@@ -89 +89 @@
 root@n2:/home/ubuntu# 
 }}}
+
+9. Test replicate node2 out from group
+{{{
+root@n2:/home/ubuntu# docker stop node2
+}}}
+
+10. Check on node1
+{{{
+root@n3:/home/ubuntu# docker exec -it 26 mysql -uroot -pmypass   -e "SELECT * FROM performance_schema.replication_group_members;"
+mysql: [Warning] Using a password on the command line interface can be insecure.
++---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+
+| CHANNEL_NAME              | MEMBER_ID                            | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION | MEMBER_COMMUNICATION_STACK |
++---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+
+| group_replication_applier | 89a10b8c-e92c-11ec-9362-02420a000b06 | node3       |        3306 | ONLINE       | SECONDARY   | 8.0.29         | XCom                       |
+| group_replication_applier | 8ef43b09-e92c-11ec-936c-02420a000b09 | node1       |        3306 | ONLINE       | PRIMARY     | 8.0.29         | XCom                       |
++---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+
+
+}}}