Debian Codegraph @

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

raw
1
2 ################################################################################
3 # Base test to verify the default values of the group replication variables.
4 #
5 # Test:
6 # 0. The test requires one server.
7 # 1. Set global/session group replication variables to default.
8 # 2. Verify default values of the group replication variables.
9 # 3. Clean up.
10 ################################################################################
11
12 --let $group_replication_group_name= dddddddd-dddd-dddd-dddd-dddddddddddd
13 --source include/force_restart.inc
14 --source include/have_group_replication_plugin.inc
15 --let $rpl_skip_group_replication_start= 1
16 --source include/group_replication.inc
17
18 --let $rpl_connection_name= server1
19 --source include/rpl_connection.inc
20 SET @@GLOBAL.group_replication_ip_allowlist= "AUTOMATIC";
21 --source include/start_and_bootstrap_group_replication.inc
22
23 # Try set DEFAULT values while Group Replication is running.
24 --error ER_WRONG_VALUE_FOR_VAR
25 SET @@GLOBAL.group_replication_auto_increment_increment= default;
26 --error ER_WRONG_VALUE_FOR_VAR
27 SET @@GLOBAL.group_replication_compression_threshold= default;
28 --error ER_WRONG_VALUE_FOR_VAR
29 SET @@GLOBAL.group_replication_single_primary_mode= default;
30 --error ER_WRONG_VALUE_FOR_VAR
31 SET @@GLOBAL.group_replication_enforce_update_everywhere_checks= default;
32 --error ER_WRONG_VALUE_FOR_VAR
33 SET @@GLOBAL.group_replication_group_name= default;
34 --error ER_WRONG_VALUE_FOR_VAR
35 SET @@GLOBAL.group_replication_gtid_assignment_block_size= default;
36 --error ER_WRONG_VALUE_FOR_VAR
37 SET @@GLOBAL.group_replication_ip_allowlist= default;
38 SET @@GLOBAL.group_replication_communication_max_message_size= default;
39
40 --source include/stop_group_replication.inc
41
42 --echo # Take backup of group replication variables
43 --let $saved_gr_allow_local_lower_version_join = `SELECT @@GLOBAL.group_replication_allow_local_lower_version_join;`
44 --let $saved_gr_auto_increment_increment = `SELECT @@GLOBAL.group_replication_auto_increment_increment;`
45 --let $saved_gr_bootstrap_group = `SELECT @@GLOBAL.group_replication_bootstrap_group;`
46 --let $saved_gr_components_stop_timeout = `SELECT @@GLOBAL.group_replication_components_stop_timeout;`
47 --let $saved_gr_compression_threshold = `SELECT @@GLOBAL.group_replication_compression_threshold;`
48 --let $saved_gr_enforce_update_everywhere_checks = `SELECT @@GLOBAL.group_replication_enforce_update_everywhere_checks;`
49 --let $saved_gr_force_members = `SELECT @@GLOBAL.group_replication_force_members;`
50 --let $saved_gr_group_name = `SELECT @@GLOBAL.group_replication_group_name;`
51 --let $saved_gr_gtid_assignment_block_size = `SELECT @@GLOBAL.group_replication_gtid_assignment_block_size;`
52 --let $saved_gr_ip_allowlist = `SELECT @@GLOBAL.group_replication_ip_allowlist;`
53 --let $saved_gr_local_address = `SELECT @@GLOBAL.group_replication_local_address;`
54 --let $saved_gr_group_seeds = `SELECT @@GLOBAL.group_replication_group_seeds;`
55 --let $saved_gr_poll_spin_loops = `SELECT @@GLOBAL.group_replication_poll_spin_loops;`
56 --let $saved_gr_recovery_complete_at = `SELECT @@GLOBAL.group_replication_recovery_complete_at;`
57 --let $saved_gr_recovery_reconnect_interval = `SELECT @@GLOBAL.group_replication_recovery_reconnect_interval;`
58 --let $saved_gr_recovery_retry_count = `SELECT @@GLOBAL.group_replication_recovery_retry_count;`
59 --let $saved_gr_recovery_ssl_ca = `SELECT @@GLOBAL.group_replication_recovery_ssl_ca;`
60 --let $saved_gr_recovery_ssl_capath = `SELECT @@GLOBAL.group_replication_recovery_ssl_capath;`
61 --let $saved_gr_recovery_ssl_cert = `SELECT @@GLOBAL.group_replication_recovery_ssl_cert;`
62 --let $saved_gr_recovery_ssl_cipher = `SELECT @@GLOBAL.group_replication_recovery_ssl_cipher;`
63 --let $saved_gr_recovery_ssl_crl = `SELECT @@GLOBAL.group_replication_recovery_ssl_crl;`
64 --let $saved_gr_recovery_ssl_crlpath = `SELECT @@GLOBAL.group_replication_recovery_ssl_crlpath;`
65 --let $saved_gr_recovery_ssl_key = `SELECT @@GLOBAL.group_replication_recovery_ssl_key;`
66 --let $saved_gr_recovery_ssl_verify_server_cert = `SELECT @@GLOBAL.group_replication_recovery_ssl_verify_server_cert;`
67 --let $saved_gr_recovery_use_ssl = `SELECT @@GLOBAL.group_replication_recovery_use_ssl;`
68 --let $saved_gr_single_primary_mode = `SELECT @@GLOBAL.group_replication_single_primary_mode;`
69 --let $saved_gr_ssl_mode = `SELECT @@GLOBAL.group_replication_ssl_mode;`
70 --let $saved_gr_start_on_boot = `SELECT @@GLOBAL.group_replication_start_on_boot;`
71 --let $saved_gr_transaction_size_limit = `SELECT @@GLOBAL.group_replication_transaction_size_limit;`
72 --let $saved_gr_communication_debug_options = `SELECT @@GLOBAL.group_replication_communication_debug_options;`
73 --let $saved_gr_unreachable_majority_timeout = `SELECT @@GLOBAL.group_replication_unreachable_majority_timeout;`
74 --let $saved_gr_member_weight = `SELECT @@GLOBAL.group_replication_member_weight;`
75 --let $saved_gr_recovery_public_key_path = `SELECT @@GLOBAL.group_replication_recovery_public_key_path;`
76 --let $saved_gr_recovery_get_public_key = `SELECT @@GLOBAL.group_replication_recovery_get_public_key;`
77 --let $saved_gr_exit_state_action = `SELECT @@GLOBAL.group_replication_exit_state_action;`
78 --let $saved_gr_member_expel_timeout = `SELECT @@GLOBAL.group_replication_member_expel_timeout;`
79 --let $saved_gr_replication_consistency_g = `SELECT @@GLOBAL.group_replication_consistency;`
80 --let $saved_gr_replication_consistency_s = `SELECT @@SESSION.group_replication_consistency;`
81 --let $saved_gr_communication_max_message_size = `SELECT @@GLOBAL.group_replication_communication_max_message_size;`
82 --let $saved_gr_autorejoin_tries = `SELECT @@GLOBAL.group_replication_autorejoin_tries;`
83 --let $saved_gr_message_cache_size = `SELECT @@GLOBAL.group_replication_message_cache_size;`
84 --let $saved_gr_recovery_compression_algorithms = `SELECT @@GLOBAL.group_replication_recovery_compression_algorithms;`
85 --let $saved_gr_recovery_compression_level = `SELECT @@GLOBAL.group_replication_recovery_zstd_compression_level;`
86 --let $saved_gr_recovery_tls_version = `SELECT @@GLOBAL.group_replication_recovery_tls_version;`
87 --let $saved_gr_recovery_tls_ciphersuites = `SELECT @@GLOBAL.group_replication_recovery_tls_ciphersuites;`
88 --let $saved_gr_advertise_recovery_endpoints = `SELECT @@GLOBAL.group_replication_advertise_recovery_endpoints;`
89 --let $saved_gr_view_change_uuid = `SELECT @@GLOBAL.group_replication_view_change_uuid;`
90 --let $saved_gr_communication_stack = `SELECT @@GLOBAL.group_replication_communication_stack;`
91 --let $saved_gr_paxos_single_leader = `SELECT @@GLOBAL.group_replication_paxos_single_leader;`
92
93 # Total number of GR variables.
94 --let $total_gr_vars= 61
95
96 --echo #
97 --echo # Test Unit#1
98 --echo # Set global/session group replication variables to default.
99 --echo # Curently there are $total_gr_vars group replication variables.
100 --echo #
101
102 # Note: If a new GR variable is added or an old GR variable is removed, then
103 # update this testcase for the sanity check.
104 --let $assert_text= There are $total_gr_vars GR variables at present.
105 --let $assert_cond= "[SELECT COUNT(*) FROM performance_schema.global_variables WHERE VARIABLE_NAME LIKE \\'group_replication%\']" = $total_gr_vars
106 --source include/assert.inc
107
108 # Global variables
109 --error ER_WRONG_VALUE_FOR_VAR
110 SET @@GLOBAL.group_replication_auto_increment_increment= default;
111 --error ER_WRONG_VALUE_FOR_VAR
112 SET @@GLOBAL.group_replication_compression_threshold= default;
113 --error ER_WRONG_VALUE_FOR_VAR
114 SET @@GLOBAL.group_replication_single_primary_mode= default;
115 --error ER_WRONG_VALUE_FOR_VAR
116 SET @@GLOBAL.group_replication_enforce_update_everywhere_checks= default;
117 --error ER_WRONG_VALUE_FOR_VAR
118 SET @@GLOBAL.group_replication_group_name= default;
119 --error ER_WRONG_VALUE_FOR_VAR
120 SET @@GLOBAL.group_replication_gtid_assignment_block_size= default;
121 --error ER_WRONG_VALUE_FOR_VAR
122 SET @@GLOBAL.group_replication_ip_allowlist= default;
123
124 SET @@GLOBAL.group_replication_allow_local_lower_version_join= default;
125 SET @@GLOBAL.group_replication_bootstrap_group= default;
126 SET @@GLOBAL.group_replication_components_stop_timeout= default;
127 SET @@GLOBAL.group_replication_force_members= default;
128 SET @@GLOBAL.group_replication_local_address= default;
129 SET @@GLOBAL.group_replication_group_seeds= default;
130 SET @@GLOBAL.group_replication_poll_spin_loops= default;
131 SET @@GLOBAL.group_replication_recovery_complete_at= default;
132 SET @@GLOBAL.group_replication_recovery_reconnect_interval= default;
133 SET @@GLOBAL.group_replication_recovery_retry_count= default;
134 SET @@GLOBAL.group_replication_recovery_ssl_ca= default;
135 SET @@GLOBAL.group_replication_recovery_ssl_capath= default;
136 SET @@GLOBAL.group_replication_recovery_ssl_cert= default;
137 SET @@GLOBAL.group_replication_recovery_ssl_cipher= default;
138 SET @@GLOBAL.group_replication_recovery_ssl_crl= default;
139 SET @@GLOBAL.group_replication_recovery_ssl_crlpath= default;
140 SET @@GLOBAL.group_replication_recovery_ssl_key= default;
141 SET @@GLOBAL.group_replication_recovery_ssl_verify_server_cert= default;
142 SET @@GLOBAL.group_replication_recovery_use_ssl= default;
143 SET @@GLOBAL.group_replication_ssl_mode= default;
144 SET @@GLOBAL.group_replication_start_on_boot= default;
145 SET @@GLOBAL.group_replication_communication_debug_options= default;
146 SET @@GLOBAL.group_replication_transaction_size_limit= default;
147 SET @@GLOBAL.group_replication_unreachable_majority_timeout= default;
148 SET @@GLOBAL.group_replication_member_weight= default;
149 SET @@GLOBAL.group_replication_recovery_public_key_path= default;
150 SET @@GLOBAL.group_replication_recovery_get_public_key= default;
151 SET @@GLOBAL.group_replication_exit_state_action= default;
152 SET @@GLOBAL.group_replication_member_expel_timeout= default;
153 SET @@GLOBAL.group_replication_consistency= default;
154 SET @@GLOBAL.group_replication_communication_max_message_size= default;
155 SET @@GLOBAL.group_replication_autorejoin_tries= default;
156 SET @@GLOBAL.group_replication_message_cache_size= default;
157 SET @@GLOBAL.group_replication_recovery_compression_algorithms= default;
158 SET @@GLOBAL.group_replication_recovery_zstd_compression_level= default;
159 SET @@GLOBAL.group_replication_recovery_tls_version= default;
160 SET @@GLOBAL.group_replication_recovery_tls_ciphersuites= default;
161 SET @@GLOBAL.group_replication_advertise_recovery_endpoints = default;
162 SET @@GLOBAL.group_replication_view_change_uuid= default;
163 SET @@GLOBAL.group_replication_communication_stack = default;
164 SET @@GLOBAL.group_replication_paxos_single_leader = default;
165
166 # Session variables
167 SET @@SESSION.group_replication_consistency= default;
168
169 --echo #
170 --echo # Test Unit#2
171 --echo # Verify default values of the group replication variables.
172 --echo #
173
174 # group_replication_allow_local_lower_version_join
175 --let $assert_text= Default group_replication_allow_local_lower_version_join is OFF/0
176 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_allow_local_lower_version_join]" = 0
177 --source include/assert.inc
178
179 # group_replication_auto_increment_increment
180 --let $assert_text= Default group_replication_auto_increment_increment is 7
181 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_auto_increment_increment]" = 7
182 --source include/assert.inc
183
184 # group_replication_bootstrap_group
185 --let $assert_text= Default group_replication_bootstrap_group is OFF/0
186 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_bootstrap_group]" = 0
187 --source include/assert.inc
188
189 # group_replication_components_stop_timeout
190 --let $assert_text= Default group_replication_components_stop_timeout is 300
191 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_components_stop_timeout]" = 300
192 --source include/assert.inc
193
194 # group_replication_compression_threshold
195 --let $assert_text= Default group_replication_compression_threshold is 1000000
196 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_compression_threshold]" = 1000000
197 --source include/assert.inc
198
199 # group_replication_force_members
200 --let $assert_text= Default group_replication_force_members is ""(EMPTY)
201 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_force_members]" = ""
202 --source include/assert.inc
203
204 # group_replication_ip_allowlist
205 --let $assert_text= Default group_replication_ip_allowlist is AUTOMATIC
206 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_ip_allowlist]" = "AUTOMATIC"
207 --source include/assert.inc
208
209 # group_replication_local_address
210 --let $assert_text= Default group_replication_local_address is ""(EMPTY)
211 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_local_address]" = ""
212 --source include/assert.inc
213
214 # group_replication_group_seeds
215 --let $assert_text= Default group_replication_group_seeds is ""(EMPTY)
216 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_group_seeds]" = ""
217 --source include/assert.inc
218
219 # group_replication_poll_spin_loops
220 --let $assert_text= Default group_replication_poll_spin_loops is 0
221 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_poll_spin_loops]" = 0
222 --source include/assert.inc
223
224 # group_replication_recovery_complete_at
225 --let $assert_text= Default group_replication_recovery_complete_at is TRANSACTIONS_APPLIED
226 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_recovery_complete_at]" = "TRANSACTIONS_APPLIED"
227 --source include/assert.inc
228
229 # group_replication_recovery_reconnect_interval
230 --let $assert_text= Default group_replication_recovery_reconnect_interval is 60
231 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_recovery_reconnect_interval]" = 60
232 --source include/assert.inc
233
234 # group_replication_recovery_retry_count
235 --let $assert_text= Default group_replication_recovery_retry_count is 10
236 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_recovery_retry_count]" = 10
237 --source include/assert.inc
238
239 # group_replication_recovery_ssl_ca
240 --let $assert_text= Default group_replication_recovery_ssl_ca is ""(EMPTY)
241 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_recovery_ssl_ca]" = ""
242 --source include/assert.inc
243
244 # group_replication_recovery_ssl_capath
245 --let $assert_text= Default group_replication_recovery_ssl_capath is ""(EMPTY)
246 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_recovery_ssl_capath]" = ""
247 --source include/assert.inc
248
249 # group_replication_recovery_ssl_cert
250 --let $assert_text= Default group_replication_recovery_ssl_cert is ""(EMPTY)
251 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_recovery_ssl_cert]" = ""
252 --source include/assert.inc
253
254 # group_replication_recovery_ssl_cipher
255 --let $assert_text= Default group_replication_recovery_ssl_cipher is ""(EMPTY)
256 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_recovery_ssl_cipher]" = ""
257 --source include/assert.inc
258
259 # group_replication_recovery_ssl_crl
260 --let $assert_text= Default group_replication_recovery_ssl_crl is ""(EMPTY)
261 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_recovery_ssl_crl]" = ""
262 --source include/assert.inc
263
264 # group_replication_recovery_ssl_crlpath
265 --let $assert_text= Default group_replication_recovery_ssl_crlpath is ""(EMPTY)
266 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_recovery_ssl_crlpath]" = ""
267 --source include/assert.inc
268
269 # group_replication_recovery_ssl_key
270 --let $assert_text= Default group_replication_recovery_ssl_key is ""(EMPTY)
271 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_recovery_ssl_key]" = ""
272 --source include/assert.inc
273
274 # group_replication_recovery_ssl_verify_server_cert
275 --let $assert_text= Default group_replication_recovery_ssl_verify_server_cert is OFF/0
276 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_recovery_ssl_verify_server_cert]" = 0
277 --source include/assert.inc
278
279 # group_replication_recovery_use_ssl
280 --let $assert_text= Default group_replication_recovery_use_ssl is OFF/0
281 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_recovery_use_ssl]" = 0
282 --source include/assert.inc
283
284 # group_replication_ssl_mode
285 --let $assert_text= Default group_replication_ssl_mode is DISABLED
286 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_ssl_mode]" = "DISABLED"
287 --source include/assert.inc
288
289 # group_replication_start_on_boot
290 --let $assert_text= Default group_replication_start_on_boot is ON/1
291 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_start_on_boot]" = 1
292 --source include/assert.inc
293
294 # group_replication_transaction_size_limit
295 --let $assert_text= Default group_replication_transaction_size_limit is 150000000
296 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_transaction_size_limit]" = 150000000
297 --source include/assert.inc
298
299 # group_replication_communication_debug_options
300 --let $assert_text= Default group_replication_communication_debug_options is "GCS_DEBUG_NONE"
301 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_communication_debug_options]" = "GCS_DEBUG_NONE"
302 --source include/assert.inc
303
304 # group_replication_unreachable_majority_timeout
305 --let $assert_text= Default group_replication_unreachable_majority_timeout is 0
306 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_unreachable_majority_timeout]" = 0
307 --source include/assert.inc
308
309 # group_replication_member_weight
310 --let $assert_text= Default group_replication_member_weight is 50
311 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_member_weight]" = 50
312 --source include/assert.inc
313
314 #group_replication_recovery_public_key_path
315 --let $assert_text= Default group_replication_recovery_public_key_path is ""(EMPTY)
316 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_recovery_public_key_path]" = ""
317 --source include/assert.inc
318
319 #group_replication_recovery_get_public_key
320 --let $assert_text= Default group_replication_recovery_get_public_key is OFF/0
321 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_recovery_get_public_key]" = 0
322 --source include/assert.inc
323
324 #group_replication_exit_state_action
325 --let $assert_text= Default group_replication_exit_state_action is READ_ONLY
326 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_exit_state_action]" = "READ_ONLY"
327 --source include/assert.inc
328
329 # group_replication_member_expel_timeout
330 --let $assert_text= Default group_replication_member_expel_timeout is 5
331 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_member_expel_timeout]" = 5
332 --source include/assert.inc
333
334 # group_replication_consistency
335 --let $assert_text= Default group_replication_consistency is EVENTUAL
336 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_consistency]" = "EVENTUAL"
337 --source include/assert.inc
338
339 --let $assert_text= Default group_replication_consistency is EVENTUAL
340 --let $assert_cond= "[SELECT @@SESSION.group_replication_consistency]" = "EVENTUAL"
341 --source include/assert.inc
342
343 # group_replication_communication_max_message_size
344 --let $assert_text= Default group_replication_communication_max_message_size is 10485760
345 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_communication_max_message_size]" = 10485760
346 --source include/assert.inc
347
348 #group_replication_autorejoin_tries
349 --let $assert_text= Default group_replication_autorejoin_tries is 3
350 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_autorejoin_tries]" = 3
351 --source include/assert.inc
352
353 # group_replication_message_cache_size
354 --let $assert_text= Default group_replication_message_cache_size is 1073741824
355 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_message_cache_size]" = 1073741824
356 --source include/assert.inc
357
358 # group_replication_recovery_compression_algorithms
359 --let $assert_text= Default group_replication_recovery_compression_algorithms is "uncompressed"
360 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_recovery_compression_algorithms]" = "uncompressed"
361 --source include/assert.inc
362
363 # group_replication_recovery_zstd_compression_level
364 --let $assert_text= Default group_replication_recovery_zstd_compression_level is 3
365 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_recovery_zstd_compression_level]" = 3
366 --source include/assert.inc
367
368 # group_replication_recovery_tls_version
369 --let $assert_text= Default group_replication_recovery_tls_version is "TLSv1.2,TLSv1.3"
370 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_recovery_tls_version]" = "TLSv1.2,TLSv1.3"
371 --source include/assert.inc
372
373 # group_replication_recovery_tls_ciphersuites
374 --let $recovery_tls_ciphersuites= query_get_value(SELECT @@GLOBAL.group_replication_recovery_tls_ciphersuites, @@GLOBAL.group_replication_recovery_tls_ciphersuites, 1)
375 --let $assert_text= Default group_replication_recovery_tls_ciphersuites is NULL
376 --let $assert_cond= "$recovery_tls_ciphersuites" = "NULL"
377 --source include/assert.inc
378
379 # group_replication_advertise_recovery_endpoints
380 --let $assert_text= Default group_replication_advertise_recovery_endpoints is "DEFAULT"
381 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_advertise_recovery_endpoints]" = "DEFAULT"
382 --source include/assert.inc
383
384 # group_replication_view_change_uuid
385 --let $assert_text= Default group_replication_view_change_uuid is "AUTOMATIC"
386 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_view_change_uuid]" = "AUTOMATIC"
387 --source include/assert.inc
388
389 # group_replication_communication_stack
390 --let $assert_text= Default group_replication_communication_stack is XCom
391 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_communication_stack]" = "XCom"
392 --source include/assert.inc
393
394 # group_replication_paxos_single_leader
395 --let $assert_text= Default group_replication_paxos_single_leader is 0
396 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_paxos_single_leader]" = 0
397 --source include/assert.inc
398
399
400 --echo #
401 --echo # Clean up
402 --echo #
403
404 # No need to print this into result file.
405
406 --disable_query_log
407 --eval SET @@GLOBAL.group_replication_allow_local_lower_version_join= $saved_gr_allow_local_lower_version_join
408 --eval SET @@GLOBAL.group_replication_auto_increment_increment= $saved_gr_auto_increment_increment
409 --eval SET @@GLOBAL.group_replication_bootstrap_group= $saved_gr_bootstrap_group
410 --eval SET @@GLOBAL.group_replication_components_stop_timeout= $saved_gr_components_stop_timeout
411 --eval SET @@GLOBAL.group_replication_compression_threshold= $saved_gr_compression_threshold
412 --eval SET @@GLOBAL.group_replication_single_primary_mode= $saved_gr_single_primary_mode
413 --eval SET @@GLOBAL.group_replication_enforce_update_everywhere_checks= $saved_gr_enforce_update_everywhere_checks
414 --eval SET @@GLOBAL.group_replication_force_members= "$saved_gr_force_members"
415 --eval SET @@GLOBAL.group_replication_group_name= "$saved_gr_group_name"
416 --eval SET @@GLOBAL.group_replication_gtid_assignment_block_size= $saved_gr_gtid_assignment_block_size
417 --eval SET @@GLOBAL.group_replication_ip_allowlist= "$saved_gr_ip_allowlist"
418 --eval SET @@GLOBAL.group_replication_local_address= "$saved_gr_local_address"
419 --eval SET @@GLOBAL.group_replication_group_seeds= "$saved_gr_group_seeds"
420 --eval SET @@GLOBAL.group_replication_poll_spin_loops= $saved_gr_poll_spin_loops
421 --eval SET @@GLOBAL.group_replication_recovery_complete_at= "$saved_gr_recovery_complete_at"
422 --eval SET @@GLOBAL.group_replication_recovery_reconnect_interval= $saved_gr_recovery_reconnect_interval
423 --eval SET @@GLOBAL.group_replication_recovery_retry_count= $saved_gr_recovery_retry_count
424 --eval SET @@GLOBAL.group_replication_recovery_ssl_ca= "$saved_gr_recovery_ssl_ca"
425 --eval SET @@GLOBAL.group_replication_recovery_ssl_capath= "$saved_gr_recovery_ssl_capath"
426 --eval SET @@GLOBAL.group_replication_recovery_ssl_cert= "$saved_gr_recovery_ssl_cert"
427 --eval SET @@GLOBAL.group_replication_recovery_ssl_cipher= "$saved_gr_recovery_ssl_cipher"
428 --eval SET @@GLOBAL.group_replication_recovery_ssl_crl= "$saved_gr_recovery_ssl_crl"
429 --eval SET @@GLOBAL.group_replication_recovery_ssl_crlpath= "$saved_gr_recovery_ssl_crlpath"
430 --eval SET @@GLOBAL.group_replication_recovery_ssl_key= "$saved_gr_recovery_ssl_key"
431 --eval SET @@GLOBAL.group_replication_recovery_ssl_verify_server_cert= $saved_gr_recovery_ssl_verify_server_cert
432 --eval SET @@GLOBAL.group_replication_recovery_use_ssl= $saved_gr_recovery_use_ssl
433 --eval SET @@GLOBAL.group_replication_ssl_mode= $saved_gr_ssl_mode
434 --eval SET @@GLOBAL.group_replication_start_on_boot= $saved_gr_start_on_boot
435 --eval SET @@GLOBAL.group_replication_transaction_size_limit= $saved_gr_transaction_size_limit
436 --eval SET @@GLOBAL.group_replication_communication_debug_options= "$saved_gr_communication_debug_options"
437 --eval SET @@GLOBAL.group_replication_unreachable_majority_timeout= $saved_gr_unreachable_majority_timeout
438 --eval SET @@GLOBAL.group_replication_member_weight= $saved_gr_member_weight
439 --eval SET @@GLOBAL.group_replication_recovery_public_key_path= "$saved_gr_recovery_public_key_path"
440 --eval SET @@GLOBAL.group_replication_recovery_get_public_key= $saved_gr_recovery_get_public_key
441 --eval SET @@GLOBAL.group_replication_exit_state_action= $saved_gr_exit_state_action
442 --eval SET @@GLOBAL.group_replication_member_expel_timeout= $saved_gr_member_expel_timeout
443 --eval SET @@GLOBAL.group_replication_consistency= "$saved_gr_replication_consistency_g"
444 --eval SET @@GLOBAL.group_replication_autorejoin_tries= $saved_gr_autorejoin_tries
445 --eval SET @@SESSION.group_replication_consistency= "$saved_gr_replication_consistency_s"
446 --eval SET @@GLOBAL.group_replication_communication_max_message_size= $saved_gr_communication_max_message_size
447 --eval SET @@GLOBAL.group_replication_message_cache_size= $saved_gr_message_cache_size
448 --eval SET @@GLOBAL.group_replication_recovery_compression_algorithms= "$saved_gr_recovery_compression_algorithms"
449 --eval SET @@GLOBAL.group_replication_recovery_zstd_compression_level= $saved_gr_recovery_compression_level
450 --eval SET @@GLOBAL.group_replication_recovery_tls_version= "$saved_gr_recovery_tls_version"
451 --eval SET @@GLOBAL.group_replication_recovery_tls_ciphersuites= "$saved_gr_recovery_tls_ciphersuites"
452 --eval SET @@GLOBAL.group_replication_advertise_recovery_endpoints= "$saved_gr_advertise_recovery_endpoints"
453 --eval SET @@GLOBAL.group_replication_view_change_uuid= "$saved_gr_view_change_uuid"
454 --eval SET @@GLOBAL.group_replication_communication_stack= "$saved_gr_communication_stack"
455 --eval SET @@GLOBAL.group_replication_paxos_single_leader= $saved_gr_paxos_single_leader
456 --enable_query_log
457
458 --let $total_gr_vars=
459
460 --source include/group_replication_end.inc