Debian Codegraph @

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

raw
1 #
2 # Test very simply slave replication (to ensure it works at all)
3 # In addition, test also:
4 # MDEV-5829 STOP SLAVE resets global status variables
5 #
6
7 source include/master-slave.inc;
8 --connection slave
9 let $initial_com_insert= query_get_value(show global status like "Com_insert", Value, 1);
10 --connection master
11 create table t1 (n int);
12 insert into t1 values(1);
13 sync_slave_with_master;
14 let $current_com_insert= query_get_value(show global status like "Com_insert", Value, 1);
15 --let $delta_com_insert= `select $current_com_insert - $initial_com_insert from dual`
16 --echo # Com_insert = $delta_com_insert
17 stop slave;
18 let $current_com_insert= query_get_value(show global status like "Com_insert", Value, 1);
19 --let $delta_com_insert= `select $current_com_insert - $initial_com_insert from dual`
20 --echo # Com_insert = $delta_com_insert
21 --source include/wait_for_slave_to_stop.inc
22 start slave;
23 --source include/wait_for_slave_to_start.inc
24 connection master;
25 insert into t1 values(2);
26 #let slave catch up
27 sync_slave_with_master;
28 select * from t1;
29 connection master;
30 drop table t1;
31 sync_slave_with_master;
32
33 # End of 4.1 tests
34 --source include/rpl_end.inc