Debian Codegraph @

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

raw
1 # ==== Purpose ====
2 #
3 # Testing basic functionality of heartbeat.
4 #
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/big_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 choosen 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
21 call mtr.add_suppression("Replica I/O: The replica I/O thread stops because a fatal error is encountered when it tried to SET @master_binlog_checksum");
22 call mtr.add_suppression("The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state");
23
24 --echo
25
26 # Set number of retries to connect to master
27 let $connect_retry= 20;
28
29 --echo *** Preparing ***
30 --source include/sync_slave_sql_with_master.inc
31
32 --source include/stop_slave.inc
33 RESET SLAVE;
34 RESET MASTER;
35
36 SET @restore_replica_net_timeout=@@global.replica_net_timeout;
37 let $slave_heartbeat_timeout= query_get_value(select heartbeat_interval from performance_schema.replication_connection_configuration, heartbeat_interval, 1);
38 --disable_query_log
39 eval SET @restore_slave_heartbeat_timeout=$slave_heartbeat_timeout;
40 --enable_query_log
41
42 --connection master
43 RESET MASTER;
44 SET @restore_replica_net_timeout=@@global.replica_net_timeout;
45 SET @restore_event_scheduler=@@global.event_scheduler;
46 --echo
47
48 #
49 # Test slave_heartbeat_period
50 #
51
52 --connection slave
53
54 # Default value of slave_heartbeat_timeout = replica_net_timeout/2
55 --echo *** Default value ***
56 --replace_result $MASTER_MYPORT MASTER_PORT
57 --replace_column 2 ####
58 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root';
59 let $replica_net_timeout= query_get_value(SHOW VARIABLES LIKE 'replica_net_timeout', Value, 1);
60 let $slave_heartbeat_timeout= query_get_value(select heartbeat_interval from performance_schema.replication_connection_configuration, heartbeat_interval, 1);
61 let $result= query_get_value(SELECT $replica_net_timeout/$slave_heartbeat_timeout AS Result, Result, 1);
62 --echo replica_net_timeout/slave_heartbeat_timeout=$result
63
64 RESET SLAVE;
65 RESET MASTER;
66 --echo
67
68 # Reset slave set slave_heartbeat_timeout = replica_net_timeout/2
69 --echo *** Reset slave affect ***
70 --disable_warnings
71 SET @@global.replica_net_timeout=30;
72 --enable_warnings
73 --replace_result $MASTER_MYPORT MASTER_PORT
74 --replace_column 2 ####
75 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=$connect_retry, SOURCE_HEARTBEAT_PERIOD=5;
76 RESET SLAVE;
77 RESET MASTER;
78
79 select heartbeat_interval from performance_schema.replication_connection_configuration;
80 --echo
81
82 # Check default value of slave_heartbeat_timeout if replica_net_timeout is changed
83 --echo *** Default value if replica_net_timeout changed ***
84 --disable_warnings
85 SET @@global.replica_net_timeout=50;
86 --enable_warnings
87 --replace_result $MASTER_MYPORT MASTER_PORT
88 --replace_column 2 ####
89 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=$connect_retry;
90 select heartbeat_interval from performance_schema.replication_connection_configuration;
91 SET @@global.replica_net_timeout=@restore_replica_net_timeout;
92
93 RESET SLAVE;
94 RESET MASTER;
95
96 --echo
97
98 # Set replica_net_timeout less than current value of heartbeat_interval
99 --echo *** Warning if updated replica_net_timeout < slave_heartbeat_timeout ***
100 let $slave_heartbeat_timeout= query_get_value(select heartbeat_interval from performance_schema.replication_connection_configuration, heartbeat_interval, 1);
101 --replace_result $slave_heartbeat_timeout SLAVE_HEARTBEAT_TIMEOUT
102 eval SET @@global.replica_net_timeout=FLOOR($slave_heartbeat_timeout)-1;
103 SET @@global.replica_net_timeout=@restore_replica_net_timeout;
104 RESET SLAVE;
105 RESET MASTER;
106 --echo
107
108 # Set value of slave_heartbeat_period greater than replica_net_timeout
109 --echo *** Warning if updated slave_heartbeat_timeout > replica_net_timeout ***
110 let $replica_net_timeout= query_get_value(SHOW VARIABLES LIKE 'replica_net_timeout', Value, 1);
111 inc $replica_net_timeout;
112 --replace_result $MASTER_MYPORT MASTER_PORT $replica_net_timeout REPLICA_NET_TIMEOUT
113 --replace_column 2 ####
114 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=$connect_retry, SOURCE_HEARTBEAT_PERIOD=$replica_net_timeout;
115 RESET SLAVE;
116 RESET MASTER;
117
118 --echo
119
120 # Changing of replica_net_timeout shouldn't affect to current value of slave_heartbeat_period
121 --echo *** CHANGE MASTER statement only updates slave_heartbeat_period ***
122 --disable_warnings
123 SET @@global.replica_net_timeout=20;
124 --enable_warnings
125 --replace_result $MASTER_MYPORT MASTER_PORT
126 --replace_column 2 ####
127 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=$connect_retry, SOURCE_HEARTBEAT_PERIOD=5;
128 SHOW VARIABLES LIKE 'replica_net_timeout';
129 select heartbeat_interval from performance_schema.replication_connection_configuration;
130 SET @@global.replica_net_timeout=2*@@global.replica_net_timeout;
131 SHOW VARIABLES LIKE 'replica_net_timeout';
132 select heartbeat_interval from performance_schema.replication_connection_configuration;
133 SET @@global.replica_net_timeout=@restore_replica_net_timeout;
134 RESET SLAVE;
135 RESET MASTER;
136 --echo
137
138 # Master value of replica_net_timeout shouldn't affect to slave's slave_heartbeat_period
139 --echo *** Update replica_net_timeout on master ***
140 --connection master
141 --disable_warnings
142 SET @@global.replica_net_timeout=500;
143 --enable_warnings
144 --connection slave
145 SET @@global.replica_net_timeout=200;
146 RESET SLAVE;
147 RESET MASTER;
148 --replace_result $MASTER_MYPORT MASTER_PORT
149 --replace_column 2 ####
150 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=$connect_retry;
151 --source include/start_slave.inc
152 --connection master
153 --source include/sync_slave_sql_with_master.inc
154 SHOW VARIABLES LIKE 'replica_net_timeout';
155 select heartbeat_interval from performance_schema.replication_connection_configuration;
156 SET @@global.replica_net_timeout=@restore_replica_net_timeout;
157 --source include/stop_slave.inc
158 RESET SLAVE;
159 RESET MASTER;
160 --connection master
161
162 SET @@global.replica_net_timeout=@restore_replica_net_timeout;
163 --echo
164
165 # Start/stop slave shouldn't change slave_heartbeat_period
166 --echo *** Start/stop slave ***
167 --connection slave
168 --disable_warnings
169
170 SET @@global.replica_net_timeout=100;
171 --enable_warnings
172 --replace_result $MASTER_MYPORT MASTER_PORT
173 --replace_column 2 ####
174 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=$connect_retry, SOURCE_HEARTBEAT_PERIOD=20;
175 --source include/start_slave.inc
176 --connection master
177 --source include/sync_slave_sql_with_master.inc
178 select heartbeat_interval from performance_schema.replication_connection_configuration;
179 --source include/stop_slave.inc
180 select heartbeat_interval from performance_schema.replication_connection_configuration;
181
182 --echo
183
184 # Reload slave shouldn't change slave_heartbeat_period
185 --echo *** Reload slave ***
186 --connection slave
187 --disable_warnings
188 SET @@global.replica_net_timeout=50;
189 --enable_warnings
190 --replace_result $MASTER_MYPORT MASTER_PORT
191 --replace_column 2 ####
192 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=$connect_retry, SOURCE_HEARTBEAT_PERIOD=30;
193 --let $rpl_server_number= 2
194 --source include/rpl_restart_server.inc
195 select heartbeat_interval from performance_schema.replication_connection_configuration;
196 SET @restore_replica_net_timeout=@@global.replica_net_timeout;
197 --echo
198
199 # Disable heartbeat
200 --echo *** Disable heartbeat ***
201 --replace_result $MASTER_MYPORT MASTER_PORT
202 --replace_column 2 ####
203 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=$connect_retry, SOURCE_HEARTBEAT_PERIOD=0;
204 select heartbeat_interval from performance_schema.replication_connection_configuration;
205 select count_received_heartbeats from performance_schema.replication_connection_status;
206 --source include/start_slave.inc
207 --connection master
208 --source include/sync_slave_sql_with_master.inc
209 --sleep 2
210 select heartbeat_interval from performance_schema.replication_connection_configuration;
211 select count_received_heartbeats from performance_schema.replication_connection_status;
212 --source include/stop_slave.inc
213 select heartbeat_interval from performance_schema.replication_connection_configuration;
214 select count_received_heartbeats from performance_schema.replication_connection_status;
215
216 RESET SLAVE;
217 RESET MASTER;
218 let $slave_heartbeat_timeout= query_get_value(select heartbeat_interval from performance_schema.replication_connection_configuration, heartbeat_interval, 1);
219 --replace_result $slave_heartbeat_timeout SLAVE_HEARTBEAT_TIMEOUT
220 --eval SELECT $slave_heartbeat_timeout = 0 AS Result
221 --echo
222 #
223 # Check limits for slave_heartbeat_timeout
224 #
225
226 --echo *** Min slave_heartbeat_timeout ***
227 --replace_result $MASTER_MYPORT MASTER_PORT
228 --replace_column 2 ####
229 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=$connect_retry, SOURCE_HEARTBEAT_PERIOD=0.001;
230 select heartbeat_interval from performance_schema.replication_connection_configuration;
231 RESET SLAVE;
232 RESET MASTER;
233 --replace_result $MASTER_MYPORT MASTER_PORT
234 --replace_column 2 ####
235 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=$connect_retry, SOURCE_HEARTBEAT_PERIOD=0.0009;
236 select heartbeat_interval from performance_schema.replication_connection_configuration;
237 RESET SLAVE;
238 RESET MASTER;
239 --echo
240
241 --echo *** Max slave_heartbeat_timeout ***
242 --replace_result $MASTER_MYPORT MASTER_PORT
243 --replace_column 2 ####
244 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=$connect_retry, SOURCE_HEARTBEAT_PERIOD=4294967;
245 select heartbeat_interval from performance_schema.replication_connection_configuration;
246 RESET SLAVE;
247 RESET MASTER;
248 --replace_result $MASTER_MYPORT MASTER_PORT
249 --replace_column 2 ####
250 --error ER_REPLICA_HEARTBEAT_VALUE_OUT_OF_RANGE
251 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=$connect_retry, SOURCE_HEARTBEAT_PERIOD=4294968;
252 RESET SLAVE;
253 RESET MASTER;
254 # Check double size of max allowed value for master_heartbeat_period
255 --replace_result $MASTER_MYPORT MASTER_PORT
256 --replace_column 2 ####
257 --error ER_REPLICA_HEARTBEAT_VALUE_OUT_OF_RANGE
258 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=$connect_retry, SOURCE_HEARTBEAT_PERIOD=8589935;
259 RESET SLAVE;
260 RESET MASTER;
261 # Check 2^32
262 --replace_result $MASTER_MYPORT MASTER_PORT
263 --replace_column 2 ####
264 --error ER_REPLICA_HEARTBEAT_VALUE_OUT_OF_RANGE
265 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=$connect_retry, SOURCE_HEARTBEAT_PERIOD=4294967296;
266 RESET SLAVE;
267 RESET MASTER;
268 --echo
269
270 --echo *** Misc incorrect values ***
271 --replace_result $MASTER_MYPORT MASTER_PORT
272 --replace_column 2 ####
273 --error ER_PARSE_ERROR
274 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=$connect_retry, SOURCE_HEARTBEAT_PERIOD='-1';
275 RESET SLAVE;
276 RESET MASTER;
277 --replace_result $MASTER_MYPORT MASTER_PORT
278 --replace_column 2 ####
279 --error ER_PARSE_ERROR
280 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=$connect_retry, SOURCE_HEARTBEAT_PERIOD='123abc';
281 RESET SLAVE;
282 RESET MASTER;
283 --replace_result $MASTER_MYPORT MASTER_PORT
284 --replace_column 2 ####
285 --error ER_PARSE_ERROR
286 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=$connect_retry, SOURCE_HEARTBEAT_PERIOD='';
287 RESET SLAVE;
288 RESET MASTER;
289 --echo
290
291 #
292 # Testing heartbeat
293 #
294 # Check received heartbeat events for running slave.
295 # It must arrived not ealier than as specified by HEARTBEAT_PERIOD.
296 #
297 --let $hb_period= 3.0
298 --echo *** Running slave ***
299 --replace_result $MASTER_MYPORT MASTER_PORT
300 --replace_column 2 ####
301 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=$connect_retry, SOURCE_HEARTBEAT_PERIOD= $hb_period;
302 SELECT unix_timestamp() into @time_0;
303 --source include/start_slave.inc
304
305 --connection master
306 --source include/sync_slave_sql_with_master.inc
307 let $status_col_value= query_get_value(select count_received_heartbeats from performance_schema.replication_connection_status, count_received_heartbeats, 1);
308 let $status_col= count_received_heartbeats;
309 let $table=replication_connection_status;
310 let $status_col_comparsion= >;
311 --source include/wait_for_rpl_pfs_status.inc
312 SELECT unix_timestamp() into @time_1;
313 if (`SELECT @time_1 - @time_0 < $hb_period`)
314 {
315 --echo "Heartbeat is received ealier than specified."
316 --die
317 }
318 --echo Heartbeat event received
319 --echo
320
321 # Check received heartbeat events for stopped slave
322 --echo *** Stopped slave ***
323 --source include/stop_slave.inc
324 --replace_result $MASTER_MYPORT MASTER_PORT
325 --replace_column 2 ####
326 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=$connect_retry, SOURCE_HEARTBEAT_PERIOD= 0.1;
327
328 let $rcvd_heartbeats_before= query_get_value(select count_received_heartbeats from performance_schema.replication_connection_status, count_received_heartbeats, 1);
329 sleep 2;
330 let $rcvd_heartbeats_after= query_get_value(select count_received_heartbeats from performance_schema.replication_connection_status, count_received_heartbeats, 1);
331 let $result= query_get_value(SELECT ($rcvd_heartbeats_after - $rcvd_heartbeats_before) AS Result, Result, 1);
332 --echo Number of received heartbeat events while slave stopped: $result
333 --echo
334
335 # Check received heartbeat events for started slave
336 --echo *** Started slave ***
337 --source include/start_slave.inc
338 let $status_col_value= query_get_value(select count_received_heartbeats from performance_schema.replication_connection_status, count_received_heartbeats, 1);
339 --source include/wait_for_rpl_pfs_status.inc
340 --echo Heartbeat event received
341 --echo
342
343 # Check received heartbeat events for stopped IO thread
344 --echo *** Stopped IO thread ***
345 --source include/stop_slave_io.inc
346 let $rcvd_heartbeats_before= query_get_value(select count_received_heartbeats from performance_schema.replication_connection_status, count_received_heartbeats, 1);
347 sleep 2;
348 let $rcvd_heartbeats_after= query_get_value(select count_received_heartbeats from performance_schema.replication_connection_status, count_received_heartbeats, 1);
349 let $result= query_get_value(SELECT ($rcvd_heartbeats_after - $rcvd_heartbeats_before) AS Result, Result, 1);
350 --echo Number of received heartbeat events while io thread stopped: $result
351 --echo
352
353 # Check received heartbeat events for started IO thread
354 --echo *** Started IO thread ***
355 START SLAVE IO_THREAD;
356 --source include/wait_for_slave_io_to_start.inc
357 let $status_var_value= query_get_value(select count_received_heartbeats from performance_schema.replication_connection_status, count_received_heartbeats, 1);
358 --source include/wait_for_rpl_pfs_status.inc
359 --echo Heartbeat event received
360 --echo
361
362 # Check received heartbeat events for stopped SQL thread
363 --echo *** Stopped SQL thread ***
364 --source include/stop_slave_sql.inc
365 let $rcvd_heartbeats_before= query_get_value(select count_received_heartbeats from performance_schema.replication_connection_status, count_received_heartbeats, 1);
366 sleep 2;
367 let $rcvd_heartbeats_after= query_get_value(select count_received_heartbeats from performance_schema.replication_connection_status, count_received_heartbeats, 1);
368 let $result= query_get_value(SELECT ($rcvd_heartbeats_after - $rcvd_heartbeats_before) > 0 AS Result, Result, 1);
369 --echo Heartbeat events are received while sql thread stopped (1 means 'yes'): $result
370 --echo
371
372 # Check received heartbeat events for started SQL thread
373 --echo *** Started SQL thread ***
374 START SLAVE SQL_THREAD;
375 --source include/wait_for_slave_sql_to_start.inc
376 let $status_var_value= query_get_value(select count_received_heartbeats from performance_schema.replication_connection_status, count_received_heartbeats, 1);
377 --source include/wait_for_rpl_pfs_status.inc
378 --echo Heartbeat event received
379 --echo
380
381 # Check received heartbeat event for stopped SQL thread by error
382 --echo *** Stopped SQL thread by error ***
383 --connection master
384 CREATE TABLE t1 (a INT PRIMARY KEY, b VARCHAR(10), c LONGTEXT);
385 --source include/sync_slave_sql_with_master.inc
386 INSERT INTO t1 VALUES (1, 'on slave', NULL);
387 --connection master
388 INSERT INTO t1 VALUES (1, 'on master', NULL);
389 --connection slave
390 call mtr.add_suppression("Replica SQL.*Duplicate entry .1. for key .t1.PRIMARY.. on query.* Error_code: MY-001062");
391 call mtr.add_suppression("Replica SQL.*Request to stop replica SQL Thread received while applying a group that has non-transactional changes; waiting for completion of the group");
392 let $slave_errno= ER_DUP_ENTRY
393 --source include/wait_for_slave_sql_error.inc
394 let $rcvd_heartbeats_before= query_get_value(select count_received_heartbeats from performance_schema.replication_connection_status, count_received_heartbeats, 1);
395 sleep 2;
396 let $rcvd_heartbeats_after= query_get_value(select count_received_heartbeats from performance_schema.replication_connection_status, count_received_heartbeats, 1);
397 let $result= query_get_value(SELECT ($rcvd_heartbeats_after - $rcvd_heartbeats_before) > 0 AS Result, Result, 1);
398 --echo Heartbeat events are received while sql thread stopped (1 means 'yes'): $result
399 --source include/stop_slave_io.inc
400 DELETE FROM t1;
401 --source include/start_slave.inc
402 --connection master
403 --source include/sync_slave_sql_with_master.inc
404 --connection master
405 DROP TABLE t1;
406 --echo
407
408 # Check received heartbeat events while logs flushed on slave
409 --source include/sync_slave_sql_with_master.inc
410 --echo *** Flush logs on slave ***
411 --let $rpl_no_start_slave= 1
412 --source include/rpl_reset.inc
413 --let $rpl_no_start_slave= 0
414 --replace_result $MASTER_MYPORT MASTER_PORT
415 --replace_column 2 ####
416 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=$connect_retry, SOURCE_HEARTBEAT_PERIOD=0.5;
417 let $slave_param_comparison= =;
418 --source include/start_slave.inc
419 let $rcvd_heartbeats_before= query_get_value(select count_received_heartbeats from performance_schema.replication_connection_status, count_received_heartbeats, 1);
420 # Flush logs every 0.1 second during 10 sec
421 --disable_query_log
422 let $i=100;
423 while ($i) {
424 FLUSH LOGS;
425 dec $i;
426 sleep 0.1;
427 }
428 --enable_query_log
429 --let $assert_cond= [select count_received_heartbeats from performance_schema.replication_connection_status, count_received_heartbeats, 1] > $rcvd_heartbeats_before
430 --let $assert_text= Should receive at least one heartbeat event while running FLUSH LOGS for 10 seconds
431 --source include/assert.inc
432 --echo
433
434 # Use compressed protocol between master and slave
435 --echo *** Compressed protocol ***
436 --connection master
437 SET @@global.replica_compressed_protocol=1;
438 --connection slave
439 --source include/stop_slave.inc
440 RESET SLAVE;
441 RESET MASTER;
442 SET @@global.replica_compressed_protocol=1;
443 --replace_result $MASTER_MYPORT MASTER_PORT
444 --replace_column 2 ####
445 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=$connect_retry, SOURCE_HEARTBEAT_PERIOD=0.1;
446 --source include/start_slave.inc
447 let $status_col_value= query_get_value(select count_received_heartbeats from performance_schema.replication_connection_status, count_received_heartbeats, 1);
448 let $status_col= count_received_heartbeats;
449 let $table= replication_connection_status;
450 let $status_col_comparsion= >;
451 --source include/wait_for_rpl_pfs_status.inc
452 --echo Heartbeat event received
453 SET @@global.replica_compressed_protocol=0;
454 --connection master
455 SET @@global.replica_compressed_protocol=0;
456 --echo
457
458 # Check received heartbeat events after reset of master
459 --echo *** Reset master ***
460 --connection slave
461
462 STOP SLAVE;
463 RESET SLAVE;
464 RESET MASTER;
465 --replace_result $MASTER_MYPORT MASTER_PORT
466 --replace_column 2 ####
467 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=$connect_retry, SOURCE_HEARTBEAT_PERIOD=0.1;
468 --source include/start_slave.inc
469 let $rcvd_heartbeats_before= query_get_value(select count_received_heartbeats from performance_schema.replication_connection_status, count_received_heartbeats, 1);
470 --connection master
471 RESET MASTER;
472 --enable_query_log
473 --source include/sync_slave_sql_with_master.inc
474 --sleep 2
475 let $rcvd_heartbeats_after= query_get_value(select count_received_heartbeats from performance_schema.replication_connection_status, count_received_heartbeats, 1);
476 let $result= query_get_value(SELECT ($rcvd_heartbeats_after - $rcvd_heartbeats_before) > 0 AS Result, Result, 1);
477 --echo Heartbeat events are received after reset of master (1 means 'yes'): $result
478 --echo
479
480 # Reloaded master should restore heartbeat
481 --echo *** Reload master ***
482 --connection slave
483 STOP SLAVE;
484 RESET SLAVE;
485 RESET MASTER;
486 --replace_result $MASTER_MYPORT MASTER_PORT
487 --replace_column 2 ####
488 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=$connect_retry, SOURCE_HEARTBEAT_PERIOD=0.1;
489 --source include/start_slave.inc
490 # Wait until slave_received_heartbeats will be incremented
491 let $status_col_value= query_get_value(select count_received_heartbeats from performance_schema.replication_connection_status, count_received_heartbeats, 1);
492 let $status_col= count_received_heartbeats;
493 let $table=replication_connection_status;
494 let $status_col_comparsion= >;
495 --source include/wait_for_rpl_pfs_status.inc
496 --echo Heartbeat event received
497 --let $rpl_server_number= 1
498 --source include/rpl_restart_server.inc
499 # make sure IO thread has re-connected
500 # due to slow valgrind env the following wait_for_status may time out
501 --let $rpl_allow_error= 1
502 --source include/wait_for_slave_io_to_start.inc
503 # Wait until slave_received_heartbeats will be incremented
504 let $status_col_value= query_get_value(select count_received_heartbeats from performance_schema.replication_connection_status, count_received_heartbeats, 1);
505 let $status_col= count_received_heartbeats;
506 let $table= replication_connection_status;
507 let $status_col_comparsion= >;
508 --source include/wait_for_rpl_pfs_status.inc
509 --echo Heartbeat event received
510 --echo
511
512 # Circular replication: demonstrating bidirectional hearbeat flow
513 --echo *** Circular replication ***
514 # Configure circular replication
515 --source include/rpl_reset.inc
516 --source include/stop_slave.inc
517 --let $rpl_topology= 1->2->1
518 --source include/rpl_change_topology.inc
519
520 #--connection slave
521 #--source include/stop_slave.inc
522 #let $slave_binlog= query_get_value(SHOW MASTER STATUS, File, 1);
523 --connection master
524 #--replace_result $SLAVE_MYPORT SLAVE_PORT $slave_binlog SLAVE_BINLOG
525 #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';
526
527 # BUG#12403008 RPL_HEARTBEAT_BASIC FAILS SPORADICALLY ON PUSHBUILD
528 # MASTER_HEARTBEAT_PERIOD had the default value (replica_net_timeout/2)
529 # so wait on "Heartbeat event received on master", that only waits for
530 # 1 minute, sometimes timeout before heartbeat arrives.
531 --replace_column 2 ####
532 CHANGE REPLICATION SOURCE TO SOURCE_HEARTBEAT_PERIOD=1;
533 --source include/start_slave.inc
534
535 # Insert data on master and on slave and make sure that it replicated for both directions
536 CREATE TABLE t1 (a INT PRIMARY KEY, b VARCHAR(10));
537 INSERT INTO t1 VALUES(1, 'on master');
538 --save_master_pos
539 --connection slave
540 ## set slave period 1/10 of master's
541 --replace_column 2 ####
542 CHANGE REPLICATION SOURCE TO SOURCE_HEARTBEAT_PERIOD=0.1;
543 --source include/start_slave.inc
544 --sync_with_master
545 INSERT INTO t1 VALUES(2, 'on slave');
546 --let $sync_slave_connection= master
547 --source include/sync_slave_sql_with_master.inc
548 SELECT * FROM t1 ORDER BY a;
549 let $master_rcvd_heartbeats_before= query_get_value(select count_received_heartbeats from performance_schema.replication_connection_status, count_received_heartbeats, 1);
550 --connection slave
551 SELECT * FROM t1 ORDER BY a;
552
553 # Wait for heartbeat event on master
554 --connection master
555
556 let $status_col= count_received_heartbeats;
557 let $table=replication_connection_status;
558 let $status_col_value= query_get_value(select count_received_heartbeats from performance_schema.replication_connection_status, count_received_heartbeats, 1);
559 let $status_col_comparsion= >;
560 --source include/wait_for_rpl_pfs_status.inc
561 --echo Heartbeat event received on master
562
563 # Wait heartbeat events on slave
564 --connection slave
565 let $status_col= count_received_heartbeats;
566 let $table= replication_connection_status;
567 let $status_col_value= query_get_value(select count_received_heartbeats from performance_schema.replication_connection_status, count_received_heartbeats, 1);
568 let $status_col_comparsion= >;
569 --source include/wait_for_rpl_pfs_status.inc
570 --echo Heartbeat event received on slave
571 let $slave_rcvd_heartbeats= query_get_value(select count_received_heartbeats from performance_schema.replication_connection_status, count_received_heartbeats, 1);
572
573 #
574 # Clean up and restore system variables
575 #
576 --echo *** Clean up ***
577 --connection master
578 #--source include/stop_slave.inc
579 DROP TABLE t1;
580 --connection slave
581 SET @@global.replica_net_timeout=@restore_replica_net_timeout;
582
583 #--let $rpl_only_running_threads= 1
584 --source include/rpl_end.inc