| 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 |
|
| 7 |
############################################################ |
| 8 |
# 1. Bootstrap the group with a server that is one patch version |
| 9 |
# higher than the current version (8.0.35 or higher). |
| 10 |
[connection server1] |
| 11 |
SET SESSION sql_log_bin= 0; |
| 12 |
call mtr.add_suppression("Error while executing a group configuration operation: Error processing configuration start message: The appointed primary member has a version that is greater than the one of some of the members in the group."); |
| 13 |
SET SESSION sql_log_bin= 1; |
| 14 |
SET @@GLOBAL.DEBUG= '+d,group_replication_compatibility_higher_patch_version'; |
| 15 |
include/start_and_bootstrap_group_replication.inc |
| 16 |
|
| 17 |
############################################################ |
| 18 |
# 2. Join a server that is one patch version |
| 19 |
# higher than the current version (8.0.35 or higher). |
| 20 |
[connection server2] |
| 21 |
SET SESSION sql_log_bin= 0; |
| 22 |
call mtr.add_suppression("The function 'group_replication_set_as_primary' failed. Error processing configuration start message: The appointed primary member has a version that is greater than the one of some of the members in the group."); |
| 23 |
SET SESSION sql_log_bin= 1; |
| 24 |
SET @@GLOBAL.DEBUG= '+d,group_replication_compatibility_higher_patch_version'; |
| 25 |
include/start_group_replication.inc |
| 26 |
|
| 27 |
############################################################ |
| 28 |
# 3. Join a 8.0.35 to the group. |
| 29 |
[connection server3] |
| 30 |
SET SESSION sql_log_bin= 0; |
| 31 |
call mtr.add_suppression("Error while executing a group configuration operation: Error processing configuration start message: The appointed primary member has a version that is greater than the one of some of the members in the group."); |
| 32 |
SET SESSION sql_log_bin= 1; |
| 33 |
SET @@GLOBAL.DEBUG= '+d,group_replication_version_8_0_35'; |
| 34 |
include/start_group_replication.inc |
| 35 |
SELECT MEMBER_STATE, MEMBER_ROLE, MEMBER_VERSION FROM performance_schema.replication_group_members WHERE MEMBER_ID='SERVER3_UUID'; |
| 36 |
MEMBER_STATE MEMBER_ROLE MEMBER_VERSION |
| 37 |
ONLINE SECONDARY 8.0.35 |
| 38 |
|
| 39 |
############################################################ |
| 40 |
# 4. Validate that the group has one primary and two secondaries. |
| 41 |
[connection server1] |
| 42 |
include/rpl_gr_wait_for_number_of_members.inc |
| 43 |
include/gr_assert_primary_member.inc |
| 44 |
[connection server2] |
| 45 |
include/gr_assert_secondary_member.inc |
| 46 |
[connection server3] |
| 47 |
include/gr_assert_secondary_member.inc |
| 48 |
|
| 49 |
############################################################ |
| 50 |
# 5. Try to make server2, a higher version, the primary. |
| 51 |
# It must fail. |
| 52 |
[connection server2] |
| 53 |
SELECT group_replication_set_as_primary("SERVER2_UUID"); |
| 54 |
ERROR HY000: The function 'group_replication_set_as_primary' failed. Error processing configuration start message: The appointed primary member has a version that is greater than the one of some of the members in the group. |
| 55 |
include/gr_assert_secondary_member.inc |
| 56 |
[connection server1] |
| 57 |
include/gr_assert_primary_member.inc |
| 58 |
[connection server3] |
| 59 |
include/gr_assert_secondary_member.inc |
| 60 |
|
| 61 |
############################################################ |
| 62 |
# 6. After the primary, server1, leaves, server3 is the new |
| 63 |
# primary. |
| 64 |
[connection server1] |
| 65 |
include/stop_group_replication.inc |
| 66 |
[connection server3] |
| 67 |
include/rpl_gr_wait_for_number_of_members.inc |
| 68 |
include/gr_assert_primary_member.inc |
| 69 |
[connection server2] |
| 70 |
include/gr_assert_secondary_member.inc |
| 71 |
|
| 72 |
############################################################ |
| 73 |
# 7. Clean up. |
| 74 |
[connection server1] |
| 75 |
SET @@GLOBAL.DEBUG= '-d,group_replication_compatibility_higher_patch_version'; |
| 76 |
[connection server2] |
| 77 |
SET @@GLOBAL.DEBUG= '-d,group_replication_compatibility_higher_patch_version'; |
| 78 |
[connection server3] |
| 79 |
SET @@GLOBAL.DEBUG= '-d,group_replication_version_8_0_35'; |
| 80 |
include/group_replication_end.inc |