Debian Codegraph @

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

raw
1 #############################################################
2 # Author: Serge Kozlov <[email protected]>
3 # Date: 02/19/2009
4 # Purpose: Testing heartbeat for schema
5 # 1 master and 2 slaves
6 #############################################################
7 --let $rpl_topology= 1->2,1->3
8 --source include/rpl_init.inc
9
10 --let $rpl_connection_name= master
11 --let $rpl_server_number= 1
12 --source include/rpl_connect.inc
13
14 --let $rpl_connection_name= slave_1
15 --let $rpl_server_number= 2
16 --source include/rpl_connect.inc
17
18 --let $rpl_connection_name= slave_2
19 --let $rpl_server_number= 3
20 --source include/rpl_connect.inc
21
22 #
23 # Set different heartbeat periods for slaves
24 #
25 --connection slave_1
26 --source include/stop_slave.inc
27 CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD = 0.1;
28 --source include/start_slave.inc
29 --connection slave_2
30 --source include/stop_slave.inc
31 CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD = 1;
32 --source include/start_slave.inc
33
34 #
35 # Testing heartbeat for one master and two slaves
36 #
37
38 # Check that heartbeat events sent to both slaves with correct periods
39 --connection slave_1
40 let $status_var= slave_received_heartbeats;
41 let $status_var_value= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
42 let $status_var_comparsion= >;
43 --source include/wait_for_status_var.inc
44 --echo Slave has received heartbeat event
45 --connection slave_2
46 let $status_var= slave_received_heartbeats;
47 let $status_var_value= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
48 let $status_var_comparsion= >;
49 --source include/wait_for_status_var.inc
50 --let $assert_cond= [slave_1:SHOW STATUS LIKE "slave_received_heartbeats", Value, 1] > [slave_2:SHOW STATUS LIKE "slave_received_heartbeats", Value, 1]
51 --let $assert_text= slave_1 should have received more heartbeats than slave_2
52 --source include/assert.inc
53 --echo
54
55 # Create topology master->slave_2->slave_1 and check that slave_1
56 # receives heartbeat while slave_2 gets data.
57
58 # slave_2 was started w/o --log-slave-updates because slave_2 should
59 # not send data from master to slave_1
60
61 --source include/rpl_stop_slaves.inc
62 --let $rpl_topology= 1->3->2
63 --source include/rpl_change_topology.inc
64 --source include/rpl_start_slaves.inc
65 --connection slave_1
66 --source include/stop_slave.inc
67 CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD=0.1;
68 --source include/start_slave.inc
69
70 # Check heartbeat for new replication channel slave_2->slave
71 let $status_var= slave_received_heartbeats;
72 let $status_var_value= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
73 let $status_var_comparsion= >;
74 --source include/wait_for_status_var.inc
75 --echo slave_1 has received heartbeat event
76 --connection master
77 CREATE TABLE t1 (a INT PRIMARY KEY, b VARCHAR(10), c LONGTEXT);
78 INSERT INTO t1 VALUES (1, 'on master', '');
79 SHOW TABLES;
80 --sync_slave_with_master slave_2
81 SHOW TABLES;
82 let $slave_2_pos_before= query_get_value(SHOW SLAVE STATUS, Read_Master_Log_Pos, 1);
83 --sync_slave_with_master slave_1
84 SHOW TABLES;
85 --connection master
86 --echo creating updates on master and send to slave_2 during 5 second
87 # Generate events on master and send to slave_2 during 5 second
88 let $i= 1;
89 let $j= 1;
90 let $k= 1;
91 --disable_query_log
92 while ($i) {
93 eval SET @c_text=REPEAT('1234567890', $j);
94 eval UPDATE t1 SET a=$j, c=@c_text;
95 --connection slave_2
96 let $slave_2_pos= query_get_value(SHOW SLAVE STATUS, Read_Master_Log_Pos, 1);
97 if (`SELECT ($k*($slave_2_pos - $slave_2_pos_before)) > 0`) {
98 --connection slave_1
99 let $slave_1_rcvd_heartbeats_before= query_get_value(SHOW STATUS LIKE 'slave_received_heartbeats', Value, 1);
100 let $k= 0;
101 let $time_before = `SELECT NOW()`;
102 }
103 if (`SELECT ((1-$k)*TIMESTAMPDIFF(SECOND,'$time_before',NOW())) > 5`) {
104 let $i= 0;
105 }
106 --connection master
107 inc $j;
108 sleep 0.1;
109 }
110 --enable_query_log
111 --connection slave_1
112 --let $assert_cond= [SHOW STATUS LIKE "slave_received_heartbeats", Value, 1] > $slave_1_rcvd_heartbeats_before
113 --let $assert_text= slave_1 should have received heartbeats
114 --source include/assert.inc
115 --echo
116
117 #
118 # Clean up
119 #
120 --echo *** Clean up ***
121 --connection master
122 DROP TABLE t1;
123
124 --source include/rpl_end.inc