| 1 |
# PURPOSE. Test that blackhole works with replication in all three |
| 2 |
# modes: STATEMENT, MIXED, and ROW. |
| 3 |
# |
| 4 |
# METHOD. We start by creating a table on the master and then change |
| 5 |
# the engine to use blackhole on the slave. |
| 6 |
# |
| 7 |
# After insert/update/delete of one or more rows, the test the |
| 8 |
# proceeds to check that replication is running after replicating an |
| 9 |
# change, that the blackhole engine does not contain anything (which |
| 10 |
# is just a check that the correct engine is used), and that something |
| 11 |
# is written to the binary log. |
| 12 |
# |
| 13 |
# Whe check INSERT, UPDATE, and DELETE statement for tables with no |
| 14 |
# key (forcing a range search on the slave), primary keys (using a |
| 15 |
# primary key lookup), and index/key with multiple matches (forcing an |
| 16 |
# index search). |
| 17 |
|
| 18 |
source include/have_blackhole.inc; |
| 19 |
source include/master-slave.inc; |
| 20 |
|
| 21 |
call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT"); |
| 22 |
|
| 23 |
source include/rpl_blackhole_basic.test; |
| 24 |
|
| 25 |
--source include/rpl_end.inc |