| 1 |
# Check replication of one statement assuming that the engine on the |
| 2 |
# slave is a blackhole engine. |
| 3 |
|
| 4 |
# Input: |
| 5 |
# $statement Statement to evaluate, it is assumed to change t1 |
| 6 |
|
| 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. |
| 13 |
|
| 14 |
# On Connection Slave |
| 15 |
let $before = query_get_value("SHOW MASTER STATUS", Position, 1); |
| 16 |
|
| 17 |
connection master; |
| 18 |
eval $statement; |
| 19 |
|
| 20 |
sync_slave_with_master; |
| 21 |
--echo # Expect 0 |
| 22 |
SELECT COUNT(*) FROM t1; |
| 23 |
let $after = query_get_value("SHOW MASTER STATUS", Position, 1); |
| 24 |
let $something_written = `select $after - $before != 0`; |
| 25 |
if ($something_written) { |
| 26 |
--echo >>> Something was written to binary log <<< |
| 27 |
} |
| 28 |
if (!$something_written) { |
| 29 |
--echo >>> Nothing was written to binary log <<< |
| 30 |
} |