Debian Codegraph @

mysql-test/suite/rpl/include/rpl_blackhole.test

raw
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 }