| 1 |
include/group_replication.inc |
| 2 |
Warnings: |
| 3 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 4 |
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. |
| 5 |
[connection server1] |
| 6 |
|
| 7 |
############################################################ |
| 8 |
# 1. Bootstrap a group on server1, forcing server1 uuid to |
| 9 |
# "cccccccc-cccc-cccc-cccc-cccccccccccc". |
| 10 |
[connection server1] |
| 11 |
SET @debug_save= @@GLOBAL.DEBUG; |
| 12 |
SET @@GLOBAL.DEBUG= '+d,group_replication_force_member_uuid'; |
| 13 |
SET GLOBAL group_replication_group_name= "GROUP_REPLICATION_GROUP_NAME"; |
| 14 |
SET GLOBAL group_replication_bootstrap_group= 1; |
| 15 |
START GROUP_REPLICATION; |
| 16 |
|
| 17 |
############################################################ |
| 18 |
# 2. Try to join a second member to the group with the same |
| 19 |
# server uuid as server1. The join must fail. |
| 20 |
[connection server2] |
| 21 |
SET SESSION sql_log_bin= 0; |
| 22 |
call mtr.add_suppression("There is already a member with server_uuid cccccccc-cccc-cccc-cccc-cccccccccccc. The member will now exit the group."); |
| 23 |
SET SESSION sql_log_bin= 1; |
| 24 |
SET @debug_save= @@GLOBAL.DEBUG; |
| 25 |
SET @@GLOBAL.DEBUG= '+d,group_replication_force_member_uuid'; |
| 26 |
SET GLOBAL group_replication_group_name= "GROUP_REPLICATION_GROUP_NAME"; |
| 27 |
START GROUP_REPLICATION; |
| 28 |
ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log. |
| 29 |
|
| 30 |
############################################################ |
| 31 |
# 3. Assert that group membership is reported properly on |
| 32 |
# both servers. |
| 33 |
[connection server2] |
| 34 |
include/assert.inc [Member2 only reports one member] |
| 35 |
include/assert.inc [Member2 is reported as OFFLINE] |
| 36 |
[connection server1] |
| 37 |
include/assert.inc [Member1 only reports one member] |
| 38 |
include/assert.inc [Member1 is reported as ONLINE] |
| 39 |
|
| 40 |
############################################################ |
| 41 |
# 4. Clean up. |
| 42 |
[connection server1] |
| 43 |
SET @@GLOBAL.DEBUG= @debug_save; |
| 44 |
[connection server2] |
| 45 |
SET @@GLOBAL.DEBUG= @debug_save; |
| 46 |
include/group_replication_end.inc |