--let $rpl_topology= 1->2->3 --source include/rpl_init.inc -- connection server_1 -- source include/have_innodb.inc -- connection server_2 -- source include/have_innodb.inc -- connection server_3 -- source include/have_innodb.inc -- connection server_1 create table t1(id int not null auto_increment primary key, f1 int, f2 int, key(f1)) engine=innodb; --sleep 1 --connection server_2 set sql_log_bin=0; alter table t1 drop index f1; alter table t1 engine=blackhole; set sql_log_bin=1; --connection server_1 insert into t1 (f1, f2) values (1,1), (2,2), (3,3); update t1 set f2=22 where id=2; delete from t1 where f1=3; select * from t1; show binlog events; --sleep 2 --connection server_2 select * from t1; show binlog events; --sleep 2 --connection server_3 select * from t1; --connection server_1 drop table t1; --source include/rpl_end.inc