Debian Codegraph @

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

raw
1 ############################################################
2 # WL#9426: Single PRIMARY Mode in Group Replication
3 #
4 # This test checks the combinations of the options
5 # group_replication_enforce_update_everywhere_checks
6 # and
7 # group_replication_single_primary_mode
8 ############################################################
9 --source include/have_group_replication_plugin.inc
10
11 --let $rpl_skip_group_replication_start= 1
12
13 --let $saved_single_primary_mode= `SELECT @@GLOBAL.group_replication_single_primary_mode`
14 --let $saved_enforce_update_everywhere_checks= `SELECT @@GLOBAL.group_replication_enforce_update_everywhere_checks`
15
16 # restart MySQL Server with invalid single primary mode configuration
17 --let $rpl_connection_name= default
18 --source include/rpl_connection.inc
19 --let $_group_replication_local_address= `SELECT @@GLOBAL.group_replication_local_address`
20 --let $_group_replication_group_seeds= `SELECT @@GLOBAL.group_replication_group_seeds`
21 --let $restart_parameters=restart: --group_replication_enforce_update_everywhere_checks=ON --group_replication_single_primary_mode=ON --group_replication_local_address=$_group_replication_local_address --group_replication_group_seeds=$_group_replication_group_seeds --group-replication-group-name=$group_replication_group_name
22 --replace_result $_group_replication_local_address GROUP_REPLICATION_LOCAL_ADDRESS $_group_replication_group_seeds GROUP_REPLICATION_GROUP_SEEDS $group_replication_group_name GROUP_REPLICATION_GROUP_NAME
23 --source include/restart_mysqld.inc
24
25 ## verify that 'start group_replication' should fail when MySQL Server is started with
26 ## invalid single primary mode configuration
27 --source include/group_replication.inc
28 SET SESSION sql_log_bin= 0;
29 call mtr.add_suppression("It is not allowed to run single primary mode with 'group_replication_enforce_update_everywhere_checks' enabled.");
30 SET SESSION sql_log_bin= 1;
31 --error ER_GROUP_REPLICATION_CONFIGURATION
32 START GROUP_REPLICATION;
33
34 # set single primary mode configuration to valid values
35 SET GLOBAL group_replication_single_primary_mode= FALSE;
36 SET GLOBAL group_replication_enforce_update_everywhere_checks= FALSE;
37
38 ## group_replication_single_primary_mode verifications
39 --error ER_WRONG_VALUE_FOR_VAR
40 SET GLOBAL group_replication_single_primary_mode= DEFAULT;
41 --error ER_WRONG_VALUE_FOR_VAR
42 SET GLOBAL group_replication_single_primary_mode= NULL;
43 --error ER_WRONG_VALUE_FOR_VAR
44 SET GLOBAL group_replication_single_primary_mode= "AAAAAA";
45 --let $assert_text= 'group_replication_single_primary_mode should be set to 0'
46 --let $assert_cond= [SELECT @@group_replication_single_primary_mode as value, value, 1] = 0
47 --source include/assert.inc
48 SET GLOBAL group_replication_single_primary_mode= TRUE;
49 --let $assert_text= 'group_replication_single_primary_mode should be set to 1'
50 --let $assert_cond= [SELECT @@group_replication_single_primary_mode as value, value, 1] = 1
51 --source include/assert.inc
52 SET GLOBAL group_replication_single_primary_mode= FALSE;
53 --let $assert_text= 'group_replication_single_primary_mode should be set to 0'
54 --let $assert_cond= [SELECT @@group_replication_single_primary_mode as value, value, 1] = 0
55 --source include/assert.inc
56 SET GLOBAL group_replication_single_primary_mode= ON;
57 --let $assert_text= 'group_replication_single_primary_mode should be set to ON'
58 --let $assert_cond= [SELECT @@group_replication_single_primary_mode as value, value, 1] = 1
59 --source include/assert.inc
60 SET GLOBAL group_replication_single_primary_mode= OFF;
61 --let $assert_text= 'group_replication_single_primary_mode should be set to OFF'
62 --let $assert_cond= [SELECT @@group_replication_single_primary_mode as value, value, 1] = 0
63 --source include/assert.inc
64 SET GLOBAL group_replication_single_primary_mode= -1;
65 --let $assert_text= 'group_replication_single_primary_mode should be set to 0'
66 --let $assert_cond= [SELECT @@group_replication_single_primary_mode as value, value, 1] = 0
67 --source include/assert.inc
68 SET GLOBAL group_replication_single_primary_mode= 100;
69 --let $assert_text= 'group_replication_single_primary_mode should be set to 1'
70 --let $assert_cond= [SELECT @@group_replication_single_primary_mode as value, value, 1] = 1
71 --source include/assert.inc
72
73 # disable single primary mode regardless
74 SET GLOBAL group_replication_single_primary_mode= FALSE;
75
76 ## group_replication_enforce_update_everywhere_checks verifications
77 --error ER_WRONG_VALUE_FOR_VAR
78 SET GLOBAL group_replication_enforce_update_everywhere_checks= NULL;
79 --error ER_WRONG_VALUE_FOR_VAR
80 SET GLOBAL group_replication_enforce_update_everywhere_checks= "AAAAAA";
81 --let $assert_text= 'group_replication_enforce_update_everywhere_checks should be set to 0'
82 --let $assert_cond= [SELECT @@group_replication_enforce_update_everywhere_checks as value, value, 1] = 0
83 --source include/assert.inc
84
85 --error ER_WRONG_VALUE_FOR_VAR
86 SET GLOBAL group_replication_enforce_update_everywhere_checks= DEFAULT;
87 SET GLOBAL group_replication_enforce_update_everywhere_checks= TRUE;
88 --let $assert_text= 'group_replication_enforce_update_everywhere_checks should be set to 1'
89 --let $assert_cond= [SELECT @@group_replication_enforce_update_everywhere_checks as value, value, 1] = 1
90 --source include/assert.inc
91 SET GLOBAL group_replication_enforce_update_everywhere_checks= FALSE;
92 --let $assert_text= 'group_replication_enforce_update_everywhere_checks should be set to 0'
93 --let $assert_cond= [SELECT @@group_replication_enforce_update_everywhere_checks as value, value, 1] = 0
94 --source include/assert.inc
95 SET GLOBAL group_replication_enforce_update_everywhere_checks= ON;
96 --let $assert_text= 'group_replication_enforce_update_everywhere_checks should be set to ON'
97 --let $assert_cond= [SELECT @@group_replication_enforce_update_everywhere_checks as value, value, 1] = 1
98 --source include/assert.inc
99 SET GLOBAL group_replication_enforce_update_everywhere_checks= OFF;
100 --let $assert_text= 'group_replication_enforce_update_everywhere_checks should be set to OFF'
101 --let $assert_cond= [SELECT @@group_replication_enforce_update_everywhere_checks as value, value, 1] = 0
102 --source include/assert.inc
103 SET GLOBAL group_replication_enforce_update_everywhere_checks= -1;
104 --let $assert_text= 'group_replication_enforce_update_everywhere_checks should be set to 0'
105 --let $assert_cond= [SELECT @@group_replication_enforce_update_everywhere_checks as value, value, 1] = 0
106 --source include/assert.inc
107 SET GLOBAL group_replication_enforce_update_everywhere_checks= 100;
108 --let $assert_text= 'group_replication_enforce_update_everywhere_checks should be set to 1'
109 --let $assert_cond= [SELECT @@group_replication_enforce_update_everywhere_checks as value, value, 1] = 1
110 --source include/assert.inc
111
112 # assert that we cannot set single primary mode when
113 # enforce_update_everywhere_checks is set
114
115 SET GLOBAL group_replication_enforce_update_everywhere_checks= TRUE;
116 --error ER_WRONG_VALUE_FOR_VAR
117 SET GLOBAL group_replication_single_primary_mode= TRUE;
118
119 # now disable update everywhere checks so that one is able to
120 # enable single primary mode
121 SET GLOBAL group_replication_enforce_update_everywhere_checks= FALSE;
122 --let $assert_text= 'group_replication_enforce_update_everywhere_checks should be set to 0'
123 --let $assert_cond= [SELECT @@group_replication_enforce_update_everywhere_checks as value, value, 1] = 0
124 --source include/assert.inc
125 SET GLOBAL group_replication_single_primary_mode= TRUE;
126 --let $assert_text= 'group_replication_single_primary_mode should be set to 1'
127 --let $assert_cond= [SELECT @@group_replication_single_primary_mode as value, value, 1] = 1
128 --source include/assert.inc
129
130 # assert that we can set to other values
131 SET GLOBAL group_replication_single_primary_mode= FALSE;
132 --let $assert_text= 'group_replication_single_primary_mode should be set to 0'
133 --let $assert_cond= [SELECT @@group_replication_single_primary_mode as value, value, 1] = 0
134 --source include/assert.inc
135 SET GLOBAL group_replication_single_primary_mode= -1;
136 --let $assert_text= 'group_replication_single_primary_mode should be set to 0'
137 --let $assert_cond= [SELECT @@group_replication_single_primary_mode as value, value, 1] = 0
138 --source include/assert.inc
139 SET GLOBAL group_replication_single_primary_mode= 100;
140 --let $assert_text= 'group_replication_single_primary_mode should be set to 1'
141 --let $assert_cond= [SELECT @@group_replication_single_primary_mode as value, value, 1] = 1
142 --source include/assert.inc
143
144 # assert that we cannot set enforce update everywhere checks
145 # when single primary mode is ON
146 SET GLOBAL group_replication_single_primary_mode= TRUE;
147 --error ER_WRONG_VALUE_FOR_VAR
148 SET GLOBAL group_replication_enforce_update_everywhere_checks= TRUE;
149
150 # set both to false
151 SET GLOBAL group_replication_single_primary_mode= FALSE;
152 --let $assert_text= 'group_replication_single_primary_mode should be set to 0'
153 --let $assert_cond= [SELECT @@group_replication_single_primary_mode as value, value, 1] = 0
154 --source include/assert.inc
155 SET GLOBAL group_replication_enforce_update_everywhere_checks= FALSE;
156 --let $assert_text= 'group_replication_enforce_update_everywhere_checks should be set to 0'
157 --let $assert_cond= [SELECT @@group_replication_enforce_update_everywhere_checks as value, value, 1] = 0
158 --source include/assert.inc
159
160 # Lets start a group with single_primary_mode ON
161 SET GLOBAL group_replication_single_primary_mode= TRUE;
162 --let $assert_text= 'group_replication_single_primary_mode should be set to 1'
163 --let $assert_cond= [SELECT @@group_replication_single_primary_mode as value, value, 1] = 1
164 --source include/assert.inc
165 SET GLOBAL group_replication_enforce_update_everywhere_checks= FALSE;
166 --let $assert_text= 'group_replication_enforce_update_everywhere_checks should be set to 0'
167 --let $assert_cond= [SELECT @@group_replication_enforce_update_everywhere_checks as value, value, 1] = 0
168 --source include/assert.inc
169
170 --echo #
171 --echo # START GROUP REPLICATION ON SERVER 1
172 --source include/start_and_bootstrap_group_replication.inc
173
174 --echo # PLUGIN VARIABLES SHOULD BE READ ONLY ON SERVER 1
175 --error ER_GROUP_REPLICATION_RUNNING
176 SET GLOBAL group_replication_single_primary_mode= TRUE;
177 --error ER_GROUP_REPLICATION_RUNNING
178 SET GLOBAL group_replication_enforce_update_everywhere_checks= TRUE;
179
180 --echo #
181 --echo # START GROUP REPLICATION ON SERVER 2
182 --let $rpl_connection_name= server2
183 --source include/rpl_connection.inc
184
185 SET GLOBAL group_replication_enforce_update_everywhere_checks= FALSE;
186 --let $assert_text= 'group_replication_enforce_update_everywhere_checks should be set to 0'
187 --let $assert_cond= [SELECT @@group_replication_enforce_update_everywhere_checks as value, value, 1] = 0
188 --source include/assert.inc
189 SET GLOBAL group_replication_single_primary_mode= TRUE;
190 --let $assert_text= 'group_replication_single_primary_mode should be set to 1'
191 --let $assert_cond= [SELECT @@group_replication_single_primary_mode as value, value, 1] = 1
192 --source include/assert.inc
193 --source include/start_group_replication.inc
194
195 --echo # PLUGIN VARIABLES SHOULD BE READ ONLY ON SERVER 2
196 --error ER_GROUP_REPLICATION_RUNNING
197 SET GLOBAL group_replication_single_primary_mode= TRUE;
198 --error ER_GROUP_REPLICATION_RUNNING
199 SET GLOBAL group_replication_enforce_update_everywhere_checks= TRUE;
200
201 --source include/group_replication_end.inc
202
203 # restore single primary mode configuration system variables
204 --let $rpl_connection_name= server1
205 --source include/rpl_connection.inc
206 --eval SET @@GLOBAL.group_replication_single_primary_mode= $saved_single_primary_mode
207 --eval SET @@GLOBAL.group_replication_enforce_update_everywhere_checks= $saved_enforce_update_everywhere_checks
208 --let $rpl_connection_name= server2
209 --source include/rpl_connection.inc
210 --eval SET @@GLOBAL.group_replication_single_primary_mode= $saved_single_primary_mode
211 --eval SET @@GLOBAL.group_replication_enforce_update_everywhere_checks= $saved_enforce_update_everywhere_checks