Debian Codegraph @

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

raw
1 #######################################################################################
2 # Basic test to check the consistency of the values of GLOBAL and SESSION GR VARIABLES.
3 #
4 # Test:
5 # 0. This test requires one server.
6 # 1. Basic check on number of GR variables.
7 # 2. Verify group replication related variables at GLOBAL scope.
8 # 3. Verify group replication related variables at SESSION scope.
9 # 4. Verify values of GLOBAL and SESSION variables using below commands:-
10 # - SHOW GLOBAL VARIABLES LIKE 'group_replication_..'
11 # - SHOW SESSION VARIABLES LIKE 'group_replication_..'
12 # - SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=
13 # 'group_replication..'
14 # - SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=
15 # 'group_replication..'
16 # 5. Clean-up
17 #######################################################################################
18
19 --source include/have_group_replication_xcom_communication_stack.inc
20 --source include/big_test.inc
21 --source include/force_restart.inc
22
23 --let $group_replication_group_name= aaaaaaaa-cccc-bbbb-cccc-aaaaaaaaaaaa
24 --source include/have_group_replication_plugin.inc
25 --let $rpl_skip_group_replication_start= 1
26 --source include/group_replication.inc
27
28 --let $rpl_connection_name= server1
29 --source include/rpl_connection.inc
30 --source include/start_and_bootstrap_group_replication.inc
31 --source include/stop_group_replication.inc
32
33 --let $gr_var_count= 61
34 --echo
35 --echo # Test#1: Basic check that there are $gr_var_count GR variables.
36
37 # Note: If a new GR variable is added or an old GR variable is removed, then
38 # update this testcase for the sanity check.
39 --let $assert_text= There are $gr_var_count GR variables at present.
40 --let $assert_cond= "[SELECT COUNT(*) FROM performance_schema.global_variables WHERE VARIABLE_NAME LIKE \\'group_replication%\']" = $gr_var_count
41 --source include/assert.inc
42
43 # Take backup of GR variables
44 --disable_query_log
45 --let $saved_gr_allow_local_lower_version_join = `SELECT @@GLOBAL.group_replication_allow_local_lower_version_join;`
46 --let $saved_gr_auto_increment_increment = `SELECT @@GLOBAL.group_replication_auto_increment_increment;`
47 --let $saved_gr_bootstrap_group = `SELECT @@GLOBAL.group_replication_bootstrap_group;`
48 --let $saved_gr_components_stop_timeout = `SELECT @@GLOBAL.group_replication_components_stop_timeout;`
49 --let $saved_gr_compression_threshold = `SELECT @@GLOBAL.group_replication_compression_threshold;`
50 --let $saved_gr_enforce_update_everywhere_checks = `SELECT @@GLOBAL.group_replication_enforce_update_everywhere_checks;`
51 --let $saved_gr_force_members = `SELECT @@GLOBAL.group_replication_force_members;`
52 --let $saved_gr_group_name = `SELECT @@GLOBAL.group_replication_group_name;`
53 --let $saved_gr_gtid_assignment_block_size = `SELECT @@GLOBAL.group_replication_gtid_assignment_block_size;`
54 --let $saved_gr_ip_allowlist = `SELECT @@GLOBAL.group_replication_ip_allowlist;`
55 --let $saved_gr_local_address = `SELECT @@GLOBAL.group_replication_local_address;`
56 --let $saved_gr_group_seeds = `SELECT @@GLOBAL.group_replication_group_seeds;`
57 --let $saved_gr_poll_spin_loops = `SELECT @@GLOBAL.group_replication_poll_spin_loops;`
58 --let $saved_gr_recovery_complete_at = `SELECT @@GLOBAL.group_replication_recovery_complete_at;`
59 --let $saved_gr_recovery_reconnect_interval = `SELECT @@GLOBAL.group_replication_recovery_reconnect_interval;`
60 --let $saved_gr_recovery_retry_count = `SELECT @@GLOBAL.group_replication_recovery_retry_count;`
61 --let $saved_gr_recovery_ssl_ca = `SELECT @@GLOBAL.group_replication_recovery_ssl_ca;`
62 --let $saved_gr_recovery_ssl_capath = `SELECT @@GLOBAL.group_replication_recovery_ssl_capath;`
63 --let $saved_gr_recovery_ssl_cert = `SELECT @@GLOBAL.group_replication_recovery_ssl_cert;`
64 --let $saved_gr_recovery_ssl_cipher = `SELECT @@GLOBAL.group_replication_recovery_ssl_cipher;`
65 --let $saved_gr_recovery_ssl_crl = `SELECT @@GLOBAL.group_replication_recovery_ssl_crl;`
66 --let $saved_gr_recovery_ssl_crlpath = `SELECT @@GLOBAL.group_replication_recovery_ssl_crlpath;`
67 --let $saved_gr_recovery_ssl_key = `SELECT @@GLOBAL.group_replication_recovery_ssl_key;`
68 --let $saved_gr_recovery_ssl_verify_server_cert = `SELECT @@GLOBAL.group_replication_recovery_ssl_verify_server_cert;`
69 --let $saved_gr_single_primary_mode = `SELECT @@GLOBAL.group_replication_single_primary_mode;`
70 --let $saved_gr_recovery_use_ssl = `SELECT @@GLOBAL.group_replication_recovery_use_ssl;`
71 --let $saved_gr_ssl_mode = `SELECT @@GLOBAL.group_replication_ssl_mode;`
72 --let $saved_gr_start_on_boot = `SELECT @@GLOBAL.group_replication_start_on_boot;`
73 --let $saved_gr_transaction_size_limit = `SELECT @@GLOBAL.group_replication_transaction_size_limit;`
74 --let $saved_gr_communication_debug_options = `SELECT @@GLOBAL.group_replication_communication_debug_options;`
75 --let $saved_gr_unreachable_majority_timeout = `SELECT @@GLOBAL.group_replication_unreachable_majority_timeout`
76 --let $saved_gr_member_weight = `SELECT @@GLOBAL.group_replication_member_weight;`
77 --let $saved_gr_recovery_public_key_path = `SELECT @@GLOBAL.group_replication_recovery_public_key_path;`
78 --let $saved_gr_recovery_get_public_key = `SELECT @@GLOBAL.group_replication_recovery_get_public_key;`
79 --let $saved_gr_exit_state_action = `SELECT @@GLOBAL.group_replication_exit_state_action;`
80 --let $saved_gr_member_expel_timeout = `SELECT @@GLOBAL.group_replication_member_expel_timeout`
81 --let $saved_gr_consistency = `SELECT @@GLOBAL.group_replication_consistency`
82 --let $saved_gr_communication_max_message_size = `SELECT @@GLOBAL.group_replication_communication_max_message_size`
83 --let $saved_gr_autorejoin_tries = `SELECT @@GLOBAL.group_replication_autorejoin_tries`
84 --let $saved_gr_message_cache_size = `SELECT @@GLOBAL.group_replication_message_cache_size`
85 --let $saved_gr_clone_threshold = `SELECT @@GLOBAL.group_replication_clone_threshold`
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_view_change_uuid = `SELECT @@GLOBAL.group_replication_view_change_uuid`
89 --let $saved_gr_paxos_single_leader = `SELECT @@GLOBAL.group_replication_paxos_single_leader`
90 --enable_query_log
91
92
93 --echo
94 --echo # Test#2: Verify group replication related variables at GLOBAL scope.
95
96 # Following GR variables cannot be set at SESSION level.
97 --error ER_GLOBAL_VARIABLE
98 SET @@SESSION.group_replication_allow_local_lower_version_join= 1;
99 --error ER_GLOBAL_VARIABLE
100 SET @@SESSION.group_replication_auto_increment_increment= 7;
101 --error ER_GLOBAL_VARIABLE
102 SET @@SESSION.group_replication_bootstrap_group= 1;
103 --error ER_GLOBAL_VARIABLE
104 SET @@SESSION.group_replication_components_stop_timeout= 1;
105 --error ER_GLOBAL_VARIABLE
106 SET @@SESSION.group_replication_compression_threshold= 1;
107 --error ER_GLOBAL_VARIABLE
108 SET @@SESSION.group_replication_enforce_update_everywhere_checks= 1;
109 --error ER_GLOBAL_VARIABLE
110 SET @@SESSION.group_replication_force_members= "";
111 --error ER_GLOBAL_VARIABLE
112 SET @@SESSION.group_replication_group_name= "aaaaaaaa-cccc-bbbb-cccc-aaaaaaaaaaaa";
113 --error ER_GLOBAL_VARIABLE
114 SET @@SESSION.group_replication_gtid_assignment_block_size= 1;
115 --error ER_GLOBAL_VARIABLE
116 SET @@SESSION.group_replication_ip_allowlist= "AUTOMATIC";
117 --error ER_GLOBAL_VARIABLE
118 SET @@SESSION.group_replication_local_address= "";
119 --error ER_GLOBAL_VARIABLE
120 SET @@SESSION.group_replication_group_seeds= "";
121 --error ER_GLOBAL_VARIABLE
122 SET @@SESSION.group_replication_poll_spin_loops= 1;
123 --error ER_GLOBAL_VARIABLE
124 SET @@SESSION.group_replication_recovery_complete_at= "TRANSACTIONS_APPLIED";
125 --error ER_GLOBAL_VARIABLE
126 SET @@SESSION.group_replication_recovery_reconnect_interval= 10;
127 --error ER_GLOBAL_VARIABLE
128 SET @@SESSION.group_replication_recovery_retry_count= 1;
129 --error ER_GLOBAL_VARIABLE
130 SET @@SESSION.group_replication_recovery_ssl_ca= "";
131 --error ER_GLOBAL_VARIABLE
132 SET @@SESSION.group_replication_recovery_ssl_capath= "";
133 --error ER_GLOBAL_VARIABLE
134 SET @@SESSION.group_replication_recovery_ssl_cert= "";
135 --error ER_GLOBAL_VARIABLE
136 SET @@SESSION.group_replication_recovery_ssl_cipher= "";
137 --error ER_GLOBAL_VARIABLE
138 SET @@SESSION.group_replication_recovery_ssl_crl= "";
139 --error ER_GLOBAL_VARIABLE
140 SET @@SESSION.group_replication_recovery_ssl_crlpath= "";
141 --error ER_GLOBAL_VARIABLE
142 SET @@SESSION.group_replication_recovery_ssl_key= "";
143 --error ER_GLOBAL_VARIABLE
144 SET @@SESSION.group_replication_recovery_ssl_verify_server_cert= 1;
145 --error ER_GLOBAL_VARIABLE
146 SET @@SESSION.group_replication_recovery_use_ssl= 1;
147 --error ER_GLOBAL_VARIABLE
148 SET @@SESSION.group_replication_single_primary_mode= 0;
149 --error ER_GLOBAL_VARIABLE
150 SET @@SESSION.group_replication_ssl_mode= "REQUIRED";
151 --error ER_GLOBAL_VARIABLE
152 SET @@SESSION.group_replication_start_on_boot= 1;
153 --error ER_GLOBAL_VARIABLE
154 SET @@SESSION.group_replication_transaction_size_limit= 10240;
155 --error ER_GLOBAL_VARIABLE
156 SET @@SESSION.group_replication_communication_debug_options= "";
157 --error ER_GLOBAL_VARIABLE
158 SET @@SESSION.group_replication_unreachable_majority_timeout= 10240;
159 --error ER_GLOBAL_VARIABLE
160 SET @@SESSION.group_replication_member_weight= 80;
161 --error ER_GLOBAL_VARIABLE
162 SET @@SESSION.group_replication_recovery_public_key_path= "";
163 --error ER_GLOBAL_VARIABLE
164 SET @@SESSION.group_replication_recovery_get_public_key= 1;
165 --error ER_GLOBAL_VARIABLE
166 SET @@SESSION.group_replication_exit_state_action= "READ_ONLY";
167 --error ER_GLOBAL_VARIABLE
168 SET @@SESSION.group_replication_member_expel_timeout= 120;
169 --error ER_GLOBAL_VARIABLE
170 SET @@SESSION.group_replication_communication_max_message_size= 2048;
171 --error ER_GLOBAL_VARIABLE
172 SET @@SESSION.group_replication_autorejoin_tries = 3;
173 --error ER_GLOBAL_VARIABLE
174 SET @@SESSION.group_replication_message_cache_size= 10000000000;
175 --error ER_GLOBAL_VARIABLE
176 SET @@SESSION.group_replication_clone_threshold= 1;
177 --error ER_GLOBAL_VARIABLE
178 SET @@SESSION.group_replication_recovery_tls_version= "";
179 --error ER_GLOBAL_VARIABLE
180 SET @@SESSION.group_replication_recovery_tls_ciphersuites= "";
181 --error ER_GLOBAL_VARIABLE
182 SET @@SESSION.group_replication_view_change_uuid= "AUTOMATIC";
183 --error ER_GLOBAL_VARIABLE
184 SET @@SESSION.group_replication_paxos_single_leader= 1;
185
186 # Set values to GLOBAL GR variables to test further.
187 --disable_query_log
188 SET GLOBAL group_replication_allow_local_lower_version_join= ON;
189 SET GLOBAL group_replication_auto_increment_increment= 5;
190 SET GLOBAL group_replication_bootstrap_group= ON;
191 SET GLOBAL group_replication_components_stop_timeout= 10;
192 SET GLOBAL group_replication_compression_threshold= 10;
193 SET GLOBAL group_replication_enforce_update_everywhere_checks= ON;
194 SET GLOBAL group_replication_force_members= "";
195 SET GLOBAL group_replication_group_name= "aaaaaaaa-cccc-bbbb-cccc-aaaaaaaaaaaa";
196 SET GLOBAL group_replication_gtid_assignment_block_size= 2;
197 SET GLOBAL group_replication_ip_allowlist= "AUTOMATIC";
198 eval SET GLOBAL group_replication_local_address= "$saved_gr_local_address";
199 eval SET GLOBAL group_replication_group_seeds= "$saved_gr_group_seeds";
200 SET GLOBAL group_replication_poll_spin_loops= 10;
201 SET GLOBAL group_replication_recovery_complete_at= "TRANSACTIONS_CERTIFIED";
202 SET GLOBAL group_replication_recovery_reconnect_interval= 20;
203 SET GLOBAL group_replication_recovery_retry_count= 5;
204 eval SET GLOBAL group_replication_recovery_ssl_ca= '$MYSQL_TEST_DIR/std_data/cacert.pem';
205 eval SET GLOBAL group_replication_recovery_ssl_capath= '';
206 eval SET GLOBAL group_replication_recovery_ssl_cert= '$MYSQL_TEST_DIR/std_data/client-cert.pem';
207 SET GLOBAL group_replication_recovery_ssl_cipher= 'ECDHE-RSA-AES128-GCM-SHA256';
208 eval SET GLOBAL group_replication_recovery_ssl_crlpath= '';
209 eval SET GLOBAL group_replication_recovery_ssl_key= '$MYSQL_TEST_DIR/std_data/client-key.pem';
210 SET GLOBAl group_replication_recovery_ssl_verify_server_cert= ON;
211 SET GLOBAl group_replication_single_primary_mode= OFF;
212 SET GLOBAL group_replication_recovery_use_ssl= ON;
213 SET GLOBAL group_replication_ssl_mode= "REQUIRED";
214 SET GLOBAL group_replication_start_on_boot= ON;
215 SET GLOBAL group_replication_transaction_size_limit= 100000;
216 SET GLOBAL group_replication_communication_debug_options= "GCS_DEBUG_ALL";
217 SET GLOBAL group_replication_unreachable_majority_timeout= 100000;
218 SET GLOBAL group_replication_member_weight= 70;
219 eval SET GLOBAL group_replication_recovery_public_key_path= '$MYSQL_TEST_DIR/std_data/rsa_public_key.pem';
220 SET GLOBAL group_replication_recovery_get_public_key= ON;
221 SET GLOBAL group_replication_exit_state_action= "READ_ONLY";
222 SET GLOBAL group_replication_member_expel_timeout= 1000;
223 SET GLOBAL group_replication_consistency= "EVENTUAL";
224 SET GLOBAL group_replication_communication_max_message_size= 2048;
225 SET GLOBAL group_replication_autorejoin_tries = 3;
226 SET GLOBAL group_replication_message_cache_size= 2000000000;
227 SET GLOBAL group_replication_clone_threshold= 1;
228 SET GLOBAL group_replication_recovery_tls_version= "";
229 SET GLOBAL group_replication_recovery_tls_ciphersuites= "";
230 SET GLOBAL group_replication_view_change_uuid= "aaaaaaaa-cccc-bbbb-dddd-eeeeeeeeeeee";
231 SET GLOBAL group_replication_paxos_single_leader= 1;
232 --enable_query_log
233
234
235 --echo
236 --echo # Test#3: Verify group replication related variables at SESSION scope.
237
238 # Following GR variable(s) can be set at SESSION level.
239 SET @@SESSION.group_replication_consistency= "EVENTUAL"; # Currently, there is only one.
240
241 # clean up session variables
242 SET @@SESSION.group_replication_consistency= DEFAULT;
243
244
245 --echo
246 --echo # Test#4: Verify GLOBAL and SESSION variables
247 # Start GR
248 --source include/start_group_replication.inc
249
250 # Setting this value after start to avoid conflixts when using MySQL stack.
251 SET GLOBAL group_replication_recovery_ssl_crl= 'crl-client-revoked.crl';
252 SET GLOBAL group_replication_recovery_tls_ciphersuites= "";
253
254 # Assert the values of the variables set
255 # group_replication_allow_local_lower_version_join
256 --let $assert_text= Verify GLOBAL value of group_replication_allow_local_lower_version_join
257 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_allow_local_lower_version_join\', Value, 1]" = "ON"
258 --source include/assert.inc
259
260 --let $assert_text= Verify GLOBAL value of group_replication_allow_local_lower_version_join
261 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_allow_local_lower_version_join\', VARIABLE_VALUE, 1]" = "ON"
262 --source include/assert.inc
263
264 --let $assert_text= Verify SESSION value of group_replication_allow_local_lower_version_join
265 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_allow_local_lower_version_join\', Value, 1]" = "ON"
266 --source include/assert.inc
267
268 --let $assert_text= Verify SESSION value of group_replication_allow_local_lower_version_join
269 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_allow_local_lower_version_join\', VARIABLE_VALUE, 1]" = "ON"
270 --source include/assert.inc
271
272 # group_replication_auto_increment_increment
273 --let $assert_text= Verify GLOBAL value of group_replication_auto_increment_increment
274 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_auto_increment_increment\', Value, 1]" = 5
275 --source include/assert.inc
276
277 --let $assert_text= Verify GLOBAL value of group_replication_auto_increment_increment
278 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_auto_increment_increment\', VARIABLE_VALUE, 1]" = 5
279 --source include/assert.inc
280
281 --let $assert_text= Verify SESSION value of group_replication_auto_increment_increment
282 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_auto_increment_increment\', Value, 1]" = 5
283 --source include/assert.inc
284
285 --let $assert_text= Verify SESSION value of group_replication_auto_increment_increment
286 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_auto_increment_increment\', VARIABLE_VALUE, 1]" = 5
287 --source include/assert.inc
288
289 # group_replication_bootstrap_group
290 --let $assert_text= Verify GLOBAL value of group_replication_bootstrap_group
291 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_bootstrap_group\', Value, 1]" = "ON"
292 --source include/assert.inc
293
294 --let $assert_text= Verify GLOBAL value of group_replication_bootstrap_group
295 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_bootstrap_group\', VARIABLE_VALUE, 1]" = "ON"
296 --source include/assert.inc
297
298 --let $assert_text= Verify SESSION value of group_replication_bootstrap_group
299 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_bootstrap_group\', Value, 1]" = "ON"
300 --source include/assert.inc
301
302 --let $assert_text= Verify SESSION value of group_replication_bootstrap_group
303 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_bootstrap_group\', VARIABLE_VALUE, 1]" = "ON"
304 --source include/assert.inc
305
306 # group_replication_components_stop_timeout
307 --let $assert_text= Verify GLOBAL value of group_replication_components_stop_timeout
308 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_components_stop_timeout\', Value, 1]" = 10
309 --source include/assert.inc
310
311 --let $assert_text= Verify GLOBAL value of group_replication_components_stop_timeout
312 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_components_stop_timeout\', VARIABLE_VALUE, 1]" = 10
313 --source include/assert.inc
314
315 --let $assert_text= Verify SESSION value of group_replication_components_stop_timeout
316 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_components_stop_timeout\', Value, 1]" = 10
317 --source include/assert.inc
318
319 --let $assert_text= Verify SESSION value of group_replication_components_stop_timeout
320 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_components_stop_timeout\', VARIABLE_VALUE, 1]" = 10
321 --source include/assert.inc
322
323 # group_replication_compression_threshold
324 --let $assert_text= Verify GLOBAL value of group_replication_compression_threshold
325 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_compression_threshold\', Value, 1]" = 10
326 --source include/assert.inc
327
328 --let $assert_text= Verify GLOBAL value of group_replication_compression_threshold
329 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_compression_threshold\', VARIABLE_VALUE, 1]" = 10
330 --source include/assert.inc
331
332 --let $assert_text= Verify SESSION value of group_replication_compression_threshold
333 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_compression_threshold\', Value, 1]" = 10
334 --source include/assert.inc
335
336 --let $assert_text= Verify SESSION value of group_replication_compression_threshold
337 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_compression_threshold\', VARIABLE_VALUE, 1]" = 10
338 --source include/assert.inc
339
340 # group_replication_enforce_update_everywhere_checks
341 --let $assert_text= Verify GLOBAL value of group_replication_enforce_update_everywhere_checks
342 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_enforce_update_everywhere_checks\', Value, 1]" = "ON"
343 --source include/assert.inc
344
345 --let $assert_text= Verify GLOBAL value of group_replication_enforce_update_everywhere_checks
346 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_enforce_update_everywhere_checks\', VARIABLE_VALUE, 1]" = "ON"
347 --source include/assert.inc
348
349 --let $assert_text= Verify SESSION value of group_replication_enforce_update_everywhere_checks
350 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_enforce_update_everywhere_checks\', Value, 1]" = "ON"
351 --source include/assert.inc
352
353 --let $assert_text= Verify SESSION value of group_replication_enforce_update_everywhere_checks
354 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_enforce_update_everywhere_checks\', VARIABLE_VALUE, 1]" = "ON"
355 --source include/assert.inc
356
357 # group_replication_force_members
358 --let $assert_text= Verify GLOBAL value of group_replication_force_members
359 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_force_members\', Value, 1]" = ""
360 --source include/assert.inc
361
362 --let $assert_text= Verify GLOBAL value of group_replication_force_members
363 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_force_members\', VARIABLE_VALUE, 1]" = ""
364 --source include/assert.inc
365
366 --let $assert_text= Verify SESSION value of group_replication_force_members
367 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_force_members\', Value, 1]" = ""
368 --source include/assert.inc
369
370 --let $assert_text= Verify SESSION value of group_replication_force_members
371 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_force_members\', VARIABLE_VALUE, 1]" = ""
372 --source include/assert.inc
373
374 # group_replication_group_name
375 --let $assert_text= Verify GLOBAL value of group_replication_group_name
376 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_group_name\', Value, 1]" = "aaaaaaaa-cccc-bbbb-cccc-aaaaaaaaaaaa"
377 --source include/assert.inc
378
379 --let $assert_text= Verify GLOBAL value of group_replication_group_name
380 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_group_name\', VARIABLE_VALUE, 1]" = "aaaaaaaa-cccc-bbbb-cccc-aaaaaaaaaaaa"
381 --source include/assert.inc
382
383 --let $assert_text= Verify SESSION value of group_replication_group_name
384 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_group_name\', Value, 1]" = "aaaaaaaa-cccc-bbbb-cccc-aaaaaaaaaaaa"
385 --source include/assert.inc
386
387 --let $assert_text= Verify SESSION value of group_replication_group_name
388 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_group_name\', VARIABLE_VALUE, 1]" = "aaaaaaaa-cccc-bbbb-cccc-aaaaaaaaaaaa"
389 --source include/assert.inc
390
391 # group_replication_gtid_assignment_block_size
392 --let $assert_text= Verify GLOBAL value of group_replication_gtid_assignment_block_size
393 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_gtid_assignment_block_size\', Value, 1]" = 2
394 --source include/assert.inc
395
396 --let $assert_text= Verify GLOBAL value of group_replication_gtid_assignment_block_size
397 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_gtid_assignment_block_size\', VARIABLE_VALUE, 1]" = 2
398 --source include/assert.inc
399
400 --let $assert_text= Verify SESSION value of group_replication_gtid_assignment_block_size
401 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_gtid_assignment_block_size\', Value, 1]" = 2
402 --source include/assert.inc
403
404 --let $assert_text= Verify SESSION value of group_replication_gtid_assignment_block_size
405 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_gtid_assignment_block_size\', VARIABLE_VALUE, 1]" = 2
406 --source include/assert.inc
407
408 # group_replication_ip_allowlist
409 --let $assert_text= Verify GLOBAL value of group_replication_ip_allowlist
410 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_ip_allowlist\', Value, 1]" = "AUTOMATIC"
411 --source include/assert.inc
412
413 --let $assert_text= Verify GLOBAL value of group_replication_ip_allowlist
414 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_ip_allowlist\', VARIABLE_VALUE, 1]" = "AUTOMATIC"
415 --source include/assert.inc
416
417 --let $assert_text= Verify SESSION value of group_replication_ip_allowlist
418 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_ip_allowlist\', Value, 1]" = "AUTOMATIC"
419 --source include/assert.inc
420
421 --let $assert_text= Verify SESSION value of group_replication_ip_allowlist
422 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_ip_allowlist\', VARIABLE_VALUE, 1]" = "AUTOMATIC"
423 --source include/assert.inc
424
425 # group_replication_local_address
426 --let $assert_text= Verify GLOBAL value of group_replication_local_address
427 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_local_address\', Value, 1]" = "$saved_gr_local_address"
428 --source include/assert.inc
429
430 --let $assert_text= Verify GLOBAL value of group_replication_local_address
431 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_local_address\', VARIABLE_VALUE, 1]" = "$saved_gr_local_address"
432 --source include/assert.inc
433
434 --let $assert_text= Verify SESSION value of group_replication_local_address
435 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_local_address\', Value, 1]" = "$saved_gr_local_address"
436 --source include/assert.inc
437
438 --let $assert_text= Verify SESSION value of group_replication_local_address
439 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_local_address\', VARIABLE_VALUE, 1]" = "$saved_gr_local_address"
440 --source include/assert.inc
441
442 # group_replication_group_seeds
443 --let $assert_text= Verify GLOBAL value of group_replication_group_seeds
444 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_group_seeds\', Value, 1]" = "$saved_gr_group_seeds"
445 --source include/assert.inc
446
447 --let $assert_text= Verify GLOBAL value of group_replication_group_seeds
448 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_group_seeds\', VARIABLE_VALUE, 1]" = "$saved_gr_group_seeds"
449 --source include/assert.inc
450
451 --let $assert_text= Verify SESSION value of group_replication_group_seeds
452 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_group_seeds\', Value, 1]" = "$saved_gr_group_seeds"
453 --source include/assert.inc
454
455 --let $assert_text= Verify SESSION value of group_replication_group_seeds
456 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_group_seeds\', VARIABLE_VALUE, 1]" = "$saved_gr_group_seeds"
457 --source include/assert.inc
458
459 # group_replication_poll_spin_loops
460 --let $assert_text= Verify GLOBAL value of group_replication_poll_spin_loops
461 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_poll_spin_loops\', Value, 1]" = 10
462 --source include/assert.inc
463
464 --let $assert_text= Verify GLOBAL value of group_replication_poll_spin_loops
465 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_poll_spin_loops\', VARIABLE_VALUE, 1]" = 10
466 --source include/assert.inc
467
468 --let $assert_text= Verify SESSION value of group_replication_poll_spin_loops
469 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_poll_spin_loops\', Value, 1]" = 10
470 --source include/assert.inc
471
472 --let $assert_text= Verify SESSION value of group_replication_poll_spin_loops
473 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_poll_spin_loops\', VARIABLE_VALUE, 1]" = 10
474 --source include/assert.inc
475
476 # group_replication_recovery_complete_at
477 --let $assert_text= Verify GLOBAL value of group_replication_recovery_complete_at
478 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_recovery_complete_at\', Value, 1]" = "TRANSACTIONS_CERTIFIED"
479 --source include/assert.inc
480
481 --let $assert_text= Verify GLOBAL value of group_replication_recovery_complete_at
482 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_recovery_complete_at\', VARIABLE_VALUE, 1]" = "TRANSACTIONS_CERTIFIED"
483 --source include/assert.inc
484
485 --let $assert_text= Verify SESSION value of group_replication_recovery_complete_at
486 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_recovery_complete_at\', Value, 1]" = "TRANSACTIONS_CERTIFIED"
487 --source include/assert.inc
488
489 --let $assert_text= Verify SESSION value of group_replication_recovery_complete_at
490 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_recovery_complete_at\', VARIABLE_VALUE, 1]" = "TRANSACTIONS_CERTIFIED"
491 --source include/assert.inc
492
493 # group_replication_recovery_reconnect_interval
494 --let $assert_text= Verify GLOBAL value of group_replication_recovery_reconnect_interval
495 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_recovery_reconnect_interval\', Value, 1]" = 20
496 --source include/assert.inc
497
498 --let $assert_text= Verify GLOBAL value of group_replication_recovery_reconnect_interval
499 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_recovery_reconnect_interval\', VARIABLE_VALUE, 1]" = 20
500 --source include/assert.inc
501
502 --let $assert_text= Verify SESSION value of group_replication_recovery_reconnect_interval
503 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_recovery_reconnect_interval\', Value, 1]" = 20
504 --source include/assert.inc
505
506 --let $assert_text= Verify SESSION value of group_replication_recovery_reconnect_interval
507 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_recovery_reconnect_interval\', VARIABLE_VALUE, 1]" = 20
508 --source include/assert.inc
509
510 # group_replication_recovery_retry_count
511 --let $assert_text= Verify GLOBAL value of group_replication_recovery_retry_count
512 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_recovery_retry_count\', Value, 1]" = 5
513 --source include/assert.inc
514
515 --let $assert_text= Verify GLOBAL value of group_replication_recovery_retry_count
516 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_recovery_retry_count\', VARIABLE_VALUE, 1]" = 5
517 --source include/assert.inc
518
519 --let $assert_text= Verify SESSION value of group_replication_recovery_retry_count
520 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_recovery_retry_count\', Value, 1]" = 5
521 --source include/assert.inc
522
523 --let $assert_text= Verify SESSION value of group_replication_recovery_retry_count
524 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_recovery_retry_count\', VARIABLE_VALUE, 1]" = 5
525 --source include/assert.inc
526
527 # group_replication_recovery_ssl_ca
528 --let $assert_text= Verify GLOBAL value of group_replication_recovery_ssl_ca
529 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_recovery_ssl_ca\', Value, 1]" = "$MYSQL_TEST_DIR/std_data/cacert.pem"
530 --source include/assert.inc
531
532 --let $assert_text= Verify GLOBAL value of group_replication_recovery_ssl_ca
533 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_recovery_ssl_ca\', VARIABLE_VALUE, 1]" = "$MYSQL_TEST_DIR/std_data/cacert.pem"
534 --source include/assert.inc
535
536 --let $assert_text= Verify SESSION value of group_replication_recovery_ssl_ca
537 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_recovery_ssl_ca\', Value, 1]" = "$MYSQL_TEST_DIR/std_data/cacert.pem"
538 --source include/assert.inc
539
540 --let $assert_text= Verify SESSION value of group_replication_recovery_ssl_ca
541 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_recovery_ssl_ca\', VARIABLE_VALUE, 1]" = "$MYSQL_TEST_DIR/std_data/cacert.pem"
542 --source include/assert.inc
543
544 # group_replication_recovery_ssl_capath
545 --let $assert_text= Verify GLOBAL value of group_replication_recovery_ssl_capath
546 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_recovery_ssl_capath\', Value, 1]" = ""
547 --source include/assert.inc
548
549 --let $assert_text= Verify GLOBAL value of group_replication_recovery_ssl_capath
550 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_recovery_ssl_capath\', VARIABLE_VALUE, 1]" = ""
551 --source include/assert.inc
552
553 --let $assert_text= Verify SESSION value of group_replication_recovery_ssl_capath
554 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_recovery_ssl_capath\', Value, 1]" = ""
555 --source include/assert.inc
556
557 --let $assert_text= Verify SESSION value of group_replication_recovery_ssl_capath
558 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_recovery_ssl_capath\', VARIABLE_VALUE, 1]" = ""
559 --source include/assert.inc
560
561 # group_replication_recovery_ssl_cert
562 --let $assert_text= Verify GLOBAL value of group_replication_recovery_ssl_cert
563 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_recovery_ssl_cert\', Value, 1]" = "$MYSQL_TEST_DIR/std_data/client-cert.pem"
564 --source include/assert.inc
565
566 --let $assert_text= Verify GLOBAL value of group_replication_recovery_ssl_cert
567 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_recovery_ssl_cert\', VARIABLE_VALUE, 1]" = "$MYSQL_TEST_DIR/std_data/client-cert.pem"
568 --source include/assert.inc
569
570 --let $assert_text= Verify SESSION value of group_replication_recovery_ssl_cert
571 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_recovery_ssl_cert\', Value, 1]" = "$MYSQL_TEST_DIR/std_data/client-cert.pem"
572 --source include/assert.inc
573
574 --let $assert_text= Verify SESSION value of group_replication_recovery_ssl_cert
575 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_recovery_ssl_cert\', VARIABLE_VALUE, 1]" = "$MYSQL_TEST_DIR/std_data/client-cert.pem"
576 --source include/assert.inc
577
578 # group_replication_recovery_ssl_cipher
579 --let $assert_text= Verify GLOBAL value of group_replication_recovery_ssl_cipher
580 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_recovery_ssl_cipher\', Value, 1]" = "ECDHE-RSA-AES128-GCM-SHA256"
581 --source include/assert.inc
582
583 --let $assert_text= Verify GLOBAL value of group_replication_recovery_ssl_cipher
584 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_recovery_ssl_cipher\', VARIABLE_VALUE, 1]" = "ECDHE-RSA-AES128-GCM-SHA256"
585 --source include/assert.inc
586
587 --let $assert_text= Verify SESSION value of group_replication_recovery_ssl_cipher
588 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_recovery_ssl_cipher\', Value, 1]" = "ECDHE-RSA-AES128-GCM-SHA256"
589 --source include/assert.inc
590
591 --let $assert_text= Verify SESSION value of group_replication_recovery_ssl_cipher
592 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_recovery_ssl_cipher\', VARIABLE_VALUE, 1]" = "ECDHE-RSA-AES128-GCM-SHA256"
593 --source include/assert.inc
594
595 # group_replication_recovery_ssl_crl
596 --let $assert_text= Verify GLOBAL value of group_replication_recovery_ssl_crl
597 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_recovery_ssl_crl\', Value, 1]" = "crl-client-revoked.crl"
598 --source include/assert.inc
599
600 --let $assert_text= Verify GLOBAL value of group_replication_recovery_ssl_crl
601 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_recovery_ssl_crl\', VARIABLE_VALUE, 1]" = "crl-client-revoked.crl"
602 --source include/assert.inc
603
604 --let $assert_text= Verify SESSION value of group_replication_recovery_ssl_crl
605 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_recovery_ssl_crl\', Value, 1]" = "crl-client-revoked.crl"
606 --source include/assert.inc
607
608 --let $assert_text= Verify SESSION value of group_replication_recovery_ssl_crl
609 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_recovery_ssl_crl\', VARIABLE_VALUE, 1]" = "crl-client-revoked.crl"
610 --source include/assert.inc
611
612 # group_replication_recovery_ssl_crlpath
613 --let $assert_text= Verify GLOBAL value of group_replication_recovery_ssl_crlpath
614 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_recovery_ssl_crlpath\', Value, 1]" = ""
615 --source include/assert.inc
616
617 --let $assert_text= Verify GLOBAL value of group_replication_recovery_ssl_crlpath
618 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_recovery_ssl_crlpath\', VARIABLE_VALUE, 1]" = ""
619 --source include/assert.inc
620
621 --let $assert_text= Verify SESSION value of group_replication_recovery_ssl_crlpath
622 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_recovery_ssl_crlpath\', Value, 1]" = ""
623 --source include/assert.inc
624
625 --let $assert_text= Verify SESSION value of group_replication_recovery_ssl_crlpath
626 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_recovery_ssl_crlpath\', VARIABLE_VALUE, 1]" = ""
627 --source include/assert.inc
628
629 # group_replication_recovery_ssl_key
630 --let $assert_text= Verify GLOBAL value of group_replication_recovery_ssl_key
631 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_recovery_ssl_key\', Value, 1]" = "$MYSQL_TEST_DIR/std_data/client-key.pem"
632 --source include/assert.inc
633
634 --let $assert_text= Verify GLOBAL value of group_replication_recovery_ssl_key
635 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_recovery_ssl_key\', VARIABLE_VALUE, 1]" = "$MYSQL_TEST_DIR/std_data/client-key.pem"
636 --source include/assert.inc
637
638 --let $assert_text= Verify SESSION value of group_replication_recovery_ssl_key
639 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_recovery_ssl_key\', Value, 1]" = "$MYSQL_TEST_DIR/std_data/client-key.pem"
640 --source include/assert.inc
641
642 --let $assert_text= Verify SESSION value of group_replication_recovery_ssl_key
643 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_recovery_ssl_key\', VARIABLE_VALUE, 1]" = "$MYSQL_TEST_DIR/std_data/client-key.pem"
644 --source include/assert.inc
645
646 # group_replication_recovery_ssl_verify_server_cert
647 --let $assert_text= Verify GLOBAL value of group_replication_recovery_ssl_verify_server_cert
648 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_recovery_ssl_verify_server_cert\', Value, 1]" = "ON"
649 --source include/assert.inc
650
651 --let $assert_text= Verify GLOBAL value of group_replication_recovery_ssl_verify_server_cert
652 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_recovery_ssl_verify_server_cert\', VARIABLE_VALUE, 1]" = "ON"
653 --source include/assert.inc
654
655 --let $assert_text= Verify SESSION value of group_replication_recovery_ssl_verify_server_cert
656 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_recovery_ssl_verify_server_cert\', Value, 1]" = "ON"
657 --source include/assert.inc
658
659 --let $assert_text= Verify SESSION value of group_replication_recovery_ssl_verify_server_cert
660 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_recovery_ssl_verify_server_cert\', VARIABLE_VALUE, 1]" = "ON"
661 --source include/assert.inc
662
663 # group_replication_recovery_use_ssl
664 --let $assert_text= Verify GLOBAL value of group_replication_recovery_use_ssl
665 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_recovery_use_ssl\', Value, 1]" = "ON"
666 --source include/assert.inc
667
668 --let $assert_text= Verify GLOBAL value of group_replication_recovery_use_ssl
669 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_recovery_use_ssl\', VARIABLE_VALUE, 1]" = "ON"
670 --source include/assert.inc
671
672 --let $assert_text= Verify SESSION value of group_replication_recovery_use_ssl
673 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_recovery_use_ssl\', Value, 1]" = "ON"
674 --source include/assert.inc
675
676 --let $assert_text= Verify SESSION value of group_replication_recovery_use_ssl
677 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_recovery_use_ssl\', VARIABLE_VALUE, 1]" = "ON"
678 --source include/assert.inc
679
680 # group_replication_single_primary_mode
681 --let $assert_text= Verify GLOBAL value of group_replication_single_primary_mode
682 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_single_primary_mode\', Value, 1]" = "OFF"
683 --source include/assert.inc
684
685 --let $assert_text= Verify GLOBAL value of group_replication_single_primary_mode
686 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_single_primary_mode\', VARIABLE_VALUE, 1]" = "OFF"
687 --source include/assert.inc
688
689 --let $assert_text= Verify SESSION value of group_replication_single_primary_mode
690 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_single_primary_mode\', Value, 1]" = "OFF"
691 --source include/assert.inc
692
693 --let $assert_text= Verify SESSION value of group_replication_single_primary_mode
694 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_single_primary_mode\', VARIABLE_VALUE, 1]" = "OFF"
695 --source include/assert.inc
696
697 # group_replication_ssl_mode
698 --let $assert_text= Verify GLOBAL value of group_replication_ssl_mode
699 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_ssl_mode\', Value, 1]" = "REQUIRED"
700 --source include/assert.inc
701
702 --let $assert_text= Verify GLOBAL value of group_replication_ssl_mode
703 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_ssl_mode\', VARIABLE_VALUE, 1]" = "REQUIRED"
704 --source include/assert.inc
705
706 --let $assert_text= Verify SESSION value of group_replication_ssl_mode
707 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_ssl_mode\', Value, 1]" = "REQUIRED"
708 --source include/assert.inc
709
710 --let $assert_text= Verify SESSION value of group_replication_ssl_mode
711 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_ssl_mode\', VARIABLE_VALUE, 1]" = "REQUIRED"
712 --source include/assert.inc
713
714 # group_replication_start_on_boot
715 --let $assert_text= Verify GLOBAL value of group_replication_start_on_boot
716 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_start_on_boot\', Value, 1]" = "ON"
717 --source include/assert.inc
718
719 --let $assert_text= Verify GLOBAL value of group_replication_start_on_boot
720 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_start_on_boot\', VARIABLE_VALUE, 1]" = "ON"
721 --source include/assert.inc
722
723 --let $assert_text= Verify SESSION value of group_replication_start_on_boot
724 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_start_on_boot\', Value, 1]" = "ON"
725 --source include/assert.inc
726
727 --let $assert_text= Verify SESSION value of group_replication_start_on_boot
728 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_start_on_boot\', VARIABLE_VALUE, 1]" = "ON"
729 --source include/assert.inc
730
731 # group_replication_transaction_size_limit
732 --let $assert_text= Verify GLOBAL value of group_replication_transaction_size_limit
733 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_transaction_size_limit\', Value, 1]" = 100000
734 --source include/assert.inc
735
736 --let $assert_text= Verify GLOBAL value of group_replication_transaction_size_limit
737 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_transaction_size_limit\', VARIABLE_VALUE, 1]" = 100000
738 --source include/assert.inc
739
740 --let $assert_text= Verify SESSION value of group_replication_transaction_size_limit
741 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_transaction_size_limit\', Value, 1]" = 100000
742 --source include/assert.inc
743
744 --let $assert_text= Verify SESSION value of group_replication_transaction_size_limit
745 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_transaction_size_limit\', VARIABLE_VALUE, 1]" = 100000
746 --source include/assert.inc
747
748 # group_replication_communication_debug_options
749 --let $assert_text= Verify GLOBAL value of group_replication_communication_debug_options
750 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_communication_debug_options\', Value, 1]" = "GCS_DEBUG_ALL"
751 --source include/assert.inc
752
753 --let $assert_text= Verify GLOBAL value of group_replication_communication_debug_options
754 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_communication_debug_options\', VARIABLE_VALUE, 1]" = "GCS_DEBUG_ALL"
755 --source include/assert.inc
756
757 --let $assert_text= Verify SESSION value of group_replication_communication_debug_options
758 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_communication_debug_options\', Value, 1]" = "GCS_DEBUG_ALL"
759 --source include/assert.inc
760
761 --let $assert_text= Verify SESSION value of group_replication_communication_debug_options
762 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_communication_debug_options\', VARIABLE_VALUE, 1]" = "GCS_DEBUG_ALL"
763 --source include/assert.inc
764
765 # group_replication_unreachable_majority_timeout
766 --let $assert_text= Verify GLOBAL value of group_replication_unreachable_majority_timeout
767 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_unreachable_majority_timeout\', Value, 1]" = 100000
768 --source include/assert.inc
769
770 --let $assert_text= Verify GLOBAL value of group_replication_unreachable_majority_timeout
771 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_unreachable_majority_timeout\', VARIABLE_VALUE, 1]" = 100000
772 --source include/assert.inc
773
774 --let $assert_text= Verify SESSION value of group_replication_unreachable_majority_timeout
775 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_unreachable_majority_timeout\', Value, 1]" = 100000
776 --source include/assert.inc
777
778 --let $assert_text= Verify SESSION value of group_replication_unreachable_majority_timeout
779 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_unreachable_majority_timeout\', VARIABLE_VALUE, 1]" = 100000
780 --source include/assert.inc
781
782 # group_replication_member_weight
783 --let $assert_text= Verify GLOBAL value of group_replication_member_weight
784 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_member_weight\', Value, 1]" = 70
785 --source include/assert.inc
786
787 --let $assert_text= Verify GLOBAL value of group_replication_member_weight
788 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_member_weight\', VARIABLE_VALUE, 1]" = 70
789 --source include/assert.inc
790
791 --let $assert_text= Verify SESSION value of group_replication_member_weight
792 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_member_weight\', Value, 1]" = 70
793 --source include/assert.inc
794
795 --let $assert_text= Verify SESSION value of group_replication_member_weight
796 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_member_weight\', VARIABLE_VALUE, 1]" = 70
797 --source include/assert.inc
798
799 # group_replication_recovery_public_key_path
800 --let $assert_text= Verify GLOBAL value of group_replication_recovery_public_key_path
801 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_recovery_public_key_path\', Value, 1]" = "$MYSQL_TEST_DIR/std_data/rsa_public_key.pem"
802 --source include/assert.inc
803
804 --let $assert_text= Verify GLOBAL value of group_replication_recovery_public_key_path
805 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_recovery_public_key_path\', VARIABLE_VALUE, 1]" = "$MYSQL_TEST_DIR/std_data/rsa_public_key.pem"
806 --source include/assert.inc
807
808 --let $assert_text= Verify SESSION value of group_replication_recovery_public_key_path
809 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_recovery_public_key_path\', Value, 1]" = "$MYSQL_TEST_DIR/std_data/rsa_public_key.pem"
810 --source include/assert.inc
811
812 --let $assert_text= Verify SESSION value of group_replication_recovery_public_key_path
813 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_recovery_public_key_path\', VARIABLE_VALUE, 1]" = "$MYSQL_TEST_DIR/std_data/rsa_public_key.pem"
814 --source include/assert.inc
815
816 # group_replication_recovery_get_public_key
817 --let $assert_text= Verify GLOBAL value of group_replication_recovery_get_public_key
818 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_recovery_get_public_key\', Value, 1]" = "ON"
819 --source include/assert.inc
820
821 --let $assert_text= Verify GLOBAL value of group_replication_recovery_get_public_key
822 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_recovery_get_public_key\', VARIABLE_VALUE, 1]" = "ON"
823 --source include/assert.inc
824
825 --let $assert_text= Verify SESSION value of group_replication_recovery_get_public_key
826 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_recovery_get_public_key\', Value, 1]" = "ON"
827 --source include/assert.inc
828
829 --let $assert_text= Verify SESSION value of group_replication_recovery_get_public_key
830 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_recovery_get_public_key\', VARIABLE_VALUE, 1]" = "ON"
831 --source include/assert.inc
832
833 # group_replication_exit_state_action
834 --let $assert_text= Verify GLOBAL value of group_replication_exit_state_action
835 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_exit_state_action\', Value, 1]" = "READ_ONLY"
836 --source include/assert.inc
837
838 --let $assert_text= Verify GLOBAL value of group_replication_exit_state_action
839 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_exit_state_action\', VARIABLE_VALUE, 1]" = "READ_ONLY"
840 --source include/assert.inc
841
842 --let $assert_text= Verify SESSION value of group_replication_exit_state_action
843 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_exit_state_action\', Value, 1]" = "READ_ONLY"
844 --source include/assert.inc
845
846 --let $assert_text= Verify SESSION value of group_replication_exit_state_action
847 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_exit_state_action\', VARIABLE_VALUE, 1]" = "READ_ONLY"
848 --source include/assert.inc
849
850 # group_replication_member_expel_timeout
851 --let $assert_text= Verify GLOBAL value of group_replication_member_expel_timeout
852 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_member_expel_timeout\', Value, 1]" = 1000
853 --source include/assert.inc
854
855 --let $assert_text= Verify GLOBAL value of group_replication_member_expel_timeout
856 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_member_expel_timeout\', VARIABLE_VALUE, 1]" = 1000
857 --source include/assert.inc
858
859 --let $assert_text= Verify SESSION value of group_replication_member_expel_timeout
860 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_member_expel_timeout\', Value, 1]" = 1000
861 --source include/assert.inc
862
863 --let $assert_text= Verify SESSION value of group_replication_member_expel_timeout
864 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_member_expel_timeout\', VARIABLE_VALUE, 1]" = 1000
865 --source include/assert.inc
866
867 # group_replication_consistency
868 --let $assert_text= Verify GLOBAL value of group_replication_consistency
869 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_consistency\', Value, 1]" = "EVENTUAL"
870 --source include/assert.inc
871
872 --let $assert_text= Verify GLOBAL value of group_replication_consistency
873 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_consistency\', VARIABLE_VALUE, 1]" = "EVENTUAL"
874 --source include/assert.inc
875
876 --let $assert_text= Verify SESSION value of group_replication_consistency
877 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_consistency\', Value, 1]" = "EVENTUAL"
878 --source include/assert.inc
879
880 --let $assert_text= Verify SESSION value of group_replication_consistency
881 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_consistency\', VARIABLE_VALUE, 1]" = "EVENTUAL"
882 --source include/assert.inc
883
884 # group_replication_communication_max_message_size
885 --let $assert_text= Verify GLOBAL value of group_replication_communication_max_message_size
886 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_communication_max_message_size\', Value, 1]" = 2048
887 --source include/assert.inc
888
889 --let $assert_text= Verify GLOBAL value of group_replication_communication_max_message_size
890 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_communication_max_message_size\', VARIABLE_VALUE, 1]" = 2048
891 --source include/assert.inc
892
893 --let $assert_text= Verify SESSION value of group_replication_communication_max_message_size
894 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_communication_max_message_size\', Value, 1]" = 2048
895 --source include/assert.inc
896
897 --let $assert_text= Verify SESSION value of group_replication_communication_max_message_size
898 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_communication_max_message_size\', VARIABLE_VALUE, 1]" = 2048
899 --source include/assert.inc
900
901 # group_replication_autorejoin_tries
902 --let $assert_text= Verify GLOBAL value of group_replication_autorejoin_tries
903 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_autorejoin_tries\', Value, 1]" = 3
904 --source include/assert.inc
905
906 --let $assert_text= Verify GLOBAL value of group_replication_autorejoin_tries
907 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_autorejoin_tries\', VARIABLE_VALUE, 1]" = 3
908 --source include/assert.inc
909
910 --let $assert_text= Verify SESSION value of group_replication_autorejoin_tries
911 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_autorejoin_tries\', Value, 1]" = 3
912 --source include/assert.inc
913
914 --let $assert_text= Verify SESSION value of group_replication_autorejoin_tries
915 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_autorejoin_tries\', VARIABLE_VALUE, 1]" = 3
916 --source include/assert.inc
917
918 # group_replication_message_cache_size
919 --let $assert_text= Verify GLOBAL value of group_replication_message_cache_size
920 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_message_cache_size\', Value, 1]" = 2000000000
921 --source include/assert.inc
922
923 --let $assert_text= Verify GLOBAL value of group_replication_message_cache_size
924 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_message_cache_size\', VARIABLE_VALUE, 1]" = 2000000000
925 --source include/assert.inc
926
927 --let $assert_text= Verify SESSION value of group_replication_message_cache_size
928 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_message_cache_size\', Value, 1]" = 2000000000
929 --source include/assert.inc
930
931 --let $assert_text= Verify SESSION value of group_replication_message_cache_size
932 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_message_cache_size\', VARIABLE_VALUE, 1]" = 2000000000
933 --source include/assert.inc
934
935 # group_replication_clone_threshold
936 --let $assert_text= Verify GLOBAL value of group_replication_clone_threshold
937 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_clone_threshold\', Value, 1]" = 1
938 --source include/assert.inc
939
940 --let $assert_text= Verify GLOBAL value of group_replication_clone_threshold
941 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_clone_threshold\', VARIABLE_VALUE, 1]" = 1
942 --source include/assert.inc
943
944 --let $assert_text= Verify SESSION value of group_replication_clone_threshold
945 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_clone_threshold\', Value, 1]" = 1
946 --source include/assert.inc
947
948 --let $assert_text= Verify SESSION value of group_replication_clone_threshold
949 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_clone_threshold\', VARIABLE_VALUE, 1]" = 1
950 --source include/assert.inc
951
952 # group_replication_recovery_tls_version
953 --let $assert_text= Verify GLOBAL value of group_replication_recovery_tls_version
954 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_recovery_tls_version\', Value, 1]" = ""
955 --source include/assert.inc
956
957 --let $assert_text= Verify GLOBAL value of group_replication_recovery_tls_version
958 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_recovery_tls_version\', VARIABLE_VALUE, 1]" = ""
959 --source include/assert.inc
960
961 --let $assert_text= Verify SESSION value of group_replication_recovery_tls_version
962 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_recovery_tls_version\', Value, 1]" = ""
963 --source include/assert.inc
964
965 --let $assert_text= Verify SESSION value of group_replication_recovery_tls_version
966 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_recovery_tls_version\', VARIABLE_VALUE, 1]" = ""
967 --source include/assert.inc
968
969 # group_replication_recovery_tls_ciphersuites
970 --let $assert_text= Verify GLOBAL value of group_replication_recovery_tls_ciphersuites
971 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_recovery_tls_ciphersuites\', Value, 1]" = ""
972 --source include/assert.inc
973
974 --let $assert_text= Verify GLOBAL value of group_replication_recovery_tls_ciphersuites
975 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_recovery_tls_ciphersuites\', VARIABLE_VALUE, 1]" = ""
976 --source include/assert.inc
977
978 --let $assert_text= Verify SESSION value of group_replication_recovery_tls_ciphersuites
979 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_recovery_tls_ciphersuites\', Value, 1]" = ""
980 --source include/assert.inc
981
982 --let $assert_text= Verify SESSION value of group_replication_recovery_tls_ciphersuites
983 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_recovery_tls_ciphersuites\', VARIABLE_VALUE, 1]" = ""
984 --source include/assert.inc
985
986 --let $assert_text= Verify SESSION value of group_replication_view_change_uuid
987 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_view_change_uuid\', VARIABLE_VALUE, 1]" = "aaaaaaaa-cccc-bbbb-dddd-eeeeeeeeeeee"
988 --source include/assert.inc
989
990 # group_replication_paxos_single_leader
991 --let $assert_text= Verify GLOBAL value of group_replication_paxos_single_leader
992 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE \'group_replication_paxos_single_leader\', Value, 1]" = "ON"
993 --source include/assert.inc
994
995 --let $assert_text= Verify GLOBAL value of group_replication_paxos_single_leader
996 --let $assert_cond= "[SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME=\'group_replication_paxos_single_leader\', VARIABLE_VALUE, 1]" = "ON"
997 --source include/assert.inc
998
999 --let $assert_text= Verify SESSION value of group_replication_paxos_single_leader
1000 --let $assert_cond= "[SHOW SESSION VARIABLES LIKE \'group_replication_paxos_single_leader\', Value, 1]" = "ON"
1001 --source include/assert.inc
1002
1003 --let $assert_text= Verify SESSION value of group_replication_paxos_single_leader
1004 --let $assert_cond= "[SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'group_replication_paxos_single_leader\', VARIABLE_VALUE, 1]" = "ON"
1005 --source include/assert.inc
1006
1007 --echo
1008 --echo # Clean up
1009 --source include/stop_group_replication.inc
1010
1011 # No need to print this into result file.
1012 --disable_query_log
1013 --eval SET @@GLOBAL.group_replication_allow_local_lower_version_join= $saved_gr_allow_local_lower_version_join
1014 --eval SET @@GLOBAL.group_replication_auto_increment_increment= $saved_gr_auto_increment_increment
1015 --eval SET @@GLOBAL.group_replication_bootstrap_group= $saved_gr_bootstrap_group
1016 --eval SET @@GLOBAL.group_replication_components_stop_timeout= $saved_gr_components_stop_timeout
1017 --eval SET @@GLOBAL.group_replication_compression_threshold= $saved_gr_compression_threshold
1018 --eval SET @@GLOBAL.group_replication_single_primary_mode= $saved_gr_single_primary_mode
1019 --eval SET @@GLOBAL.group_replication_enforce_update_everywhere_checks= $saved_gr_enforce_update_everywhere_checks
1020 --eval SET @@GLOBAL.group_replication_force_members= "$saved_gr_force_members"
1021 --eval SET @@GLOBAL.group_replication_group_name= "$saved_gr_group_name"
1022 --eval SET @@GLOBAL.group_replication_gtid_assignment_block_size= $saved_gr_gtid_assignment_block_size
1023 --eval SET @@GLOBAL.group_replication_ip_allowlist= "$saved_gr_ip_allowlist"
1024 --eval SET @@GLOBAL.group_replication_local_address= "$saved_gr_local_address"
1025 --eval SET @@GLOBAL.group_replication_group_seeds= "$saved_gr_group_seeds"
1026 --eval SET @@GLOBAL.group_replication_poll_spin_loops= $saved_gr_poll_spin_loops
1027 --eval SET @@GLOBAL.group_replication_recovery_complete_at= "$saved_gr_recovery_complete_at"
1028 --eval SET @@GLOBAL.group_replication_recovery_reconnect_interval= $saved_gr_recovery_reconnect_interval
1029 --eval SET @@GLOBAL.group_replication_recovery_retry_count= $saved_gr_recovery_retry_count
1030 --eval SET @@GLOBAL.group_replication_recovery_ssl_ca= "$saved_gr_recovery_ssl_ca"
1031 --eval SET @@GLOBAL.group_replication_recovery_ssl_capath= "$saved_gr_recovery_ssl_capath"
1032 --eval SET @@GLOBAL.group_replication_recovery_ssl_cert= "$saved_gr_recovery_ssl_cert"
1033 --eval SET @@GLOBAL.group_replication_recovery_ssl_cipher= "$saved_gr_recovery_ssl_cipher"
1034 --eval SET @@GLOBAL.group_replication_recovery_ssl_crl= "$saved_gr_recovery_ssl_crl"
1035 --eval SET @@GLOBAL.group_replication_recovery_ssl_crlpath= "$saved_gr_recovery_ssl_crlpath"
1036 --eval SET @@GLOBAL.group_replication_recovery_ssl_key= "$saved_gr_recovery_ssl_key"
1037 --eval SET @@GLOBAL.group_replication_recovery_ssl_verify_server_cert= $saved_gr_recovery_ssl_verify_server_cert
1038 --eval SET @@GLOBAL.group_replication_recovery_use_ssl= $saved_gr_recovery_use_ssl
1039 --eval SET @@GLOBAL.group_replication_ssl_mode= $saved_gr_ssl_mode
1040 --eval SET @@GLOBAL.group_replication_start_on_boot= $saved_gr_start_on_boot
1041 --eval SET @@GLOBAL.group_replication_transaction_size_limit= $saved_gr_transaction_size_limit
1042 --eval SET @@GLOBAL.group_replication_communication_debug_options= "$saved_gr_communication_debug_options"
1043 --eval SET @@GLOBAL.group_replication_unreachable_majority_timeout= $saved_gr_unreachable_majority_timeout
1044 --eval SET @@GLOBAL.group_replication_member_weight= $saved_gr_member_weight
1045 --eval SET @@GLOBAL.group_replication_recovery_public_key_path= "$saved_gr_recovery_public_key_path"
1046 --eval SET @@GLOBAL.group_replication_recovery_get_public_key= $saved_gr_recovery_get_public_key
1047 --eval SET @@GLOBAL.group_replication_exit_state_action= $saved_gr_exit_state_action
1048 --eval SET @@GLOBAL.group_replication_member_expel_timeout= $saved_gr_member_expel_timeout
1049 --eval SET @@GLOBAL.group_replication_consistency= "$saved_gr_consistency"
1050 --eval SET @@GLOBAL.group_replication_communication_max_message_size= $saved_gr_communication_max_message_size
1051 --eval SET @@GLOBAL.group_replication_autorejoin_tries= $saved_gr_autorejoin_tries
1052 --eval SET @@GLOBAL.group_replication_message_cache_size= $saved_gr_message_cache_size
1053 --eval SET @@GLOBAL.group_replication_clone_threshold= $saved_gr_clone_threshold
1054 --eval SET @@GLOBAL.group_replication_recovery_tls_version= "$saved_gr_recovery_tls_version"
1055 --eval SET @@GLOBAL.group_replication_recovery_tls_ciphersuites= "$saved_gr_recovery_tls_ciphersuites"
1056 --eval SET @@GLOBAL.group_replication_view_change_uuid= "$saved_gr_view_change_uuid"
1057 --eval SET @@GLOBAL.group_replication_paxos_single_leader= $saved_gr_paxos_single_leader
1058 --enable_query_log
1059
1060
1061
1062 --source include/group_replication_end.inc
1063