Debian Codegraph @

mysql-test/suite/group_replication/r/gr_single_primary_and_leader_election_weight.result

raw
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