Debian Codegraph @

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

raw
1 ################################################################################
2 # Verify that group_replication_flow_control options do behave as expected.
3 # 1. Test group_replication_flow_control_mode option.
4 # 2. Test group_replication_flow_control_certifier_threshold
5 # option.
6 # 3. Test group_replication_flow_control_applier_threshold
7 # option.
8 # 4. Change all group_replication_flow_control options while
9 # Group Replication is running.
10 # 5. Clean up.
11 ################################################################################
12 --source include/have_debug.inc
13
14 --source include/have_group_replication_plugin.inc
15 --let $rpl_skip_group_replication_start= 1
16 --source include/group_replication.inc
17
18 SET @group_replication_flow_control_mode_save= @@GLOBAL.group_replication_flow_control_mode;
19 SET @group_replication_flow_control_certifier_threshold_save= @@GLOBAL.group_replication_flow_control_certifier_threshold;
20 SET @group_replication_flow_control_applier_threshold_save= @@GLOBAL.group_replication_flow_control_applier_threshold;
21
22 SET @group_replication_flow_control_min_quota_save= @@GLOBAL.group_replication_flow_control_min_quota;
23 SET @group_replication_flow_control_min_recovery_quota_save= @@GLOBAL.group_replication_flow_control_min_recovery_quota;
24 SET @group_replication_flow_control_max_quota_save= @@GLOBAL.group_replication_flow_control_max_quota;
25 SET @group_replication_flow_control_member_quota_percent_save= @@GLOBAL.group_replication_flow_control_member_quota_percent;
26 SET @group_replication_flow_control_period_save= @@GLOBAL.group_replication_flow_control_period;
27 SET @group_replication_flow_control_hold_percent_save= @@GLOBAL.group_replication_flow_control_hold_percent;
28 SET @group_replication_flow_control_release_percent_save= @@GLOBAL.group_replication_flow_control_release_percent;
29
30 SET @debug_saved= @@GLOBAL.DEBUG;
31 SET @@GLOBAL.DEBUG= 'd,flow_control_simulate_delayed_members';
32
33 set session sql_log_bin=0;
34 CALL mtr.add_suppression("group_replication_flow_control_min_quota cannot be larger than group_replication_flow_control_max_quota");
35 CALL mtr.add_suppression("group_replication_flow_control_min_recovery_quota cannot be larger than group_replication_flow_control_max_quota");
36 CALL mtr.add_suppression("group_replication_flow_control_max_quota cannot be smaller than group_replication_flow_control_min_quota or group_replication_flow_control_min_recovery_quota");
37 set session sql_log_bin=1;
38
39 --echo
40 --echo ############################################################
41 --echo # 1. Test group_replication_flow_control_mode option.
42 # Invalid values
43 --error ER_WRONG_VALUE_FOR_VAR
44 SET GLOBAL group_replication_flow_control_mode= "";
45
46 --error ER_WRONG_VALUE_FOR_VAR
47 SET GLOBAL group_replication_flow_control_mode= "XXX";
48
49 --error ER_WRONG_VALUE_FOR_VAR
50 SET GLOBAL group_replication_flow_control_mode= -1;
51
52 --error ER_WRONG_VALUE_FOR_VAR
53 SET GLOBAL group_replication_flow_control_mode= 2;
54
55 # Valid values
56 SET GLOBAL group_replication_flow_control_mode= DISABLED;
57 --let $assert_text= group_replication_flow_control_mode is correct
58 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_flow_control_mode]" = "DISABLED"
59 --source include/assert.inc
60
61 SET GLOBAL group_replication_flow_control_mode= QUOTA;
62 --let $assert_text= group_replication_flow_control_mode is correct
63 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_flow_control_mode]" = "QUOTA"
64 --source include/assert.inc
65
66 SET GLOBAL group_replication_flow_control_mode= 0;
67 --let $assert_text= group_replication_flow_control_mode is correct
68 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_flow_control_mode]" = "DISABLED"
69 --source include/assert.inc
70
71 SET GLOBAL group_replication_flow_control_mode= 1;
72 --let $assert_text= group_replication_flow_control_mode is correct
73 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_flow_control_mode]" = "QUOTA"
74 --source include/assert.inc
75
76 --echo
77 --echo ############################################################
78 --echo # 2. Test group_replication_flow_control_certifier_threshold
79 --echo # option.
80 # Invalid values
81 --error ER_WRONG_TYPE_FOR_VAR
82 SET GLOBAL group_replication_flow_control_certifier_threshold= "";
83
84 # Truncates values
85 SET GLOBAL group_replication_flow_control_certifier_threshold= -1;
86 --let $assert_text= group_replication_flow_control_certifier_threshold is truncated
87 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_certifier_threshold] = 0
88 --source include/assert.inc
89
90 SET GLOBAL group_replication_flow_control_certifier_threshold= 2147483648;
91 --let $assert_text= group_replication_flow_control_certifier_threshold is truncated
92 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_certifier_threshold] = 2147483647
93 --source include/assert.inc
94
95 # Valid values
96 SET GLOBAL group_replication_flow_control_certifier_threshold= 1;
97 --let $assert_text= group_replication_flow_control_certifier_threshold is correct
98 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_certifier_threshold] = 1
99 --source include/assert.inc
100
101 SET GLOBAL group_replication_flow_control_certifier_threshold= 2147483647;
102 --let $assert_text= group_replication_flow_control_certifier_threshold is correct
103 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_certifier_threshold] = 2147483647
104 --source include/assert.inc
105
106 --echo
107 --echo ############################################################
108 --echo # 3. Test group_replication_flow_control_applier_threshold
109 --echo # option.
110 # Invalid values
111 --error ER_WRONG_TYPE_FOR_VAR
112 SET GLOBAL group_replication_flow_control_applier_threshold= "";
113
114 # Truncates values
115 SET GLOBAL group_replication_flow_control_applier_threshold= -1;
116 --let $assert_text= group_replication_flow_control_applier_threshold is truncated
117 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_applier_threshold] = 0
118 --source include/assert.inc
119
120 SET GLOBAL group_replication_flow_control_applier_threshold= 2147483648;
121 --let $assert_text= group_replication_flow_control_applier_threshold is truncated
122 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_applier_threshold] = 2147483647
123 --source include/assert.inc
124
125 # Valid values
126 SET GLOBAL group_replication_flow_control_applier_threshold= 1;
127 --let $assert_text= group_replication_flow_control_applier_threshold is correct
128 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_applier_threshold] = 1
129 --source include/assert.inc
130
131 SET GLOBAL group_replication_flow_control_applier_threshold= 2147483647;
132 --let $assert_text= group_replication_flow_control_applier_threshold is correct
133 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_applier_threshold] = 2147483647
134 --source include/assert.inc
135
136 --echo
137 --echo ############################################################
138 --echo # 4. Test group_replication_flow_control_min_quota
139 --echo # option.
140 # Invalid values
141 --error ER_WRONG_TYPE_FOR_VAR
142 SET GLOBAL group_replication_flow_control_min_quota= "";
143
144 # Truncates values
145 SET GLOBAL group_replication_flow_control_min_quota= -1;
146 --let $assert_text= group_replication_flow_control_min_quota is truncated
147 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_min_quota] = 0
148 --source include/assert.inc
149
150 SET GLOBAL group_replication_flow_control_min_quota= 2147483648;
151 --let $assert_text= group_replication_flow_control_min_quota is truncated
152 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_min_quota] = 2147483647
153 --source include/assert.inc
154
155 # Valid values
156 SET GLOBAL group_replication_flow_control_min_quota= 1;
157 --let $assert_text= group_replication_flow_control_min_quota is correct
158 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_min_quota] = 1
159 --source include/assert.inc
160
161 SET GLOBAL group_replication_flow_control_min_quota= 2147483647;
162 --let $assert_text= group_replication_flow_control_min_quota is correct
163 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_min_quota] = 2147483647
164 --source include/assert.inc
165
166 SET GLOBAL group_replication_flow_control_min_quota= 0;
167
168 --echo
169 --echo ############################################################
170 --echo # 5. Test group_replication_flow_control_min_recovery_quota
171 --echo # option.
172
173 # Invalid values
174 --error ER_WRONG_TYPE_FOR_VAR
175 SET GLOBAL group_replication_flow_control_min_recovery_quota= "";
176
177 # Truncates values
178 SET GLOBAL group_replication_flow_control_min_recovery_quota= -1;
179 --let $assert_text= group_replication_flow_control_min_recovery_quota is truncated
180 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_min_recovery_quota] = 0
181 --source include/assert.inc
182
183 SET GLOBAL group_replication_flow_control_min_recovery_quota= 2147483648;
184 --let $assert_text= group_replication_flow_control_min_recovery_quota is truncated
185 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_min_recovery_quota] = 2147483647
186 --source include/assert.inc
187
188 # Valid values
189 SET GLOBAL group_replication_flow_control_min_recovery_quota= 1;
190 --let $assert_text= group_replication_flow_control_min_recovery_quota is correct
191 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_min_recovery_quota] = 1
192 --source include/assert.inc
193
194 SET GLOBAL group_replication_flow_control_min_recovery_quota= 2147483647;
195 --let $assert_text= group_replication_flow_control_min_recovery_quota is correct
196 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_min_recovery_quota] = 2147483647
197 --source include/assert.inc
198
199 SET GLOBAL group_replication_flow_control_min_recovery_quota= 0;
200
201 --echo
202 --echo ############################################################
203 --echo # 6. Test group_replication_flow_control_max_quota
204 --echo # option.
205
206 # Invalid values
207 --error ER_WRONG_TYPE_FOR_VAR
208 SET GLOBAL group_replication_flow_control_max_quota= "";
209
210 # Truncates values
211 SET GLOBAL group_replication_flow_control_max_quota= -1;
212 --let $assert_text= group_replication_flow_control_max_quota is truncated
213 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_max_quota] = 0
214 --source include/assert.inc
215
216 SET GLOBAL group_replication_flow_control_max_quota= 2147483648;
217 --let $assert_text= group_replication_flow_control_max_quota is truncated
218 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_max_quota] = 2147483647
219 --source include/assert.inc
220
221 # Valid values
222 SET GLOBAL group_replication_flow_control_max_quota= 1;
223 --let $assert_text= group_replication_flow_control_max_quota is correct
224 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_max_quota] = 1
225 --source include/assert.inc
226
227 SET GLOBAL group_replication_flow_control_max_quota= 2147483647;
228 --let $assert_text= group_replication_flow_control_max_quota is correct
229 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_max_quota] = 2147483647
230 --source include/assert.inc
231
232 SET GLOBAL group_replication_flow_control_max_quota= 0;
233
234 --echo
235 --echo ############################################################
236 --echo # 7. Test group_replication_flow_control_member_quota_percent
237 --echo # option.
238
239 # Invalid values
240 --error ER_WRONG_TYPE_FOR_VAR
241 SET GLOBAL group_replication_flow_control_member_quota_percent= "";
242
243 # Truncates values
244 SET GLOBAL group_replication_flow_control_member_quota_percent= -1;
245 --let $assert_text= group_replication_flow_control_member_quota_percent is truncated
246 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_member_quota_percent] = 0
247 --source include/assert.inc
248
249 SET GLOBAL group_replication_flow_control_member_quota_percent= 101;
250 --let $assert_text= group_replication_flow_control_member_quota_percent is truncated
251 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_member_quota_percent] = 100
252 --source include/assert.inc
253
254 # Valid values
255 SET GLOBAL group_replication_flow_control_member_quota_percent= 1;
256 --let $assert_text= group_replication_flow_control_member_quota_percent is correct
257 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_member_quota_percent] = 1
258 --source include/assert.inc
259
260 SET GLOBAL group_replication_flow_control_member_quota_percent= 100;
261 --let $assert_text= group_replication_flow_control_member_quota_percent is correct
262 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_member_quota_percent] = 100
263 --source include/assert.inc
264
265 --echo
266 --echo ############################################################
267 --echo # 8. Test group_replication_flow_control_period option.
268
269 # Invalid values
270 --error ER_WRONG_TYPE_FOR_VAR
271 SET GLOBAL group_replication_flow_control_period= "";
272
273 # Truncates values
274 SET GLOBAL group_replication_flow_control_period= 0;
275 --let $assert_text= group_replication_flow_control_period is truncated
276 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_period] = 1
277 --source include/assert.inc
278
279 SET GLOBAL group_replication_flow_control_period= 61;
280 --let $assert_text= group_replication_flow_control_period is truncated
281 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_period] = 60
282 --source include/assert.inc
283
284 # Valid values
285 SET GLOBAL group_replication_flow_control_period= 1;
286 --let $assert_text= group_replication_flow_control_period is correct
287 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_period] = 1
288 --source include/assert.inc
289
290 SET GLOBAL group_replication_flow_control_period= 60;
291 --let $assert_text= group_replication_flow_control_period is correct
292 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_period] = 60
293 --source include/assert.inc
294
295 --echo
296 --echo ############################################################
297 --echo # 9. Test group_replication_flow_control_hold_percent
298 --echo # option.
299 --echo
300
301 # Invalid values
302 --error ER_WRONG_TYPE_FOR_VAR
303 SET GLOBAL group_replication_flow_control_hold_percent= "";
304
305 # Truncates values
306 SET GLOBAL group_replication_flow_control_hold_percent= -1;
307 --let $assert_text= group_replication_flow_control_hold_percent is truncated
308 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_hold_percent] = 0
309 --source include/assert.inc
310
311 SET GLOBAL group_replication_flow_control_hold_percent= 101;
312 --let $assert_text= group_replication_flow_control_hold_percent is truncated
313 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_hold_percent] = 100
314 --source include/assert.inc
315
316 # Valid values
317 SET GLOBAL group_replication_flow_control_hold_percent= 1;
318 --let $assert_text= group_replication_flow_control_hold_percent is correct
319 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_hold_percent] = 1
320 --source include/assert.inc
321
322 SET GLOBAL group_replication_flow_control_hold_percent= 100;
323 --let $assert_text= group_replication_flow_control_hold_percent is correct
324 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_hold_percent] = 100
325 --source include/assert.inc
326
327 --echo ############################################################
328 --echo # 10. Test group_replication_flow_control_release_percent
329 --echo # option.
330
331 # Invalid values
332 --error ER_WRONG_TYPE_FOR_VAR
333 SET GLOBAL group_replication_flow_control_release_percent= "";
334
335 # Truncates values
336 SET GLOBAL group_replication_flow_control_release_percent= -1;
337 --let $assert_text= group_replication_flow_control_release_percent is truncated
338 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_release_percent] = 0
339 --source include/assert.inc
340
341 SET GLOBAL group_replication_flow_control_release_percent= 1001;
342 --let $assert_text= group_replication_flow_control_release_percent is truncated
343 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_release_percent] = 1000
344 --source include/assert.inc
345
346 # Valid values
347 SET GLOBAL group_replication_flow_control_release_percent= 1;
348 --let $assert_text= group_replication_flow_control_release_percent is correct
349 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_release_percent] = 1
350 --source include/assert.inc
351
352 SET GLOBAL group_replication_flow_control_release_percent= 1000;
353 --let $assert_text= group_replication_flow_control_release_percent is correct
354 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_release_percent] = 1000
355 --source include/assert.inc
356
357 --echo
358 --echo ############################################################
359 --echo # 11. Test group_replication_flow_control_max_quota
360 --echo # option.
361 SET GLOBAL group_replication_flow_control_min_recovery_quota= 10;
362 SET GLOBAL group_replication_flow_control_min_quota= 10;
363 SET GLOBAL group_replication_flow_control_max_quota= 100;
364
365 --error 1231
366 SET GLOBAL group_replication_flow_control_min_quota= 1000;
367 --let $assert_text= group_replication_flow_control_min_quota cannot be larger than max_quota
368 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_min_quota] = 10
369 --source include/assert.inc
370
371 --error 1231
372 SET GLOBAL group_replication_flow_control_min_recovery_quota= 1000;
373 --let $assert_text= group_replication_flow_control_min_recovery_quota cannot be larger than max_quota
374 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_min_recovery_quota] = 10
375 --source include/assert.inc
376
377 --error 1231
378 SET GLOBAL group_replication_flow_control_max_quota= 1;
379 --let $assert_text= group_replication_flow_control_max_quota cannot be lower than min_quota or min_recovery_quota
380 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_max_quota] = 100
381 --source include/assert.inc
382
383 SET GLOBAL group_replication_flow_control_min_recovery_quota= 0;
384 SET GLOBAL group_replication_flow_control_min_quota= 0;
385 SET GLOBAL group_replication_flow_control_max_quota= 0;
386
387 --echo
388 --echo ############################################################
389 --echo # 12. Change all group_replication_flow_control options while
390 --echo # Group Replication is running.
391 --source include/start_and_bootstrap_group_replication.inc
392
393 SET GLOBAL group_replication_flow_control_mode= DISABLED;
394 --let $assert_text= group_replication_flow_control_mode is correct
395 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_flow_control_mode]" = "DISABLED"
396 --source include/assert.inc
397
398 SET GLOBAL group_replication_flow_control_mode= QUOTA;
399 --let $assert_text= group_replication_flow_control_mode is correct
400 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_flow_control_mode]" = "QUOTA"
401 --source include/assert.inc
402
403 SET GLOBAL group_replication_flow_control_certifier_threshold= 1000;
404 --let $assert_text= group_replication_flow_control_certifier_threshold is correct
405 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_certifier_threshold] = 1000
406 --source include/assert.inc
407
408 SET GLOBAL group_replication_flow_control_applier_threshold= 1000;
409 --let $assert_text= group_replication_flow_control_applier_threshold is correct
410 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_applier_threshold] = 1000
411 --source include/assert.inc
412
413 SET GLOBAL group_replication_flow_control_min_quota= 1000;
414 --let $assert_text= group_replication_flow_control_min_quota is correct
415 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_min_quota] = 1000
416 --source include/assert.inc
417
418 SET GLOBAL group_replication_flow_control_min_recovery_quota= 1000;
419 --let $assert_text= group_replication_flow_control_min_recovery_quota is correct
420 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_min_recovery_quota] = 1000
421 --source include/assert.inc
422
423 SET GLOBAL group_replication_flow_control_max_quota= 2000;
424 --let $assert_text= group_replication_flow_control_max_quota is correct
425 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_max_quota] = 2000
426 --source include/assert.inc
427
428 SET GLOBAL group_replication_flow_control_member_quota_percent= 50;
429 --let $assert_text= group_replication_flow_control_member_quota_percent is correct
430 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_member_quota_percent] = 50
431 --source include/assert.inc
432
433 SET GLOBAL group_replication_flow_control_period= 10;
434 --let $assert_text= group_replication_flow_control_period is correct
435 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_period] = 10
436 --source include/assert.inc
437
438 SET GLOBAL group_replication_flow_control_hold_percent= 15;
439 --let $assert_text= group_replication_flow_control_hold_percent is correct
440 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_hold_percent] = 15
441 --source include/assert.inc
442
443 SET GLOBAL group_replication_flow_control_release_percent= 150;
444 --let $assert_text= group_replication_flow_control_release_percent is correct
445 --let $assert_cond= [SELECT @@GLOBAL.group_replication_flow_control_release_percent] = 150
446 --source include/assert.inc
447
448 --echo
449 --echo ############################################################
450 --echo # 13. Set group_replication_flow_control options on command
451 --echo # line during server start and then start Group
452 --echo # Replication.
453
454 --let $rpl_connection_name= server2
455 --source include/rpl_connection.inc
456 --source include/start_group_replication.inc
457
458 set session sql_log_bin=0;
459 CALL mtr.add_suppression("group_replication_flow_control_min_quota cannot be larger than group_replication_flow_control_max_quota");
460 CALL mtr.add_suppression("group_replication_flow_control_min_recovery_quota cannot be larger than group_replication_flow_control_max_quota");
461 CALL mtr.add_suppression("group_replication_flow_control_max_quota cannot be smaller than group_replication_flow_control_min_quota or group_replication_flow_control_min_recovery_quota");
462 set session sql_log_bin=1;
463
464 --let $_group_replication_local_address= `SELECT @@GLOBAL.group_replication_local_address`
465 --let $_group_replication_group_seeds= `SELECT @@GLOBAL.group_replication_group_seeds`
466
467 --let $allow_rpl_inited= 1
468 --let $restart_parameters=restart:--group_replication_group_name=$group_replication_group_name --group_replication_local_address=$_group_replication_local_address --group_replication_group_seeds=$_group_replication_group_seeds --group_replication_flow_control_max_quota=10 --group_replication_flow_control_min_quota=20
469 --replace_result $_group_replication_local_address GROUP_REPLICATION_LOCAL_ADDRESS $_group_replication_group_seeds GROUP_REPLICATION_GROUP_SEEDS $group_replication_group_name GROUP_REPLICATION_GROUP_NAME
470 --source include/restart_mysqld.inc
471
472 --error ER_GROUP_REPLICATION_CONFIGURATION
473 START GROUP_REPLICATION;
474
475 --let $allow_rpl_inited= 1
476 --let $restart_parameters=restart:--group_replication_group_name=$group_replication_group_name --group_replication_local_address=$_group_replication_local_address --group_replication_group_seeds=$_group_replication_group_seeds --group_replication_flow_control_min_quota=20 --group_replication_flow_control_max_quota=10
477 --replace_result $_group_replication_local_address GROUP_REPLICATION_LOCAL_ADDRESS $_group_replication_group_seeds GROUP_REPLICATION_GROUP_SEEDS $group_replication_group_name GROUP_REPLICATION_GROUP_NAME
478 --source include/restart_mysqld.inc
479
480 --error ER_GROUP_REPLICATION_CONFIGURATION
481 START GROUP_REPLICATION;
482
483 --let $allow_rpl_inited= 1
484 --let $restart_parameters=restart:--group_replication_group_name=$group_replication_group_name --group_replication_local_address=$_group_replication_local_address --group_replication_group_seeds=$_group_replication_group_seeds --group_replication_flow_control_min_recovery_quota=20 --group_replication_flow_control_max_quota=10
485 --replace_result $_group_replication_local_address GROUP_REPLICATION_LOCAL_ADDRESS $_group_replication_group_seeds GROUP_REPLICATION_GROUP_SEEDS $group_replication_group_name GROUP_REPLICATION_GROUP_NAME
486 --source include/restart_mysqld.inc
487
488 --error ER_GROUP_REPLICATION_CONFIGURATION
489 START GROUP_REPLICATION;
490
491 --echo
492 --echo ############################################################
493 --echo # Clean up.
494
495 --let $allow_rpl_inited= 1
496 --let $restart_parameters=restart:--group_replication_group_name=$group_replication_group_name --group_replication_local_address=$_group_replication_local_address --group_replication_group_seeds=$_group_replication_group_seeds
497 --replace_result $_group_replication_local_address GROUP_REPLICATION_LOCAL_ADDRESS $_group_replication_group_seeds GROUP_REPLICATION_GROUP_SEEDS $group_replication_group_name GROUP_REPLICATION_GROUP_NAME
498 --source include/restart_mysqld.inc
499
500 --let $rpl_server_number= 2
501 --source include/rpl_reconnect.inc
502
503 --let $rpl_connection_name= server1
504 --source include/rpl_connection.inc
505
506 SET GLOBAL group_replication_flow_control_mode= @group_replication_flow_control_mode_save;
507 SET GLOBAL group_replication_flow_control_certifier_threshold= @group_replication_flow_control_certifier_threshold_save;
508 SET GLOBAL group_replication_flow_control_applier_threshold= @group_replication_flow_control_applier_threshold_save;
509
510 SET GLOBAL group_replication_flow_control_min_quota=@group_replication_flow_control_min_quota_save;
511 SET GLOBAL group_replication_flow_control_min_recovery_quota=@group_replication_flow_control_min_recovery_quota_save;
512 SET GLOBAL group_replication_flow_control_max_quota=@group_replication_flow_control_max_quota_save;
513 SET GLOBAL group_replication_flow_control_member_quota_percent=@group_replication_flow_control_member_quota_percent_save;
514 SET GLOBAL group_replication_flow_control_period=@group_replication_flow_control_period_save;
515 SET GLOBAL group_replication_flow_control_hold_percent=@group_replication_flow_control_hold_percent_save;
516 SET GLOBAL group_replication_flow_control_release_percent=@group_replication_flow_control_release_percent_save;
517
518 SET @@GLOBAL.DEBUG= @debug_saved;
519
520
521
522 --source include/group_replication_end.inc