summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/rpl/r/rpl_heartbeat_2slaves.result
blob: 92829cccb17b4ac6ef74d24d15246f4db420a1de (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
include/rpl_init.inc [topology=1->2,1->3]
include/rpl_connect.inc [creating master]
include/rpl_connect.inc [creating slave_1]
include/rpl_connect.inc [creating slave_2]
connection slave_1;
include/stop_slave.inc
CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD = 0.1;
include/start_slave.inc
connection slave_2;
include/stop_slave.inc
CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD = 1;
include/start_slave.inc
connection slave_1;
Slave has received heartbeat event
connection slave_2;
include/assert.inc [slave_1 should have received more heartbeats than slave_2]

include/rpl_stop_slaves.inc
include/rpl_change_topology.inc [new topology=1->3->2]
include/rpl_start_slaves.inc
connection slave_1;
include/stop_slave.inc
CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD=0.1;
include/start_slave.inc
slave_1 has received heartbeat event
connection master;
CREATE TABLE t1 (a INT PRIMARY KEY, b VARCHAR(10), c LONGTEXT);
INSERT INTO t1 VALUES (1, 'on master', '');
SHOW TABLES;
Tables_in_test
t1
connection slave_2;
SHOW TABLES;
Tables_in_test
t1
connection slave_1;
SHOW TABLES;
Tables_in_test
connection master;
creating updates on master and send to slave_2 during 5 second
connection slave_1;
include/assert.inc [slave_1 should have received heartbeats]

*** Clean up ***
connection master;
DROP TABLE t1;
include/rpl_end.inc