Debian Codegraph @

mysql-test/suite/group_replication/t/gr_persist_only_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_ONLY. Verify persisted variables.
8 # 2. Restart server, it must bootstrap the group and preserve the persisted
9 # variables settings. Verify persisted configuration.
10 # 3. Test RESET PERSIST IF EXISTS. 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_ONLY. 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_ONLY $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
62 --echo
63 --echo ############################################################
64 --echo # 2. Restart server, it must bootstrap the group and preserve
65 --echo # the persisted settings. Verify persisted configuration.
66 --let $allow_rpl_inited= 1
67 --source include/restart_mysqld.inc
68 --let $rpl_server_number= 1
69 --source include/rpl_reconnect.inc
70 --let $MYSQLD_DATADIR= `select @@datadir;`
71
72 --let $group_replication_member_state= ONLINE
73 --source include/gr_wait_for_member_state.inc
74
75 --echo
76 --let $assert_text= 'Expect $countvars persisted variables in persisted_variables table.'
77 --let $assert_cond= [SELECT COUNT(*) as count FROM performance_schema.persisted_variables, count, 1] = $countvars
78 --source include/assert.inc
79
80 # Table performance_schema.variables_info shows, for each system
81 # variable, the source from which it was most recently set.
82 # Since GR does `SET SESSION group_replication_consistency= EVENTUAL;`
83 # on its SQL API internal connections, this option is shown as DYNAMIC
84 # instead of PERSISTED on performance_schema.variables_info table,
85 # despite being listed on performance_schema.persisted_variables table.
86 --let $countvars_excluding_group_replication_consistency= $countvars
87 --dec $countvars_excluding_group_replication_consistency
88
89 --let $assert_text= 'Expect $countvars_excluding_group_replication_consistency variables which last value was set through SET PERSIST.'
90 --let $assert_cond= [SELECT COUNT(*) as count FROM performance_schema.variables_info WHERE variable_source="PERSISTED", count, 1] = $countvars_excluding_group_replication_consistency
91 --source include/assert.inc
92
93 # TODO: Update this once Bug#27322592 is FIXED.
94 --let $persisted_variables = 50
95 --let $assert_text= 'Expect $persisted_variables persisted variables with matching persisted and global values.'
96 --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] = $persisted_variables
97 --source include/assert.inc
98
99
100 --echo
101 --echo ############################################################
102 --echo # 3. Test RESET PERSIST IF EXISTS.
103 --echo # Verify that there are no persisted variables.
104 --let $varid=1
105 while ( $varid <= $countvars )
106 {
107 --let $varnames= `SELECT varname FROM grvars WHERE id=$varid`
108 --eval RESET PERSIST IF EXISTS $varnames
109 --inc $varid
110 }
111
112 --echo
113 --let $assert_text= 'Expect 0 persisted variables.'
114 --let $assert_cond= [SELECT COUNT(*) as count FROM performance_schema.persisted_variables, count, 1] = 0
115 --source include/assert.inc
116
117
118 --echo
119 --echo ############################################################
120 --echo # 4. Clean up.
121 --let $countvars=
122 --let $varid=
123 --let $varnames=
124 --remove_file $MYSQLD_DATADIR/mysqld-auto.cnf
125 SET GLOBAL group_replication_start_on_boot= OFF;
126 SET GLOBAL group_replication_bootstrap_group= OFF;
127 DROP TABLE grvars;
128
129 --source include/group_replication_end.inc