Debian Codegraph @

mysql-test/suite/group_replication/t/gr_single_primary_and_leader_election_weight.test

raw
1 ###################################################################
2 # WL#10433 Group Replication: Member weight for automatic primary
3 # election on failover
4 #
5 # Validate that leader election takes place based on member weight
6 # except when starting group for the first time. The first primary
7 # is member which bootstrap the group without considering member
8 # weight.
9 #
10 # Test:
11 # 1. Verify group_replication_member_weight for value range, NULL,
12 # string and decimal.
13 # 1.1. Set group_replication_member_weight below its minimum value
14 # 1.2. Verify its set to minimum value of the group_replication_member_weight
15 # 1.3. Set group_replication_member_weight above its maximum value
16 # 1.4. Verify its set to maximum value of the group_replication_member_weight
17 # 1.5. Verify that setting group_replication_member_weight value to NULL
18 # results in incorrect argument type error.
19 # 1.6. Verify that setting group_replication_member_weight value to string
20 # results in incorrect argument type error.
21 # 1.7. Verify that setting group_replication_member_weight value to decimal
22 # results in incorrect argument type error.
23 #
24 # 2. Set member weight before(90,98,92,93) and after(91,93,87,97)
25 # start group replication for server1,2,3,4 respectively, and
26 # verify if it set correctly.
27 # For each server it performs following steps:
28 # - Get member uuid.
29 # - Set member weight.
30 # - Start group replication (boostrap group using server1).
31 # - Assert member weight is set properly.
32 # - Update member weight.
33 # - Assert member weight is set properly.
34 #
35 # 3. Verify next primaries get selected in order 1, 4, 2, 3
36 # based on member weight. After verifying stop current primary
37 # so next primary can be elected.
38 # 2.1. Wait for server1 to be set as primary member.
39 # 2.2. Assert first primary is server1 as it bootstrapped the group.
40 # 2.3. Stop group replication on server1.
41 # 2.4. Wait for server4 to be set as primary member.
42 # 2.5. Assert next primary is server4 as it has next highest
43 # member_weight=97
44 # 2.6. Stop group replication on server4.
45 # 2.7. Wait for server2 to be set as primary member.
46 # 2.8. Assert next primary is server2 as it has next highest
47 # member_weight=93
48 # 2.9. Stop group replication on server2.
49 # 2.10. Wait for server3 to be set as primary member.
50 # 2.11. Assert next primary is server3 as it has next highest
51 # member_weight=87
52 # 2.12. Stop group replication on server3.
53 #
54 ##################################################################
55
56 --source include/big_test.inc
57 --source include/have_group_replication_plugin.inc
58
59 --let $rpl_skip_group_replication_start= 1
60 --let $rpl_server_count= 4
61 --let $rpl_group_replication_single_primary_mode=1
62 --source include/group_replication.inc
63
64 --let $rpl_connection_name= server1
65 --source include/rpl_connection.inc
66
67 --echo #
68 --echo # 1. Verify group_replication_member_weight for value range, NULL,
69 --echo # string and decimal.
70 --echo #
71
72 --echo # 1.1. Set group_replication_member_weight to below minimum value.
73 SET @@GLOBAL.group_replication_member_weight= -1;
74
75 --echo # 1.2. Verify its set to minimum value of the group replication variables.
76 --let $assert_text= Minimum group_replication_member_weight is 0
77 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_member_weight]" = 0
78 --source include/assert.inc
79
80 --echo # 1.3. Set group_replication_member_weight above its maximum value.
81 SET @@GLOBAL.group_replication_member_weight= 110;
82
83 --echo # 1.4. Verify its set to maximum value of the group replication variables.
84 --let $assert_text= Maximum group_replication_member_weight is 100
85 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_member_weight]" = 100
86 --source include/assert.inc
87
88 --echo # 1.5. Verify that setting group_replication_member_weight value to NULL
89 --echo # results in incorrect argument type error.
90 --error ER_WRONG_TYPE_FOR_VAR
91 SET @@GLOBAL.group_replication_member_weight= NULL;
92
93 --echo # 1.6. Verify that setting group_replication_member_weight value to string
94 --echo # results in incorrect argument type error.
95 --error ER_WRONG_TYPE_FOR_VAR
96 SET @@GLOBAL.group_replication_member_weight= 'random';
97
98 --echo # 1.7. Verify that setting group_replication_member_weight value to decimal
99 --echo # results in incorrect argument type error.
100 --error ER_WRONG_TYPE_FOR_VAR
101 SET @@GLOBAL.group_replication_member_weight= 40.1;
102
103
104 --echo #
105 --echo # 2. Set member weight before(90,98,92,93) and after(91,93,87,97)
106 --echo # start group replication and verify if it set correctly.
107
108 # Server1
109
110 # get member uuid
111 --let $server_uuid1=`SELECT @@server_uuid`
112
113 # set member weight
114 --eval SET GLOBAL group_replication_member_weight= 90
115
116 # Boosttrap and start group replication
117 --source include/start_and_bootstrap_group_replication.inc
118
119 # Assert member weight is set properly
120 --let $member_weight= query_get_value(SELECT @@GLOBAL.group_replication_member_weight, @@GLOBAL.group_replication_member_weight, 1)
121 --let $assert_cond= $member_weight = 90
122 --let $assert_text= Assert that server has group_replication_member_weight=$member_weight
123 --source include/assert.inc
124
125 # update member weight
126 --eval SET GLOBAL group_replication_member_weight= 91
127
128 # Assert member weight is set properly after update
129 --let $member_weight= query_get_value(SELECT @@GLOBAL.group_replication_member_weight, @@GLOBAL.group_replication_member_weight, 1)
130 --let $assert_cond= $member_weight = 91
131 --let $assert_text= Assert that server has group_replication_member_weight=$member_weight after update
132 --source include/assert.inc
133
134
135 # Server2
136 --let $rpl_connection_name= server2
137 --source include/rpl_connection.inc
138
139 # get member uuid
140 --let $server_uuid2=`SELECT @@server_uuid`
141
142 # set member weight
143 --eval SET GLOBAL group_replication_member_weight= 98
144
145 # start group replication
146 --source include/start_group_replication.inc
147
148 # Assert member weight is set properly
149 --let $member_weight= query_get_value(SELECT @@GLOBAL.group_replication_member_weight, @@GLOBAL.group_replication_member_weight, 1)
150 --let $assert_cond= $member_weight = 98
151 --let $assert_text= Assert that server has group_replication_member_weight=$member_weight
152 --source include/assert.inc
153
154 # update member weight
155 --eval SET GLOBAL group_replication_member_weight= 93
156
157 # Assert member weight is set properly after update
158 --let $member_weight= query_get_value(SELECT @@GLOBAL.group_replication_member_weight, @@GLOBAL.group_replication_member_weight, 1)
159 --let $assert_cond= $member_weight = 93
160 --let $assert_text= Assert that server has group_replication_member_weight=$member_weight after update
161 --source include/assert.inc
162
163 # Wait for member to point PRIMARY node i.e. server1 or abort.
164 --let $group_replication_expected_uuid=$server_uuid1
165 --source include/gr_wait_primary_member_uuid.inc
166
167
168 # Server3
169 --let $rpl_connection_name= server3
170 --source include/rpl_connection.inc
171
172 # get member uuid
173 --let $server_uuid3=`SELECT @@server_uuid`
174
175 # set member weight
176 --eval SET GLOBAL group_replication_member_weight= 92
177
178 # start group replication
179 --source include/start_group_replication.inc
180
181 # Assert member weight is set properly
182 --let $member_weight= query_get_value(SELECT @@GLOBAL.group_replication_member_weight, @@GLOBAL.group_replication_member_weight, 1)
183 --let $assert_cond= $member_weight = 92
184 --let $assert_text= Assert that server has group_replication_member_weight=$member_weight
185 --source include/assert.inc
186
187 # update member weight
188 --eval SET GLOBAL group_replication_member_weight= 87
189
190 # Assert member weight is set properly after update
191 --let $member_weight= query_get_value(SELECT @@GLOBAL.group_replication_member_weight, @@GLOBAL.group_replication_member_weight, 1)
192 --let $assert_cond= $member_weight = 87
193 --let $assert_text= Assert that server has group_replication_member_weight=$member_weight after update
194 --source include/assert.inc
195
196
197 # Server4
198 --let $rpl_connection_name= server4
199 --source include/rpl_connection.inc
200
201 # get member uuid
202 --let $server_uuid4=`SELECT @@server_uuid`
203
204 # set member weight
205 --eval SET GLOBAL group_replication_member_weight= 93
206
207 # start group replication
208 --source include/start_group_replication.inc
209
210 # Assert member weight is set properly
211 --let $member_weight= query_get_value(SELECT @@GLOBAL.group_replication_member_weight, @@GLOBAL.group_replication_member_weight, 1)
212 --let $assert_cond= $member_weight = 93
213 --let $assert_text= Assert that server has group_replication_member_weight=$member_weight
214 --source include/assert.inc
215
216 # update member weight
217 --eval SET GLOBAL group_replication_member_weight= 97
218
219 # Assert member weight is set properly after update
220 --let $member_weight= query_get_value(SELECT @@GLOBAL.group_replication_member_weight, @@GLOBAL.group_replication_member_weight, 1)
221 --let $assert_cond= $member_weight = 97
222 --let $assert_text= Assert that server has group_replication_member_weight=$member_weight after update
223 --source include/assert.inc
224
225
226 --echo #
227 --echo # 3. Verify next primaries get selected in order 1, 4, 2, 3
228 --echo # based on member weight.
229
230 --let $rpl_connection_name= server1
231 --source include/rpl_connection.inc
232
233 # 3.1. Wait for server1 to be set as primary member.
234 --let $group_replication_expected_uuid=$server_uuid1
235 --source include/gr_wait_primary_member_uuid.inc
236
237 # 3.2. Assert first primary is server1 as it bootstrapped the group
238 --let $assert_text= Verify group_replication_primary_member is server1
239 --let $assert_cond= "[SELECT VARIABLE_VALUE FROM performance_schema.global_status WHERE VARIABLE_NAME= \'group_replication_primary_member\', VARIABLE_VALUE, 1]" = "$server_uuid1"
240 --source include/assert.inc
241
242 # 3.3. stop group replication on server1
243 --source include/stop_group_replication.inc
244
245
246 --let $rpl_connection_name= server4
247 --source include/rpl_connection.inc
248
249 # 3.4. Wait for server4 to be set as primary member.
250 --let $group_replication_expected_uuid=$server_uuid4
251 --source include/gr_wait_primary_member_uuid.inc
252
253 # 3.5. Assert next primary is server4 as it has highest member_weight=97
254 --let $assert_text= Verify group_replication_primary_member is server4
255 --let $assert_cond= "[SELECT VARIABLE_VALUE FROM performance_schema.global_status WHERE VARIABLE_NAME= \'group_replication_primary_member\', VARIABLE_VALUE, 1]" = "$server_uuid4"
256 --source include/assert.inc
257
258 # 3.6. stop group replication on server4
259 --source include/stop_group_replication.inc
260
261
262 --let $rpl_connection_name= server2
263 --source include/rpl_connection.inc
264
265 # 3.7. Wait for server2 to be set as primary member.
266 --let $group_replication_expected_uuid=$server_uuid2
267 --source include/gr_wait_primary_member_uuid.inc
268
269 # 3.8. Assert next primary is server2 as it has next highest member_weight=93
270 --let $assert_text= Verify group_replication_primary_member is server2
271 --let $assert_cond= "[SELECT VARIABLE_VALUE FROM performance_schema.global_status WHERE VARIABLE_NAME= \'group_replication_primary_member\', VARIABLE_VALUE, 1]" = "$server_uuid2"
272 --source include/assert.inc
273
274 # 3.9. stop group replication on server2
275 --source include/stop_group_replication.inc
276
277
278 --let $rpl_connection_name= server3
279 --source include/rpl_connection.inc
280
281 # 3.10. Wait for server3 to be set as primary member.
282 --let $group_replication_expected_uuid=$server_uuid3
283 --source include/gr_wait_primary_member_uuid.inc
284
285 # 3.11. Assert next primary is server3 as it has next highest member_weight=87
286 --let $assert_text= Verify group_replication_primary_member is server3
287 --let $assert_cond= "[SELECT VARIABLE_VALUE FROM performance_schema.global_status WHERE VARIABLE_NAME= \'group_replication_primary_member\', VARIABLE_VALUE, 1]" = "$server_uuid3"
288 --source include/assert.inc
289
290 # 3.12. stop group replication on server3
291 --source include/stop_group_replication.inc
292
293
294 --let $rpl_connection_name= server1
295 --source include/rpl_connection.inc
296 SET @@GLOBAL.group_replication_member_weight= DEFAULT;
297
298
299 --let $rpl_connection_name= server2
300 --source include/rpl_connection.inc
301 SET @@GLOBAL.group_replication_member_weight= DEFAULT;
302
303
304 --let $rpl_connection_name= server3
305 --source include/rpl_connection.inc
306 SET @@GLOBAL.group_replication_member_weight= DEFAULT;
307
308
309 --let $rpl_connection_name= server4
310 --source include/rpl_connection.inc
311 SET @@GLOBAL.group_replication_member_weight= DEFAULT;
312
313
314 --source include/group_replication_end.inc