1
# Check replication of one statement assuming that the engine on the
2
# slave is a blackhole engine.
5
# $statement Statement to evaluate, it is assumed to change t1
7
# 1. Evaluate statement on master, it is assumed to change t1
8
# 2. Wait for statement to be processed on slave
9
# 3. SELECT from table t1 to see what was written
10
# 4. Compare position on slave before executing statement and after
11
# executing statement. If difference is >0, then something was
12
# written to the binary log on the slave.
15
let $before = query_get_value("SHOW MASTER STATUS", Position, 1);
22
sync_slave_with_master;
24
SELECT COUNT(*) FROM t1;
25
let $after = query_get_value("SHOW MASTER STATUS", Position, 1);
26
let $something_written = `select $after - $before != 0`;
27
if ($something_written) {
28
--echo >>> Something was written to binary log <<<
30
if (!$something_written) {
31
--echo >>> Nothing was written to binary log <<<