| 1 |
include/group_replication.inc [rpl_server_count=4] |
| 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 server1] |
| 7 |
# |
| 8 |
# 1. Verify group_replication_member_weight for value range, NULL, |
| 9 |
# string and decimal. |
| 10 |
# |
| 11 |
# 1.1. Set group_replication_member_weight to below minimum value. |
| 12 |
SET @@GLOBAL.group_replication_member_weight= -1; |
| 13 |
# 1.2. Verify its set to minimum value of the group replication variables. |
| 14 |
include/assert.inc [Minimum group_replication_member_weight is 0] |
| 15 |
# 1.3. Set group_replication_member_weight above its maximum value. |
| 16 |
SET @@GLOBAL.group_replication_member_weight= 110; |
| 17 |
# 1.4. Verify its set to maximum value of the group replication variables. |
| 18 |
include/assert.inc [Maximum group_replication_member_weight is 100] |
| 19 |
# 1.5. Verify that setting group_replication_member_weight value to NULL |
| 20 |
# results in incorrect argument type error. |
| 21 |
SET @@GLOBAL.group_replication_member_weight= NULL; |
| 22 |
ERROR 42000: Incorrect argument type to variable 'group_replication_member_weight' |
| 23 |
# 1.6. Verify that setting group_replication_member_weight value to string |
| 24 |
# results in incorrect argument type error. |
| 25 |
SET @@GLOBAL.group_replication_member_weight= 'random'; |
| 26 |
ERROR 42000: Incorrect argument type to variable 'group_replication_member_weight' |
| 27 |
# 1.7. Verify that setting group_replication_member_weight value to decimal |
| 28 |
# results in incorrect argument type error. |
| 29 |
SET @@GLOBAL.group_replication_member_weight= 40.1; |
| 30 |
ERROR 42000: Incorrect argument type to variable 'group_replication_member_weight' |
| 31 |
# |
| 32 |
# 2. Set member weight before(90,98,92,93) and after(91,93,87,97) |
| 33 |
# start group replication and verify if it set correctly. |
| 34 |
SET GLOBAL group_replication_member_weight= 90; |
| 35 |
include/start_and_bootstrap_group_replication.inc |
| 36 |
include/assert.inc [Assert that server has group_replication_member_weight=90] |
| 37 |
SET GLOBAL group_replication_member_weight= 91; |
| 38 |
include/assert.inc [Assert that server has group_replication_member_weight=91 after update] |
| 39 |
[connection server2] |
| 40 |
SET GLOBAL group_replication_member_weight= 98; |
| 41 |
include/start_group_replication.inc |
| 42 |
include/assert.inc [Assert that server has group_replication_member_weight=98] |
| 43 |
SET GLOBAL group_replication_member_weight= 93; |
| 44 |
include/assert.inc [Assert that server has group_replication_member_weight=93 after update] |
| 45 |
include/gr_wait_primary_member_uuid.inc |
| 46 |
[connection server3] |
| 47 |
SET GLOBAL group_replication_member_weight= 92; |
| 48 |
include/start_group_replication.inc |
| 49 |
include/assert.inc [Assert that server has group_replication_member_weight=92] |
| 50 |
SET GLOBAL group_replication_member_weight= 87; |
| 51 |
include/assert.inc [Assert that server has group_replication_member_weight=87 after update] |
| 52 |
[connection server4] |
| 53 |
SET GLOBAL group_replication_member_weight= 93; |
| 54 |
include/start_group_replication.inc |
| 55 |
include/assert.inc [Assert that server has group_replication_member_weight=93] |
| 56 |
SET GLOBAL group_replication_member_weight= 97; |
| 57 |
include/assert.inc [Assert that server has group_replication_member_weight=97 after update] |
| 58 |
# |
| 59 |
# 3. Verify next primaries get selected in order 1, 4, 2, 3 |
| 60 |
# based on member weight. |
| 61 |
[connection server1] |
| 62 |
include/gr_wait_primary_member_uuid.inc |
| 63 |
include/assert.inc [Verify group_replication_primary_member is server1] |
| 64 |
include/stop_group_replication.inc |
| 65 |
[connection server4] |
| 66 |
include/gr_wait_primary_member_uuid.inc |
| 67 |
include/assert.inc [Verify group_replication_primary_member is server4] |
| 68 |
include/stop_group_replication.inc |
| 69 |
[connection server2] |
| 70 |
include/gr_wait_primary_member_uuid.inc |
| 71 |
include/assert.inc [Verify group_replication_primary_member is server2] |
| 72 |
include/stop_group_replication.inc |
| 73 |
[connection server3] |
| 74 |
include/gr_wait_primary_member_uuid.inc |
| 75 |
include/assert.inc [Verify group_replication_primary_member is server3] |
| 76 |
include/stop_group_replication.inc |
| 77 |
[connection server1] |
| 78 |
SET @@GLOBAL.group_replication_member_weight= DEFAULT; |
| 79 |
[connection server2] |
| 80 |
SET @@GLOBAL.group_replication_member_weight= DEFAULT; |
| 81 |
[connection server3] |
| 82 |
SET @@GLOBAL.group_replication_member_weight= DEFAULT; |
| 83 |
[connection server4] |
| 84 |
SET @@GLOBAL.group_replication_member_weight= DEFAULT; |
| 85 |
include/group_replication_end.inc |