mirror of
https://github.com/MariaDB/server.git
synced 2025-02-09 23:24:11 +01:00
124 lines
4 KiB
Text
124 lines
4 KiB
Text
#############################################################
|
|
# Author: Serge Kozlov <Serge.Kozlov@Sun.COM>
|
|
# Date: 02/19/2009
|
|
# Purpose: Testing heartbeat for schema
|
|
# 1 master and 2 slaves
|
|
#############################################################
|
|
--let $rpl_topology= 1->2,1->3
|
|
--source include/rpl_init.inc
|
|
|
|
--let $rpl_connection_name= master
|
|
--let $rpl_server_number= 1
|
|
--source include/rpl_connect.inc
|
|
|
|
--let $rpl_connection_name= slave_1
|
|
--let $rpl_server_number= 2
|
|
--source include/rpl_connect.inc
|
|
|
|
--let $rpl_connection_name= slave_2
|
|
--let $rpl_server_number= 3
|
|
--source include/rpl_connect.inc
|
|
|
|
#
|
|
# Set different heartbeat periods for slaves
|
|
#
|
|
--connection slave_1
|
|
--source include/stop_slave.inc
|
|
CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD = 0.1;
|
|
--source include/start_slave.inc
|
|
--connection slave_2
|
|
--source include/stop_slave.inc
|
|
CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD = 1;
|
|
--source include/start_slave.inc
|
|
|
|
#
|
|
# Testing heartbeat for one master and two slaves
|
|
#
|
|
|
|
# Check that heartbeat events sent to both slaves with correct periods
|
|
--connection slave_1
|
|
let $status_var= slave_received_heartbeats;
|
|
let $status_var_value= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
|
|
let $status_var_comparsion= >;
|
|
--source include/wait_for_status_var.inc
|
|
--echo Slave has received heartbeat event
|
|
--connection slave_2
|
|
let $status_var= slave_received_heartbeats;
|
|
let $status_var_value= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
|
|
let $status_var_comparsion= >;
|
|
--source include/wait_for_status_var.inc
|
|
--let $assert_cond= [slave_1:SHOW STATUS LIKE "slave_received_heartbeats", Value, 1] > [slave_2:SHOW STATUS LIKE "slave_received_heartbeats", Value, 1]
|
|
--let $assert_text= slave_1 should have received more heartbeats than slave_2
|
|
--source include/assert.inc
|
|
--echo
|
|
|
|
# Create topology master->slave_2->slave_1 and check that slave_1
|
|
# receives heartbeat while slave_2 gets data.
|
|
|
|
# slave_2 was started w/o --log-slave-updates because slave_2 should
|
|
# not send data from master to slave_1
|
|
|
|
--source include/rpl_stop_slaves.inc
|
|
--let $rpl_topology= 1->3->2
|
|
--source include/rpl_change_topology.inc
|
|
--source include/rpl_start_slaves.inc
|
|
--connection slave_1
|
|
--source include/stop_slave.inc
|
|
CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD=0.1;
|
|
--source include/start_slave.inc
|
|
|
|
# Check heartbeat for new replication channel slave_2->slave
|
|
let $status_var= slave_received_heartbeats;
|
|
let $status_var_value= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
|
|
let $status_var_comparsion= >;
|
|
--source include/wait_for_status_var.inc
|
|
--echo 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;
|
|
--sync_slave_with_master slave_2
|
|
SHOW TABLES;
|
|
let $slave_2_pos_before= query_get_value(SHOW SLAVE STATUS, Read_Master_Log_Pos, 1);
|
|
--sync_slave_with_master slave_1
|
|
SHOW TABLES;
|
|
--connection master
|
|
--echo creating updates on master and send to slave_2 during 5 second
|
|
# Generate events on master and send to slave_2 during 5 second
|
|
let $i= 1;
|
|
let $j= 1;
|
|
let $k= 1;
|
|
--disable_query_log
|
|
while ($i) {
|
|
eval SET @c_text=REPEAT('1234567890', $j);
|
|
eval UPDATE t1 SET a=$j, c=@c_text;
|
|
--connection slave_2
|
|
let $slave_2_pos= query_get_value(SHOW SLAVE STATUS, Read_Master_Log_Pos, 1);
|
|
if (`SELECT ($k*($slave_2_pos - $slave_2_pos_before)) > 0`) {
|
|
--connection slave_1
|
|
let $slave_1_rcvd_heartbeats_before= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
|
|
let $k= 0;
|
|
let $time_before = `SELECT NOW()`;
|
|
}
|
|
if (`SELECT ((1-$k)*TIMESTAMPDIFF(SECOND,'$time_before',NOW())) > 5`) {
|
|
let $i= 0;
|
|
}
|
|
--connection master
|
|
inc $j;
|
|
sleep 0.1;
|
|
}
|
|
--enable_query_log
|
|
--connection slave_1
|
|
--let $assert_cond= [SHOW STATUS LIKE "slave_received_heartbeats", Value, 1] > $slave_1_rcvd_heartbeats_before
|
|
--let $assert_text= slave_1 should have received heartbeats
|
|
--source include/assert.inc
|
|
--echo
|
|
|
|
#
|
|
# Clean up
|
|
#
|
|
--echo *** Clean up ***
|
|
--connection master
|
|
DROP TABLE t1;
|
|
|
|
--source include/rpl_end.inc
|