| 1 |
include/group_replication.inc [rpl_server_count=3] |
| 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 |
[connection server2] |
| 7 |
[connection server3] |
| 8 |
[connection server1] |
| 9 |
############################################################################### |
| 10 |
# 2. Check that it is *not* possible to modify the communication_protocol value via an ONLINE member when some other member is in RECOVERING state. |
| 11 |
[connection server2] |
| 12 |
include/stop_group_replication.inc |
| 13 |
[connection server2] |
| 14 |
SET @@GLOBAL.DEBUG='+d,recovery_thread_wait_before_finish'; |
| 15 |
include/start_group_replication.inc |
| 16 |
[connection server1] |
| 17 |
SELECT group_replication_set_communication_protocol("5.7.14"); |
| 18 |
ERROR HY000: Can't initialize function 'group_replication_set_communication_protocol'; A member is joining the group, wait for it to be ONLINE. |
| 19 |
############################################################################### |
| 20 |
# 3. Check that it is *not* possible to modify the communication_protocol value via a RECOVERING member. |
| 21 |
[connection server2] |
| 22 |
SELECT group_replication_set_communication_protocol("5.7.14"); |
| 23 |
ERROR HY000: Can't initialize function 'group_replication_set_communication_protocol'; A member is joining the group, wait for it to be ONLINE. |
| 24 |
############################################################################### |
| 25 |
# 4. Check that it is possible to query the communication_protocol value via an ONLINE member when some other members are in RECOVERING state. |
| 26 |
[connection server1] |
| 27 |
SELECT group_replication_get_communication_protocol(); |
| 28 |
group_replication_get_communication_protocol() |
| 29 |
GR_COMMUNICATION_PROTOCOL_VERSION |
| 30 |
############################################################################### |
| 31 |
# 5. Check that it is *not* possible to query the communication_protocol value via a RECOVERING member. |
| 32 |
[connection server2] |
| 33 |
SELECT group_replication_get_communication_protocol(); |
| 34 |
ERROR HY000: Can't initialize function 'group_replication_get_communication_protocol'; Member must be ONLINE and in the majority partition. |
| 35 |
[connection server2] |
| 36 |
SET DEBUG_SYNC= "now WAIT_FOR signal.recovery_thread_wait_before_finish_reached"; |
| 37 |
SET @@GLOBAL.DEBUG='-d,recovery_thread_wait_before_finish'; |
| 38 |
SET DEBUG_SYNC= "now SIGNAL signal.recovery_end"; |
| 39 |
Wait until server2 becomes ONLINE |
| 40 |
include/gr_wait_for_member_state.inc |
| 41 |
SET DEBUG_SYNC= 'RESET'; |
| 42 |
############################################################################### |
| 43 |
# 6. Check that it is *not* possible to modify the communication_protocol value via an ONLINE member when some member is in UNREACHABLE state. |
| 44 |
# Kill and restart |
| 45 |
[connection server_1] |
| 46 |
include/gr_wait_for_member_state.inc |
| 47 |
SELECT group_replication_set_communication_protocol("5.7.14"); |
| 48 |
ERROR HY000: Can't initialize function 'group_replication_set_communication_protocol'; All members in the group must be reachable. |
| 49 |
############################################################################### |
| 50 |
# 7. Check that it is possible to query the communication_protocol value via an ONLINE member when a minority of members are UNREACHABLE. |
| 51 |
SELECT group_replication_get_communication_protocol(); |
| 52 |
group_replication_get_communication_protocol() |
| 53 |
GR_COMMUNICATION_PROTOCOL_VERSION |
| 54 |
############################################################################### |
| 55 |
# 8. Check that it is *not* possible to query the communication_protocol value via an ONLINE member when a majority of members are UNREACHABLE. |
| 56 |
[connection server3] |
| 57 |
# Kill and restart |
| 58 |
[connection server_1] |
| 59 |
include/gr_wait_for_member_state.inc |
| 60 |
SELECT group_replication_get_communication_protocol(); |
| 61 |
ERROR HY000: Can't initialize function 'group_replication_get_communication_protocol'; Member must be ONLINE and in the majority partition. |
| 62 |
############################################################################### |
| 63 |
# 9. Cleanup |
| 64 |
[connection server1] |
| 65 |
include/rpl_reconnect.inc |
| 66 |
[connection server_2] |
| 67 |
SET @@global.group_replication_group_seeds="GROUP_SEEDS_SERVER2"; |
| 68 |
SET @@global.group_replication_local_address="LOCAL_ADDRESS_SERVER2"; |
| 69 |
SET @@global.group_replication_group_name="GROUP_REPLICATION_GROUP_NAME"; |
| 70 |
include/start_group_replication.inc |
| 71 |
include/rpl_reconnect.inc |
| 72 |
[connection server_3] |
| 73 |
SET @@global.group_replication_group_seeds="GROUP_SEEDS_SERVER3"; |
| 74 |
SET @@global.group_replication_local_address="LOCAL_ADDRESS_SERVER3"; |
| 75 |
SET @@global.group_replication_group_name="GROUP_REPLICATION_GROUP_NAME"; |
| 76 |
include/start_group_replication.inc |
| 77 |
[connection server1] |
| 78 |
include/rpl_gr_wait_for_number_of_members.inc |
| 79 |
include/group_replication_end.inc |