source include/master-slave.inc; source include/have_innodb.inc; connection master; drop table if exists t1; CREATE TABLE t1(i INT not null auto_increment primary key, c CHAR(10)) ENGINE = innodb; CREATE TABLE t2(i INT not null auto_increment primary key, c CHAR(10)) ENGINE = innodb; sleep 5; connection slave; alter table t1 engine=blackhole; connection master; insert into t1 values(2, 'foo'), (null, 'bar'); insert into t1 values(null, 'baz'); insert into t2 values(2, 'foo'), (null, 'bar'); insert into t2 values(null, 'baz'); sleep 5; connection slave; show binlog events;