Debian Codegraph @

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

raw
1 #############################################################
2 # Author: Serge Kozlov <[email protected]>
3 # Date: 02/19/2009
4 # Purpose: Testing basic functionality of heartbeat.
5 # Description:
6 # * Testing different values for slave_heartbeat_period.
7 # * How to affect various statements to slave_heartbeat_period
8 # * Various states of slave and heartbeat
9 # * Various states of master and heartbeat
10 # * Circular replication
11 #############################################################
12 --source include/long_test.inc
13 --source include/master-slave.inc
14 #
15 # The test runs long and does not have any specifics to
16 # binlog_format. It is chosen therefore to run with MIXED mode
17 # in order to not slow down much `make test'.
18 #
19 --source include/have_binlog_format_mixed.inc
20 --echo
21
22 --enable_prepare_warnings
23
24 # Set number of retries to connect to master
25 let $connect_retry= 20;
26
27 --echo *** Preparing ***
28 --connection slave
29 --source include/stop_slave.inc
30 RESET SLAVE;
31 SET @restore_slave_net_timeout=@@global.slave_net_timeout;
32 let $slave_heartbeat_timeout= query_get_value(SHOW GLOBAL STATUS LIKE 'slave_heartbeat_period', Value, 1);
33 --disable_query_log
34 eval SET @restore_slave_heartbeat_timeout=$slave_heartbeat_timeout;
35 --enable_query_log
36
37 --connection master
38 RESET MASTER;
39 SET @restore_slave_net_timeout=@@global.slave_net_timeout;
40 --echo
41
42 #
43 # Test slave_heartbeat_period
44 #
45
46 --connection slave
47
48 # Default value of slave_heartbeat_timeout = slave_net_timeout/2
49 --echo *** Default value ***
50 --replace_result $MASTER_MYPORT MASTER_PORT
51 eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT, MASTER_USER='root';
52 let $slave_net_timeout= query_get_value(SHOW VARIABLES LIKE 'slave_net_timeout', Value, 1);
53 let $slave_heartbeat_timeout= query_get_value(SHOW GLOBAL STATUS LIKE 'slave_heartbeat_period', Value, 1);
54 let $result= query_get_value(SELECT $slave_net_timeout/$slave_heartbeat_timeout AS Result, Result, 1);
55 --echo slave_net_timeout/slave_heartbeat_timeout=$result
56 --source include/reset_slave.inc
57 --echo
58
59 # Reset slave set slave_heartbeat_timeout = slave_net_timeout/2
60 --echo *** Reset slave affect ***
61 --disable_warnings
62 SET @@global.slave_net_timeout=30;
63 --enable_warnings
64 --replace_result $MASTER_MYPORT MASTER_PORT
65 eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT, MASTER_USER='root', MASTER_CONNECT_RETRY=$connect_retry, MASTER_HEARTBEAT_PERIOD=5;
66 --source include/reset_slave.inc
67 SHOW GLOBAL STATUS LIKE 'slave_heartbeat_period';
68 --echo
69
70 # Check default value of slave_heartbeat_timeout if slave_net_timeout is changed
71 --echo *** Default value if slave_net_timeout changed ***
72 --disable_warnings
73 SET @@global.slave_net_timeout=50;
74 --enable_warnings
75 --replace_result $MASTER_MYPORT MASTER_PORT
76 eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT, MASTER_USER='root', MASTER_CONNECT_RETRY=$connect_retry;
77 SHOW GLOBAL STATUS LIKE 'slave_heartbeat_period';
78 SET @@global.slave_net_timeout=@restore_slave_net_timeout;
79 --source include/reset_slave.inc
80 --echo
81
82 # Set slave_net_timeout less than current value of slave_heartbeat_period
83 --echo *** Warning if updated slave_net_timeout < slave_heartbeat_timeout ***
84 let $slave_heartbeat_timeout= query_get_value(SHOW GLOBAL STATUS LIKE 'slave_heartbeat_period', Value, 1);
85 --replace_result $slave_heartbeat_timeout SLAVE_HEARTBEAT_TIMEOUT
86 eval SET @@global.slave_net_timeout=FLOOR($slave_heartbeat_timeout)-1;
87 SET @@global.slave_net_timeout=@restore_slave_net_timeout;
88 RESET SLAVE;
89 --echo
90
91 # Set value of slave_heartbeat_period greater than slave_net_timeout
92 --echo *** Warning if updated slave_heartbeat_timeout > slave_net_timeout ***
93 let $slave_net_timeout= query_get_value(SHOW VARIABLES LIKE 'slave_net_timeout', Value, 1);
94 inc $slave_net_timeout;
95 --replace_result $MASTER_MYPORT MASTER_PORT $slave_net_timeout SLAVE_NET_TIMEOUT
96 eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT, MASTER_USER='root', MASTER_CONNECT_RETRY=$connect_retry, MASTER_HEARTBEAT_PERIOD=$slave_net_timeout;
97 RESET SLAVE;
98 --echo
99
100 # Changing of slave_net_timeout shouldn't affect to current value of slave_heartbeat_period
101 --echo *** CHANGE MASTER statement only updates slave_heartbeat_period ***
102 --disable_warnings
103 SET @@global.slave_net_timeout=20;
104 --enable_warnings
105 --replace_result $MASTER_MYPORT MASTER_PORT
106 eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT, MASTER_USER='root', MASTER_CONNECT_RETRY=$connect_retry, MASTER_HEARTBEAT_PERIOD=5;
107 SHOW VARIABLES LIKE 'slave_net_timeout';
108 SHOW GLOBAL STATUS LIKE 'slave_heartbeat_period';
109 SET @@global.slave_net_timeout=2*@@global.slave_net_timeout;
110 SHOW VARIABLES LIKE 'slave_net_timeout';
111 SHOW GLOBAL STATUS LIKE 'slave_heartbeat_period';
112 SET @@global.slave_net_timeout=@restore_slave_net_timeout;
113 RESET SLAVE;
114 --echo
115
116 # Master value of slave_net_timeout shouldn't affect to slave's slave_heartbeat_period
117 --echo *** Update slave_net_timeout on master ***
118 --connection master
119 --disable_warnings
120 SET @@global.slave_net_timeout=500;
121 --enable_warnings
122 --connection slave
123 SET @@global.slave_net_timeout=200;
124 RESET SLAVE;
125 --replace_result $MASTER_MYPORT MASTER_PORT
126 eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT, MASTER_USER='root', MASTER_CONNECT_RETRY=$connect_retry;
127 --source include/start_slave.inc
128 --connection master
129 --sync_slave_with_master
130 SHOW VARIABLES LIKE 'slave_net_timeout';
131 SHOW GLOBAL STATUS LIKE 'slave_heartbeat_period';
132 SET @@global.slave_net_timeout=@restore_slave_net_timeout;
133 --source include/stop_slave.inc
134 RESET SLAVE;
135 --connection master
136 SET @@global.slave_net_timeout=@restore_slave_net_timeout;
137 --echo
138
139 # Start/stop slave shouldn't change slave_heartbeat_period
140 --echo *** Start/stop slave ***
141 --connection slave
142 --disable_warnings
143 SET @@global.slave_net_timeout=100;
144 --enable_warnings
145 --replace_result $MASTER_MYPORT MASTER_PORT
146 eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT, MASTER_USER='root', MASTER_CONNECT_RETRY=$connect_retry, MASTER_HEARTBEAT_PERIOD=20;
147 --source include/start_slave.inc
148 --connection master
149 --sync_slave_with_master
150 SHOW GLOBAL STATUS LIKE 'slave_heartbeat_period';
151 --source include/stop_slave.inc
152 SHOW GLOBAL STATUS LIKE 'slave_heartbeat_period';
153 --echo
154
155 # Reload slave shouldn't change slave_heartbeat_period
156 --echo *** Reload slave ***
157 --connection slave
158 --disable_warnings
159 SET @@global.slave_net_timeout=50;
160 --enable_warnings
161 --replace_result $MASTER_MYPORT MASTER_PORT
162 eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT, MASTER_USER='root', MASTER_CONNECT_RETRY=$connect_retry, MASTER_HEARTBEAT_PERIOD=30;
163 --let $rpl_server_number= 2
164 --source include/rpl_restart_server.inc
165 SHOW GLOBAL STATUS LIKE 'slave_heartbeat_period';
166 SET @restore_slave_net_timeout=@@global.slave_net_timeout;
167 --echo
168
169 # Disable heartbeat
170 --echo *** Disable heartbeat ***
171 --replace_result $MASTER_MYPORT MASTER_PORT
172 eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT, MASTER_USER='root', MASTER_CONNECT_RETRY=$connect_retry, MASTER_HEARTBEAT_PERIOD=0;
173 SHOW GLOBAL STATUS LIKE 'slave_heartbeat_period';
174 SHOW STATUS LIKE 'slave_received_heartbeats';
175 --source include/start_slave.inc
176 --connection master
177 --sync_slave_with_master
178 --sleep 2
179 SHOW GLOBAL STATUS LIKE 'slave_heartbeat_period';
180 SHOW STATUS LIKE 'slave_received_heartbeats';
181 --source include/stop_slave.inc
182 SHOW GLOBAL STATUS LIKE 'slave_heartbeat_period';
183 SHOW STATUS LIKE 'slave_received_heartbeats';
184 RESET SLAVE;
185 let $slave_heartbeat_timeout= query_get_value(SHOW GLOBAL STATUS LIKE 'slave_heartbeat_period', Value, 1);
186 --replace_result $slave_heartbeat_timeout SLAVE_HEARTBEAT_TIMEOUT
187 --eval SELECT $slave_heartbeat_timeout = 0 AS Result
188 --echo
189
190 #
191 # Check limits for slave_heartbeat_timeout
192 #
193
194 --echo *** Min slave_heartbeat_timeout ***
195 --replace_result $MASTER_MYPORT MASTER_PORT
196 eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT, MASTER_USER='root', MASTER_CONNECT_RETRY=$connect_retry, MASTER_HEARTBEAT_PERIOD=0.001;
197 SHOW GLOBAL STATUS LIKE 'slave_heartbeat_period';
198 RESET SLAVE;
199 --replace_result $MASTER_MYPORT MASTER_PORT
200 eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT, MASTER_USER='root', MASTER_CONNECT_RETRY=$connect_retry, MASTER_HEARTBEAT_PERIOD=0.0009;
201 SHOW GLOBAL STATUS LIKE 'slave_heartbeat_period';
202 RESET SLAVE;
203 --echo
204
205 --echo *** Max slave_heartbeat_timeout ***
206 --replace_result $MASTER_MYPORT MASTER_PORT
207 eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT, MASTER_USER='root', MASTER_CONNECT_RETRY=$connect_retry, MASTER_HEARTBEAT_PERIOD=4294967;
208 SHOW GLOBAL STATUS LIKE 'slave_heartbeat_period';
209 RESET SLAVE;
210 --replace_result $MASTER_MYPORT MASTER_PORT
211 --error ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE
212 eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT, MASTER_USER='root', MASTER_CONNECT_RETRY=$connect_retry, MASTER_HEARTBEAT_PERIOD=4294968;
213 RESET SLAVE;
214 # Check double size of max allowed value for master_heartbeat_period
215 --replace_result $MASTER_MYPORT MASTER_PORT
216 --error ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE
217 eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT, MASTER_USER='root', MASTER_CONNECT_RETRY=$connect_retry, MASTER_HEARTBEAT_PERIOD=8589935;
218 RESET SLAVE;
219 # Check 2^32
220 --replace_result $MASTER_MYPORT MASTER_PORT
221 --error ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE
222 eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT, MASTER_USER='root', MASTER_CONNECT_RETRY=$connect_retry, MASTER_HEARTBEAT_PERIOD=4294967296;
223 RESET SLAVE;
224 --echo
225
226 --echo *** Misc incorrect values ***
227 --replace_result $MASTER_MYPORT MASTER_PORT
228 --error ER_PARSE_ERROR
229 eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT, MASTER_USER='root', MASTER_CONNECT_RETRY=$connect_retry, MASTER_HEARTBEAT_PERIOD='-1';
230 RESET SLAVE;
231 --replace_result $MASTER_MYPORT MASTER_PORT
232 --error ER_PARSE_ERROR
233 eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT, MASTER_USER='root', MASTER_CONNECT_RETRY=$connect_retry, MASTER_HEARTBEAT_PERIOD='123abc';
234 RESET SLAVE;
235 --replace_result $MASTER_MYPORT MASTER_PORT
236 --error ER_PARSE_ERROR
237 eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT, MASTER_USER='root', MASTER_CONNECT_RETRY=$connect_retry, MASTER_HEARTBEAT_PERIOD='';
238 RESET SLAVE;
239 --echo
240
241 #
242 # MDEV-38454: MASTER_HEARTBEAT_PERIOD should accept values with + sign
243 #
244 --echo *** MDEV-38454: MASTER_HEARTBEAT_PERIOD should accept + sign ***
245 # Test with + sign (was broken before fix)
246 --replace_result $MASTER_MYPORT MASTER_PORT
247 eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT, MASTER_USER='root', MASTER_CONNECT_RETRY=$connect_retry, MASTER_HEARTBEAT_PERIOD=+60;
248 SHOW GLOBAL STATUS LIKE 'slave_heartbeat_period';
249 RESET SLAVE;
250 # Test without + sign (should still work)
251 --replace_result $MASTER_MYPORT MASTER_PORT
252 eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT, MASTER_USER='root', MASTER_CONNECT_RETRY=$connect_retry, MASTER_HEARTBEAT_PERIOD=60;
253 SHOW GLOBAL STATUS LIKE 'slave_heartbeat_period';
254 RESET SLAVE;
255 --echo
256
257 #
258 # Testing heartbeat
259 #
260
261 # Check received heartbeat events for running slave
262 --echo *** Running slave ***
263 --replace_result $MASTER_MYPORT MASTER_PORT
264 eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT, MASTER_USER='root', MASTER_CONNECT_RETRY=$connect_retry, MASTER_HEARTBEAT_PERIOD=0.1;
265 --source include/start_slave.inc
266 --connection master
267 --sync_slave_with_master
268 let $status_var_value= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
269 let $status_var= slave_received_heartbeats;
270 let $status_var_comparsion= >;
271 --source include/wait_for_status_var.inc
272 --echo Heartbeat event received
273 --echo
274
275 # Check received heartbeat events for stopped slave
276 --echo *** Stopped slave ***
277 --source include/stop_slave.inc
278 let $rcvd_heartbeats_before= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
279 sleep 2;
280 let $rcvd_heartbeats_after= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
281 let $result= query_get_value(SELECT ($rcvd_heartbeats_after - $rcvd_heartbeats_before) AS Result, Result, 1);
282 --echo Number of received heartbeat events while slave stopped: $result
283 --echo
284
285 # Check received heartbeat events for started slave
286 --echo *** Started slave ***
287 --source include/start_slave.inc
288 let $status_var_value= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
289 --source include/wait_for_status_var.inc
290 --echo Heartbeat event received
291 --echo
292
293 # Check received heartbeat events for stopped IO thread
294 --echo *** Stopped IO thread ***
295 --source include/stop_slave_io.inc
296 let $rcvd_heartbeats_before= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
297 sleep 2;
298 let $rcvd_heartbeats_after= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
299 let $result= query_get_value(SELECT ($rcvd_heartbeats_after - $rcvd_heartbeats_before) AS Result, Result, 1);
300 --echo Number of received heartbeat events while io thread stopped: $result
301 --echo
302
303 # Check received heartbeat events for started IO thread
304 --echo *** Started IO thread ***
305 START SLAVE IO_THREAD;
306 --source include/wait_for_slave_io_to_start.inc
307 let $status_var_value= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
308 --source include/wait_for_status_var.inc
309 --echo Heartbeat event received
310 --echo
311
312 # Check received heartbeat events for stopped SQL thread
313 --echo *** Stopped SQL thread ***
314 --source include/stop_slave_sql.inc
315 let $rcvd_heartbeats_before= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
316 sleep 2;
317 let $rcvd_heartbeats_after= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
318 let $result= query_get_value(SELECT ($rcvd_heartbeats_after - $rcvd_heartbeats_before) > 0 AS Result, Result, 1);
319 --echo Heartbeat events are received while sql thread stopped (1 means 'yes'): $result
320 --echo
321
322 # Check received heartbeat events for started SQL thread
323 --echo *** Started SQL thread ***
324 START SLAVE SQL_THREAD;
325 --source include/wait_for_slave_sql_to_start.inc
326 let $status_var_value= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
327 --source include/wait_for_status_var.inc
328 --echo Heartbeat event received
329 --echo
330
331 # Check received heartbeat event for stopped SQL thread by error
332 --echo *** Stopped SQL thread by error ***
333 --connection master
334 CREATE TABLE t1 (a INT PRIMARY KEY, b VARCHAR(10), c LONGTEXT);
335 --sync_slave_with_master
336 INSERT INTO t1 VALUES (1, 'on slave', NULL);
337 --connection master
338 INSERT INTO t1 VALUES (1, 'on master', NULL);
339 --connection slave
340 set sql_log_bin= 0;
341 call mtr.add_suppression("Slave SQL.*Duplicate entry .1. for key .PRIMARY.. on query.* error.* 1062");
342 call mtr.add_suppression("Slave SQL.*Request to stop slave SQL Thread received while applying a group that has non-transactional changes; waiting for completion of the group");
343 set sql_log_bin= 1;
344 let $slave_errno= ER_DUP_ENTRY
345 --source include/wait_for_slave_sql_error.inc
346 let $rcvd_heartbeats_before= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
347 sleep 4;
348 let $rcvd_heartbeats_after= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
349 let $result= query_get_value(SELECT ($rcvd_heartbeats_after - $rcvd_heartbeats_before) > 0 AS Result, Result, 1);
350 --echo Heartbeat events are received while sql thread stopped (1 means 'yes'): $result
351 --source include/stop_slave_io.inc
352 set sql_log_bin= 0;
353 DROP TABLE t1;
354 set sql_log_bin= 1;
355 --echo
356
357 # Check received heartbeat events while master send events to slave
358 --echo *** Master send to slave ***
359 --connection master
360 # Create the event that will update table t1 every second
361 DELIMITER |;
362 CREATE EVENT e1
363 ON SCHEDULE EVERY 1 SECOND
364 DO
365 BEGIN
366 UPDATE test.t1 SET a = a + 1 WHERE a < 10;
367 END|
368 DELIMITER ;|
369 --connection slave
370 --source include/reset_slave.inc
371 --replace_result $MASTER_MYPORT MASTER_PORT
372 eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT, MASTER_USER='root', MASTER_CONNECT_RETRY=$connect_retry, MASTER_HEARTBEAT_PERIOD=5;
373 --source include/start_slave.inc
374 --connection master
375 # Enable scheduler
376 SET @@global.event_scheduler=1;
377
378 --sync_slave_with_master
379 let $rcvd_heartbeats_before= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
380
381 --connection master
382
383 # Whether or not to send a heartbeat is decided on the master, based on
384 # whether the binlog was updated during the period or not.
385 # Even with the 1-second event, we cannot make the master to write binary
386 # logs (or execute SQL) in a timely manner. We can only check that they
387 # were executed in a timely manner, and if they were not, neutralize the
388 # heartbeat check on the slave.
389 # We will wait for 5 events, and keep checking 'Binlog_commits' on master.
390 # Time interval between consequent events will be measured.
391 # We can only expect that no heartbeats have been sent if the interval
392 # between events never exceeded MASTER_HEARTBEAT_PERIOD.
393 # If it has exceeded the value at least once, the slave can legitimately
394 # receive a heartbeat (but we cannot require it, because the delay
395 # could have occurred somewhere else, e.g. upon checking the status).
396 # So, if the delay is detected, we will signal slave to ignore possible
397 # heartbeats.
398
399 let $possible_heartbeats= 0;
400 let $commits_to_wait= 5;
401 while ($commits_to_wait)
402 {
403 let $tm= `SELECT UNIX_TIMESTAMP(NOW(3))`;
404 let $binlog_commits= query_get_value(SHOW STATUS LIKE 'Binlog_commits', Value, 1);
405 let $wait_condition= SELECT VARIABLE_VALUE > $binlog_commits FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME= 'BINLOG_COMMITS';
406 --source include/wait_condition.inc
407 dec $commits_to_wait;
408 if (`SELECT UNIX_TIMESTAMP(NOW(3)) > $tm + 5`)
409 {
410 let $possible_heartbeats= 1;
411 let $commits_to_wait= 0;
412 }
413 }
414
415 --connection slave
416 let $rcvd_heartbeats_after= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
417 let $result= `SELECT CASE WHEN $possible_heartbeats THEN 'TRUE' WHEN $rcvd_heartbeats_after - $rcvd_heartbeats_before > 0 THEN 'FALSE' ELSE 'TRUE' END`;
418 --echo Received heartbeats meet expectations: $result
419 --connection master
420 DELETE FROM t1;
421 DROP EVENT e1;
422 --sync_slave_with_master
423 --echo
424
425 # Check received heartbeat events while logs flushed on slave
426 --echo *** Flush logs on slave ***
427 STOP SLAVE;
428 --source include/reset_slave.inc
429 set sql_log_bin= 0;
430 DROP TABLE t1;
431 set sql_log_bin= 1;
432 --connection master
433 DROP TABLE t1;
434 RESET MASTER;
435 --connection slave
436 --replace_result $MASTER_MYPORT MASTER_PORT
437 eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT, MASTER_USER='root', MASTER_CONNECT_RETRY=$connect_retry, MASTER_HEARTBEAT_PERIOD=0.5;
438 let $slave_param_comparison= =;
439 --source include/start_slave.inc
440 let $rcvd_heartbeats_before= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
441 # Flush logs every 0.1 second during 5 sec
442 --disable_query_log
443 let $i=100;
444 while ($i) {
445 FLUSH LOGS;
446 dec $i;
447 sleep 0.1;
448 }
449 --enable_query_log
450 let $rcvd_heartbeats_after= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
451 let $result= query_get_value(SELECT ($rcvd_heartbeats_after - $rcvd_heartbeats_before) > 0 AS Result, Result, 1);
452 --echo Heartbeat events are received while rotation of relay logs (1 means 'yes'): $result
453 --echo
454
455 # Use compressed protocol between master and slave
456 --echo *** Compressed protocol ***
457 --connection master
458 SET @@global.slave_compressed_protocol=1;
459 --connection slave
460 --source include/stop_slave.inc
461 --source include/reset_slave.inc
462 SET @@global.slave_compressed_protocol=1;
463 --replace_result $MASTER_MYPORT MASTER_PORT
464 eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT, MASTER_USER='root', MASTER_CONNECT_RETRY=$connect_retry, MASTER_HEARTBEAT_PERIOD=0.1;
465 --source include/start_slave.inc
466 let $status_var_value= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
467 let $status_var= slave_received_heartbeats;
468 let $status_var_comparsion= >;
469 --source include/wait_for_status_var.inc
470 --echo Heartbeat event received
471 SET @@global.slave_compressed_protocol=0;
472 --connection master
473 SET @@global.slave_compressed_protocol=0;
474 --echo
475
476
477 # Check received heartbeat events after reset of master
478 --echo *** Reset master ***
479 --connection slave
480 STOP SLAVE;
481 --source include/reset_slave.inc
482 --replace_result $MASTER_MYPORT MASTER_PORT
483 eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT, MASTER_USER='root', MASTER_CONNECT_RETRY=$connect_retry, MASTER_HEARTBEAT_PERIOD=0.1;
484 --source include/start_slave.inc
485 let $rcvd_heartbeats_before= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
486 --connection master
487 RESET MASTER;
488 --enable_query_log
489 --sync_slave_with_master
490 --sleep 2
491 let $rcvd_heartbeats_after= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
492 let $result= query_get_value(SELECT ($rcvd_heartbeats_after - $rcvd_heartbeats_before) > 0 AS Result, Result, 1);
493 --echo Heartbeat events are received after reset of master (1 means 'yes'): $result
494 --echo
495
496 # Reloaded master should restore heartbeat
497 --echo *** Reload master ***
498 --connection slave
499 STOP SLAVE;
500 --source include/reset_slave.inc
501 --replace_result $MASTER_MYPORT MASTER_PORT
502 eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT, MASTER_USER='root', MASTER_CONNECT_RETRY=$connect_retry, MASTER_HEARTBEAT_PERIOD=0.1;
503 --source include/start_slave.inc
504 # Wait until slave_received_heartbeats will be incremented
505 let $status_var_value= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
506 let $status_var= slave_received_heartbeats;
507 let $status_var_comparsion= >;
508 --source include/wait_for_status_var.inc
509 --echo Heartbeat event received
510 --let $rpl_server_number= 1
511 --source include/rpl_restart_server.inc
512 # make sure IO thread has re-connected
513 # due to slow valgrind env the following wait_for_status may time out
514 --let $rpl_allow_error= 1
515 --source include/wait_for_slave_io_to_start.inc
516 # Wait until slave_received_heartbeats will be incremented
517 let $status_var_value= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
518 let $status_var= slave_received_heartbeats;
519 let $status_var_comparsion= >;
520 --source include/wait_for_status_var.inc
521 --echo Heartbeat event received
522 --echo
523
524 # Circular replication: demonstrating bidirectional hearbeat flow
525 --echo *** Circular replication ***
526 # Configure circular replication
527 --source include/rpl_reset.inc
528 --source include/stop_slave.inc
529 --let $rpl_topology= 1->2->1
530 --source include/rpl_change_topology.inc
531
532 #--connection slave
533 #--source include/stop_slave.inc
534 #let $slave_binlog= query_get_value(SHOW MASTER STATUS, File, 1);
535 --connection master
536 #--replace_result $SLAVE_MYPORT SLAVE_PORT $slave_binlog SLAVE_BINLOG
537 #eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=$SLAVE_MYPORT, MASTER_USER='root', MASTER_CONNECT_RETRY=$connect_retry, MASTER_HEARTBEAT_PERIOD=1, MASTER_LOG_FILE='$slave_binlog';
538
539 # BUG#12403008 RPL_HEARTBEAT_BASIC FAILS SPORADICALLY ON PUSHBUILD
540 # MASTER_HEARTBEAT_PERIOD had the default value (slave_net_timeout/2)
541 # so wait on "Heartbeat event received on master", that only waits for
542 # 1 minute, sometimes timeout before heartbeat arrives.
543 CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD=1;
544 --source include/start_slave.inc
545
546 # Insert data on master and on slave and make sure that it replicated for both directions
547 CREATE TABLE t1 (a INT PRIMARY KEY, b VARCHAR(10));
548 INSERT INTO t1 VALUES(1, 'on master');
549 --save_master_pos
550 --connection slave
551 ## set slave period 1/10 of master's
552 CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD=0.1;
553 --source include/start_slave.inc
554 --sync_with_master
555 INSERT INTO t1 VALUES(2, 'on slave');
556 --sync_slave_with_master master
557 SELECT * FROM t1 ORDER BY a;
558 let $master_rcvd_heartbeats_before= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
559 --connection slave
560 SELECT * FROM t1 ORDER BY a;
561
562 # Wait for heartbeat event on master
563 --connection master
564 let $status_var= slave_received_heartbeats;
565 let $status_var_value= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
566 let $status_var_comparsion= >;
567 --source include/wait_for_status_var.inc
568 --echo Heartbeat event received on master
569
570 # Wait heartbeat events on slave
571 --connection slave
572 let $status_var= slave_received_heartbeats;
573 let $status_var_value= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
574 let $status_var_comparsion= >;
575 --source include/wait_for_status_var.inc
576 --echo Heartbeat event received on slave
577 let $slave_rcvd_heartbeats= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
578
579 #
580 # Clean up and restore system variables
581 #
582 --echo *** Clean up ***
583 --connection master
584 #--source include/stop_slave.inc
585 DROP TABLE t1;
586 --sync_slave_with_master
587 SET @@global.slave_net_timeout=@restore_slave_net_timeout;
588
589 --disable_prepare_warnings
590
591 #--let $rpl_only_running_threads= 1
592 --source include/rpl_end.inc