Quelle  rpl_heartbeat_2slaves.result   Sprache: Lisp

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