#### Follow steps from the report ./dbdeployer --sandbox-binary=/export/home/tmp/ushastry/ deploy replication --topology=group 8.0.32 --my-cnf-options="group_replication_ssl_mode=REQUIRED" --my-cnf-options="ssl_ca=ca.pem" --my-cnf-options="ssl_cert=server-cert.pem" --my-cnf-options="ssl_key=server-key.pem" Installing and starting node 1 ... sandbox server started Installing and starting node 2 ... sandbox server started Installing and starting node 3 ... sandbox server started $HOME/sandboxes/group_msb_8_0_32/initialize_nodes # Node 1 # reset master; CHANGE MASTER TO MASTER_USER='rsandbox', MASTER_PASSWORD='rsandbox' FOR CHANNEL 'group_replication_recovery'; # Node 2 # reset master; CHANGE MASTER TO MASTER_USER='rsandbox', MASTER_PASSWORD='rsandbox' FOR CHANNEL 'group_replication_recovery'; # Node 3 # reset master; CHANGE MASTER TO MASTER_USER='rsandbox', MASTER_PASSWORD='rsandbox' FOR CHANNEL 'group_replication_recovery'; # Node 1 # SET GLOBAL group_replication_bootstrap_group=ON; # Node 1 # START GROUP_REPLICATION; # Node 2 # START GROUP_REPLICATION; # Node 3 # START GROUP_REPLICATION; # Node 1 # SET GLOBAL group_replication_bootstrap_group=OFF; # Node 1 # select * from performance_schema.replication_group_members +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+ | CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION | MEMBER_COMMUNICATION_STACK | +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+ | group_replication_applier | 00023233-1111-1111-1111-111111111111 | 127.0.0.1 | 23233 | ONLINE | PRIMARY | 8.0.32 | XCom | | group_replication_applier | 00023234-2222-2222-2222-222222222222 | 127.0.0.1 | 23234 | ONLINE | PRIMARY | 8.0.32 | XCom | | group_replication_applier | 00023235-3333-3333-3333-333333333333 | 127.0.0.1 | 23235 | ONLINE | PRIMARY | 8.0.32 | XCom | +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+ # Node 2 # select * from performance_schema.replication_group_members +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+ | CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION | MEMBER_COMMUNICATION_STACK | +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+ | group_replication_applier | 00023233-1111-1111-1111-111111111111 | 127.0.0.1 | 23233 | ONLINE | PRIMARY | 8.0.32 | XCom | | group_replication_applier | 00023234-2222-2222-2222-222222222222 | 127.0.0.1 | 23234 | ONLINE | PRIMARY | 8.0.32 | XCom | | group_replication_applier | 00023235-3333-3333-3333-333333333333 | 127.0.0.1 | 23235 | ONLINE | PRIMARY | 8.0.32 | XCom | +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+ # Node 3 # select * from performance_schema.replication_group_members +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+ | CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION | MEMBER_COMMUNICATION_STACK | +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+ | group_replication_applier | 00023233-1111-1111-1111-111111111111 | 127.0.0.1 | 23233 | ONLINE | PRIMARY | 8.0.32 | XCom | | group_replication_applier | 00023234-2222-2222-2222-222222222222 | 127.0.0.1 | 23234 | ONLINE | PRIMARY | 8.0.32 | XCom | | group_replication_applier | 00023235-3333-3333-3333-333333333333 | 127.0.0.1 | 23235 | ONLINE | PRIMARY | 8.0.32 | XCom | +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+ Group Replication directory installed in $HOME/sandboxes/group_msb_8_0_32 run 'dbdeployer usage multiple' for basic instructions' # Then stop one node from your group: [umshastr@support-cluster03:~/work/binaries/utils]$ ~/sandboxes/group_msb_8_0_32/node3/stop; stop /home/umshastr/sandboxes/group_msb_8_0_32/node3 ## Then connect to group replication port (33061 by default; in the sandbox env the port was something else like 23358) on node1 with a simple mysql client: bin/mysql -h127.0.0.1 -uroot -P23233 -pmsandbox mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 33 Server version: 8.0.32 MySQL Community Server - GPL Copyright (c) 2000, 2023, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> ## Finally, in a separate terminal, try bringing back node3 to the group, and you will see it's not possible. ~/sandboxes/group_msb_8_0_32/node3/start; ... sandbox server started [umshastr@support-cluster03:~/work/binaries/utils]$ ~/sandboxes/group_msb_8_0_32/node3/use -e "START GROUP_REPLICATION"; [umshastr@support-cluster03:~/work/binaries/utils]$ ## Nothing is observed pstack $(cat ~/sandboxes/group_msb_8_0_32/node1/data/*pid) |grep -iB3 -A7 BIO_read pstack $(cat ~/sandboxes/group_msb_8_0_32/node2/data/*pid) |grep -iB3 -A7 BIO_read ## Confirmed that node 3 has joined ./check_nodes # Node 1 # select * from performance_schema.replication_group_members +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+ | CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION | MEMBER_COMMUNICATION_STACK | +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+ | group_replication_applier | 00023233-1111-1111-1111-111111111111 | 127.0.0.1 | 23233 | ONLINE | PRIMARY | 8.0.32 | XCom | | group_replication_applier | 00023234-2222-2222-2222-222222222222 | 127.0.0.1 | 23234 | ONLINE | PRIMARY | 8.0.32 | XCom | | group_replication_applier | 00023235-3333-3333-3333-333333333333 | 127.0.0.1 | 23235 | ONLINE | PRIMARY | 8.0.32 | XCom | +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+ # Node 2 # select * from performance_schema.replication_group_members +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+ | CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION | MEMBER_COMMUNICATION_STACK | +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+ | group_replication_applier | 00023233-1111-1111-1111-111111111111 | 127.0.0.1 | 23233 | ONLINE | PRIMARY | 8.0.32 | XCom | | group_replication_applier | 00023234-2222-2222-2222-222222222222 | 127.0.0.1 | 23234 | ONLINE | PRIMARY | 8.0.32 | XCom | | group_replication_applier | 00023235-3333-3333-3333-333333333333 | 127.0.0.1 | 23235 | ONLINE | PRIMARY | 8.0.32 | XCom | +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+ # Node 3 # select * from performance_schema.replication_group_members +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+ | CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION | MEMBER_COMMUNICATION_STACK | +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+ | group_replication_applier | 00023233-1111-1111-1111-111111111111 | 127.0.0.1 | 23233 | ONLINE | PRIMARY | 8.0.32 | XCom | | group_replication_applier | 00023234-2222-2222-2222-222222222222 | 127.0.0.1 | 23234 | ONLINE | PRIMARY | 8.0.32 | XCom | | group_replication_applier | 00023235-3333-3333-3333-333333333333 | 127.0.0.1 | 23235 | ONLINE | PRIMARY | 8.0.32 | XCom | +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+