mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 10:56:12 +01:00
47 lines
1.3 KiB
Text
47 lines
1.3 KiB
Text
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
|