Debian Codegraph @

mysql-test/suite/rpl/t/rpl_change_master_without_stopping_slave.test

raw
1 # ==== Purpose ====
2 #
3 # This test script serves as the functionality testing for
4 # WL#6120- Change master without stopping Slave threads.
5 #
6 # This test script does the following:
7
8 # - Ensure that the behavior does not change for CHANGE MASTER when both the
9 # IO and SQL threads are stopped.
10 # - We have two types of options- receiver options and applier options under
11 # CHANGE MASTER
12 # And we have a very simple rule:
13 # - Allow setting receiver options when the receiver is not running,
14 # - Allow setting applier options when the applier is not running,
15
16 # Make sure we stick to the above mentioned rule.
17
18 # The follwing scenarios are tested:
19 #
20 # - With both receiver and applier stopped, all CHANGE MASTER options should be
21 # allowed.
22 # - With receiver stopped and applier running, we should be able to change
23 # receiver options.
24 # - Setting receiver options should throw the correct error message.
25 # - Using an allowed option and a not allowed option should error out.
26 # - With applier stopped and receiver running, we should be able to change
27 # applier options.
28 # - Setting applier options should throw the correct error message.
29 # - Using an allowed option and a not allowed option should error out.
30 #
31 # ==== Related Worklog(s) And Bug(s)====
32 #
33 # WL#6120- Change master without stopping Slave threads.
34 #
35
36 --let $rpl_privilege_checks_user_grant_option = 1
37 --source include/set_privilege_checks_user_as_system_user.inc
38 --source include/master-slave.inc
39 --source include/have_binlog_format_mixed.inc
40
41 --echo
42 --echo Create a replication user to use in change master tests.
43 --echo
44
45 --connection master
46 CREATE USER replssl@localhost REQUIRE SSL;
47 GRANT REPLICATION SLAVE ON *.* TO replssl@localhost;
48 --source include/sync_slave_sql_with_master.inc
49
50 --echo
51 --echo With both receiver and applier stopped, all CHANGE MASTER options should
52 --echo be allowed.
53 --echo
54
55 --source include/stop_slave.inc
56
57 let $master_log_file= query_get_value(SHOW SLAVE STATUS, Master_Log_File, 1);
58 let $master_log_pos= query_get_value(SHOW SLAVE STATUS, Read_Master_Log_Pos, 1);
59 let $master_id= query_get_value(SHOW SLAVE STATUS, Master_Server_Id, 1);
60
61 --let $save_autoposition= query_get_value(SHOW SLAVE STATUS, Auto_Position, 1)
62 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= 0;
63
64 --connection slave
65 --disable_query_log
66 replace_result $master_log_file MASTER_LOG_FILE;
67 replace_result $master_log_pos MASTER_LOG_POS;
68 replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR;
69 replace_column 2 ####;
70 eval CHANGE REPLICATION SOURCE TO
71 SOURCE_HOST= 'localhost',
72 SOURCE_USER= 'replssl',
73 SOURCE_PASSWORD= '',
74 SOURCE_PORT= $MASTER_MYPORT,
75 SOURCE_CONNECT_RETRY= 20,
76 SOURCE_RETRY_COUNT= 1,
77 SOURCE_DELAY= 20,
78 SOURCE_LOG_FILE= '$master_log_file',
79 SOURCE_LOG_POS= $master_log_pos,
80 SOURCE_HEARTBEAT_PERIOD= 20,
81 IGNORE_SERVER_IDS= ($master_id),
82 SOURCE_AUTO_POSITION= 0,
83 SOURCE_SSL= 1,
84 SOURCE_SSL_CA= '$MYSQL_TEST_DIR/std_data/cacert.pem',
85 SOURCE_SSL_CERT= '$MYSQL_TEST_DIR/std_data/client-cert.pem',
86 SOURCE_SSL_KEY= '$MYSQL_TEST_DIR/std_data/client-key.pem',
87 SOURCE_SSL_VERIFY_SERVER_CERT= 1;
88
89 --enable_query_log
90
91 let $relay_log_file= query_get_value(SHOW SLAVE STATUS, Relay_Log_File, 1);
92 --replace_result $relay_log_file RELAY_LOG_FILE
93 eval CHANGE REPLICATION SOURCE TO RELAY_LOG_FILE= '$relay_log_file';
94
95 let $relay_log_pos= query_get_value(SHOW SLAVE STATUS, Relay_Log_Pos, 1);
96 --replace_result $relay_log_pos RELAY_LOG_POS
97 eval CHANGE REPLICATION SOURCE TO RELAY_LOG_POS= $relay_log_pos;
98
99 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= 1;
100 #Re-setting auto_position=0 to continue testing position related options.
101 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= 0;
102
103 --echo
104 --echo With receiver stopped and applier running, we should be able to change
105 --echo receiver options. Setting applier options should throw the correct error
106 --echo message.
107 --echo
108
109 --source include/start_slave_sql.inc
110 --disable_query_log
111 replace_result $master_log_file MASTER_LOG_FILE;
112 replace_result $master_log_pos MASTER_LOG_POS;
113 replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR;
114 replace_column 2 ####;
115 eval CHANGE REPLICATION SOURCE TO
116 SOURCE_HOST= 'localhost',
117 SOURCE_USER= 'replssl',
118 SOURCE_PASSWORD= '',
119 SOURCE_PORT= $MASTER_MYPORT,
120 SOURCE_CONNECT_RETRY= 20,
121 SOURCE_RETRY_COUNT= 1,
122 SOURCE_LOG_FILE= '$master_log_file',
123 SOURCE_LOG_POS= $master_log_pos,
124 SOURCE_HEARTBEAT_PERIOD= 20,
125 IGNORE_SERVER_IDS= ($master_id),
126 SOURCE_SSL= 1,
127 SOURCE_SSL_CA= '$MYSQL_TEST_DIR/std_data/cacert.pem',
128 SOURCE_SSL_CERT= '$MYSQL_TEST_DIR/std_data/client-cert.pem',
129 SOURCE_SSL_KEY= '$MYSQL_TEST_DIR/std_data/client-key.pem',
130 SOURCE_SSL_VERIFY_SERVER_CERT= 1;
131 --enable_query_log
132
133 # Now on to some negative testing
134
135 # Both receiver and applier needs to be stopped to set the auto_position option.
136 --error ER_REPLICA_CHANNEL_MUST_STOP
137 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= 1;
138
139 --error ER_REPLICA_CHANNEL_MUST_STOP
140 CHANGE REPLICATION SOURCE TO ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS = LOCAL;
141
142 # Since the applier is running, using the applier options should error out.
143 --replace_result $relay_log_file RELAY_LOG_FILE
144 --error ER_REPLICA_CHANNEL_SQL_THREAD_MUST_STOP
145 eval CHANGE REPLICATION SOURCE TO RELAY_LOG_FILE= '$relay_log_file';
146
147 --replace_result $relay_log_pos RELAY_LOG_POS
148 --error ER_REPLICA_CHANNEL_SQL_THREAD_MUST_STOP
149 eval CHANGE REPLICATION SOURCE TO RELAY_LOG_POS= $relay_log_pos;
150
151 --error ER_REPLICA_CHANNEL_SQL_THREAD_MUST_STOP
152 CHANGE REPLICATION SOURCE TO SOURCE_DELAY= 10;
153
154 # Using an allowed option and a not allowed option should throw an error.
155 --replace_result $relay_log_file RELAY_LOG_FILE
156 --error ER_REPLICA_CHANNEL_SQL_THREAD_MUST_STOP
157 eval CHANGE REPLICATION SOURCE TO SOURCE_RETRY_COUNT= 1, RELAY_LOG_FILE= '$relay_log_file';
158
159 --replace_result $relay_log_pos RELAY_LOG_POS
160 --error ER_REPLICA_CHANNEL_SQL_THREAD_MUST_STOP
161 eval CHANGE REPLICATION SOURCE TO SOURCE_RETRY_COUNT= 1, RELAY_LOG_POS= $relay_log_pos;
162
163 --error ER_REPLICA_CHANNEL_SQL_THREAD_MUST_STOP
164 CHANGE REPLICATION SOURCE TO SOURCE_RETRY_COUNT= 1, SOURCE_DELAY=10;
165
166 --echo
167 --echo With applier stopped and receiver running, we should be able to change
168 --echo applier options. Setting receiver options should throw the correct error
169 --echo message.
170 --echo
171
172 --source include/stop_slave_sql.inc
173 --source include/start_slave_io.inc
174
175 --replace_result $relay_log_file RELAY_LOG_FILE
176 eval CHANGE REPLICATION SOURCE TO RELAY_LOG_FILE= '$relay_log_file';
177
178 --replace_result $relay_log_pos RELAY_LOG_POS
179 eval CHANGE REPLICATION SOURCE TO RELAY_LOG_POS= $relay_log_pos;
180
181 CHANGE REPLICATION SOURCE TO SOURCE_DELAY= 10;
182
183 # Now on to some negative testing
184
185 # Both receiver and applier needs to be stopped to set the auto_position option.
186 --error ER_REPLICA_CHANNEL_MUST_STOP
187 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= 1;
188
189 --error ER_REPLICA_CHANNEL_IO_THREAD_MUST_STOP
190 CHANGE REPLICATION SOURCE TO SOURCE_HOST= 'localhost';
191 --error ER_REPLICA_CHANNEL_IO_THREAD_MUST_STOP
192 CHANGE REPLICATION SOURCE TO SOURCE_USER= 'replssl';
193 --error ER_REPLICA_CHANNEL_IO_THREAD_MUST_STOP
194 CHANGE REPLICATION SOURCE TO SOURCE_PASSWORD= '';
195
196 --disable_query_log
197 --error ER_REPLICA_CHANNEL_IO_THREAD_MUST_STOP
198 eval CHANGE REPLICATION SOURCE TO SOURCE_PORT= $MASTER_MYPORT;
199 --enable_query_log
200
201 --error ER_REPLICA_CHANNEL_IO_THREAD_MUST_STOP
202 CHANGE REPLICATION SOURCE TO SOURCE_CONNECT_RETRY= 20;
203 --error ER_REPLICA_CHANNEL_IO_THREAD_MUST_STOP
204 CHANGE REPLICATION SOURCE TO SOURCE_RETRY_COUNT= 1;
205
206 --disable_query_log
207 --replace_result $master_log_file MASTER_LOG_FILE
208 --error ER_REPLICA_CHANNEL_IO_THREAD_MUST_STOP
209 eval CHANGE REPLICATION SOURCE TO SOURCE_LOG_FILE= '$master_log_file';
210 --replace_result $master_log_pos MASTER_LOG_POS
211 --error ER_REPLICA_CHANNEL_IO_THREAD_MUST_STOP
212 eval CHANGE REPLICATION SOURCE TO SOURCE_LOG_POS= $master_log_pos;
213 --enable_query_log
214
215 --error ER_REPLICA_CHANNEL_IO_THREAD_MUST_STOP
216 CHANGE REPLICATION SOURCE TO SOURCE_HEARTBEAT_PERIOD= 20;
217 --error ER_REPLICA_CHANNEL_IO_THREAD_MUST_STOP
218 CHANGE REPLICATION SOURCE TO SOURCE_SSL= 1;
219
220 --disable_query_log
221 --error ER_REPLICA_CHANNEL_IO_THREAD_MUST_STOP
222 eval CHANGE REPLICATION SOURCE TO SOURCE_SSL_CA= '$MYSQL_TEST_DIR/std_data/cacert.pem';
223 --error ER_REPLICA_CHANNEL_IO_THREAD_MUST_STOP
224 eval CHANGE REPLICATION SOURCE TO SOURCE_SSL_CERT= '$MYSQL_TEST_DIR/std_data/client-cert.pem';
225 --error ER_REPLICA_CHANNEL_IO_THREAD_MUST_STOP
226 eval CHANGE REPLICATION SOURCE TO SOURCE_SSL_KEY= '$MYSQL_TEST_DIR/std_data/client-key.pem';
227 --enable_query_log
228
229 --error ER_REPLICA_CHANNEL_IO_THREAD_MUST_STOP
230 CHANGE REPLICATION SOURCE TO SOURCE_SSL_VERIFY_SERVER_CERT= 1;
231
232 # Using an allowed option and a not allowed option should throw an error.
233
234 --error ER_REPLICA_CHANNEL_IO_THREAD_MUST_STOP
235 CHANGE REPLICATION SOURCE TO SOURCE_DELAY=10, SOURCE_HOST= 'localhost';
236 --error ER_REPLICA_CHANNEL_IO_THREAD_MUST_STOP
237 CHANGE REPLICATION SOURCE TO SOURCE_DELAY=10, SOURCE_USER= 'replssl';
238 --error ER_REPLICA_CHANNEL_IO_THREAD_MUST_STOP
239 CHANGE REPLICATION SOURCE TO SOURCE_DELAY=10, SOURCE_PASSWORD= '';
240
241 --disable_query_log
242 --error ER_REPLICA_CHANNEL_IO_THREAD_MUST_STOP
243 eval CHANGE REPLICATION SOURCE TO SOURCE_DELAY=10, SOURCE_PORT= $MASTER_MYPORT;
244 --enable_query_log
245
246 --error ER_REPLICA_CHANNEL_IO_THREAD_MUST_STOP
247 CHANGE REPLICATION SOURCE TO SOURCE_DELAY=10, SOURCE_CONNECT_RETRY= 20;
248 --error ER_REPLICA_CHANNEL_IO_THREAD_MUST_STOP
249 CHANGE REPLICATION SOURCE TO SOURCE_DELAY=10, SOURCE_RETRY_COUNT= 1;
250
251 --disable_query_log
252 --replace_result $master_log_file MASTER_LOG_FILE
253 --error ER_REPLICA_CHANNEL_IO_THREAD_MUST_STOP
254 eval CHANGE REPLICATION SOURCE TO SOURCE_DELAY= 10, SOURCE_LOG_FILE= '$master_log_file';
255 --replace_result $master_log_pos MASTER_LOG_POS
256 --error ER_REPLICA_CHANNEL_IO_THREAD_MUST_STOP
257 eval CHANGE REPLICATION SOURCE TO SOURCE_DELAY= 10, SOURCE_LOG_POS= $master_log_pos;
258 --enable_query_log
259
260 --error ER_REPLICA_CHANNEL_IO_THREAD_MUST_STOP
261 CHANGE REPLICATION SOURCE TO SOURCE_DELAY= 10, SOURCE_HEARTBEAT_PERIOD= 20;
262 --error ER_REPLICA_CHANNEL_IO_THREAD_MUST_STOP
263 CHANGE REPLICATION SOURCE TO SOURCE_DELAY=10, SOURCE_SSL=1;
264
265 --disable_query_log
266 --error ER_REPLICA_CHANNEL_IO_THREAD_MUST_STOP
267 eval CHANGE REPLICATION SOURCE TO SOURCE_DELAY=10, SOURCE_SSL_CA ='$MYSQL_TEST_DIR/std_data/cacert.pem';
268 --error ER_REPLICA_CHANNEL_IO_THREAD_MUST_STOP
269 eval CHANGE REPLICATION SOURCE TO SOURCE_DELAY=10, SOURCE_SSL_CERT= '$MYSQL_TEST_DIR/std_data/client-cert.pem';
270 --error ER_REPLICA_CHANNEL_IO_THREAD_MUST_STOP
271 eval CHANGE REPLICATION SOURCE TO SOURCE_DELAY=10, SOURCE_SSL_KEY= '$MYSQL_TEST_DIR/std_data/client-key.pem';
272 --enable_query_log
273
274 --error ER_REPLICA_CHANNEL_IO_THREAD_MUST_STOP
275 CHANGE REPLICATION SOURCE TO SOURCE_DELAY= 10, SOURCE_SSL_VERIFY_SERVER_CERT= 1;
276
277 --source include/stop_slave.inc
278
279 --echo
280 --echo cleanup
281 --echo
282
283 replace_column 2 ####;
284 eval CHANGE REPLICATION SOURCE TO
285 SOURCE_HOST= '127.0.0.1',
286 SOURCE_USER= 'root',
287 SOURCE_DELAY= 0,
288 IGNORE_SERVER_IDS= (),
289 SOURCE_SSL= 0,
290 SOURCE_SSL_CA= '',
291 SOURCE_SSL_CERT= '',
292 SOURCE_SSL_KEY= '',
293 SOURCE_SSL_VERIFY_SERVER_CERT= 0;
294
295 --replace_result $save_autoposition SAVE_AUTOPOSITION
296 eval CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= $save_autoposition;
297
298 --source include/start_slave.inc
299
300 --connection master
301 DROP USER replssl@localhost;
302
303 --source include/rpl_end.inc