Debian Codegraph @

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

raw
1 ################################################################################
2 # This test is to verify that group replication variables are persisted into
3 # mysqld-auto.cnf file, and, server can restart successfully using this file.
4 #
5 # Test:
6 # 0. The test requires one server. Check that there are no persisted variables.
7 # 1. Test SET PERSIST. Verify persisted variables.
8 # 2. Restart server, it must bootstrap the group and preserve the persisted
9 # variables setting. Verify persisted configuration.
10 # 3. Test RESET PERSIST. Verify that there are no persisted variables.
11 # 4. Clean up.
12 ################################################################################
13 --source include/big_test.inc
14 --source include/have_group_replication_xcom_communication_stack.inc
15 --source include/have_group_replication_plugin.inc
16 --let $rpl_skip_group_replication_start= 1
17 --source include/group_replication.inc
18
19 --echo
20 --echo ############################################################
21 --echo # 0. Check that there are no persisted variables.
22 --let $rpl_connection_name= server1
23 --source include/rpl_connection.inc
24
25 --let $assert_text= 'Expect 1 persisted variables.'
26 --let $assert_cond= [SELECT COUNT(*) as count FROM performance_schema.persisted_variables, count, 1] = 1
27 --source include/assert.inc
28
29
30 --echo
31 --echo ############################################################
32 --echo # 1. Test SET PERSIST. Verify persisted variables.
33 --replace_result $group_replication_group_name GROUP_REPLICATION_GROUP_NAME
34 --eval SET GLOBAL group_replication_group_name= "$group_replication_group_name"
35 SET GLOBAL group_replication_start_on_boot= ON;
36 SET GLOBAL group_replication_bootstrap_group= ON;
37
38 CREATE TABLE grvars (id INT PRIMARY KEY AUTO_INCREMENT, varname VARCHAR(64), varvalue VARCHAR(256));
39 INSERT INTO grvars (varname, varvalue)
40 SELECT * FROM performance_schema.global_variables
41 WHERE VARIABLE_NAME LIKE '%group_replication%'
42 AND VARIABLE_NAME NOT LIKE 'group_replication_force_members'
43 ORDER BY VARIABLE_NAME;
44
45 --let $countvars= `SELECT COUNT(*) FROM grvars;`
46
47 --echo
48 --let $varid=1
49 while ( $varid <= $countvars )
50 {
51 --let $varnames= `SELECT varname FROM grvars WHERE id=$varid`
52 --eval SET PERSIST $varnames = @@GLOBAL.$varnames
53 --inc $varid
54 }
55
56 --echo
57 --let $assert_text= 'Expect $countvars persisted variables.'
58 --let $assert_cond= [SELECT COUNT(*) as count FROM performance_schema.persisted_variables, count, 1] = $countvars
59 --source include/assert.inc
60
61 --echo
62 --echo ############################################################
63 --echo # 2. Restart server, it must bootstrap the group and preserve
64 --echo # the persisted settings. Verify persisted configuration.
65 --let $allow_rpl_inited= 1
66 --source include/restart_mysqld.inc
67 --let $rpl_server_number= 1
68 --source include/rpl_reconnect.inc
69 --let $MYSQLD_DATADIR= `select @@datadir;`
70
71 --let $group_replication_member_state= ONLINE
72 --source include/gr_wait_for_member_state.inc
73
74 --echo
75 --let $assert_text= 'Expect $countvars persisted variables in persisted_variables table.'
76 --let $assert_cond= [SELECT COUNT(*) as count FROM performance_schema.persisted_variables, count, 1] = $countvars
77 --source include/assert.inc
78
79 # Table performance_schema.variables_info shows, for each system
80 # variable, the source from which it was most recently set.
81 # Since GR does `SET SESSION group_replication_consistency= EVENTUAL;`
82 # on its SQL API internal connections, this option is shown as DYNAMIC
83 # instead of PERSISTED on performance_schema.variables_info table,
84 # despite being listed on performance_schema.persisted_variables table.
85 --let $countvars_excluding_group_replication_consistency= $countvars
86 --dec $countvars_excluding_group_replication_consistency
87
88 --let $assert_text= 'Expect $countvars_excluding_group_replication_consistency variables which last value was set through SET PERSIST.'
89 --let $assert_cond= [SELECT COUNT(*) as count FROM performance_schema.variables_info WHERE variable_source="PERSISTED", count, 1] = $countvars_excluding_group_replication_consistency
90 --source include/assert.inc
91
92 --let $assert_text= 'Expect $countvars_excluding_group_replication_consistency variables which last value was set through SET PERSIST is equal to its global value.'
93 --let $assert_cond= [SELECT COUNT(*) as count FROM performance_schema.variables_info vi JOIN performance_schema.persisted_variables pv JOIN performance_schema.global_variables gv ON vi.variable_name=pv.variable_name AND vi.variable_name=gv.variable_name AND pv.variable_value=gv.variable_value WHERE vi.variable_source="PERSISTED", count, 1] = $countvars_excluding_group_replication_consistency
94 --source include/assert.inc
95
96
97 --echo
98 --echo ############################################################
99 --echo # 3. Test RESET PERSIST.
100 --echo # Verify that there are no persisted variables.
101 --let $varid=1
102 while ( $varid <= $countvars )
103 {
104 --let $varnames= `SELECT varname FROM grvars WHERE id=$varid`
105 --eval RESET PERSIST $varnames
106 --inc $varid
107 }
108
109 --echo
110 --let $assert_text= 'Expect 0 persisted variables.'
111 --let $assert_cond= [SELECT COUNT(*) as count FROM performance_schema.persisted_variables, count, 1] = 0
112 --source include/assert.inc
113
114
115 --echo
116 --echo ############################################################
117 --echo # 4. Clean up.
118 --let $countvars=
119 --let $varid=
120 --let $varnames=
121 --remove_file $MYSQLD_DATADIR/mysqld-auto.cnf
122 SET GLOBAL group_replication_start_on_boot= OFF;
123 SET GLOBAL group_replication_bootstrap_group= OFF;
124 DROP TABLE grvars;
125
126 --source include/group_replication_end.inc