| 1 |
# 1. Skip the group start |
| 2 |
include/group_replication.inc [rpl_server_count=3] |
| 3 |
Warnings: |
| 4 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 5 |
Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information. |
| 6 |
[connection server1] |
| 7 |
# 2. Start and bootstrap the group with server 1 |
| 8 |
[connection server1] |
| 9 |
include/start_and_bootstrap_group_replication.inc |
| 10 |
# 3. Start server 2 |
| 11 |
[connection server2] |
| 12 |
include/start_group_replication.inc |
| 13 |
# 4. Change server 3 communication stack and local address to MySQL |
| 14 |
[connection server3] |
| 15 |
SET SESSION sql_log_bin= 0; |
| 16 |
call mtr.add_suppression("\\[GCS\\] Error connecting to all peers. Member join failed. Local port:*"); |
| 17 |
call mtr.add_suppression("\\[GCS\\] The member was unable to join the group.*"); |
| 18 |
call mtr.add_suppression("Timeout on wait for view after joining group"); |
| 19 |
SET SESSION sql_log_bin= 1; |
| 20 |
SET GLOBAL group_replication_local_address= "GROUP_REPLICATION_SERVER_3_ADDRESS"; |
| 21 |
SET GLOBAL group_replication_communication_stack= MySQL; |
| 22 |
# 5. Manually start server 3 and expect it to fail while joining the |
| 23 |
# group |
| 24 |
SET GLOBAL group_replication_group_name= "GROUP_REPLICATION_GROUP_NAME"; |
| 25 |
START GROUP_REPLICATION; |
| 26 |
ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log. |
| 27 |
# 6. Restore server 3 original address |
| 28 |
SET GLOBAL group_replication_local_address= "GROUP_REPLICATION_SERVER_3_LOCAL_ADDRESS"; |
| 29 |
SET GLOBAL group_replication_communication_stack= "XCOM"; |
| 30 |
# 7. Server 3 must successfully join the group |
| 31 |
include/start_group_replication.inc |
| 32 |
# 8. Clean up. |
| 33 |
include/group_replication_end.inc |