--source include/master-slave.inc --source include/have_innodb.inc --source include/have_blackhole.inc CREATE TABLE BLACK(ID BIGINT, TEXTCOL TEXT, BLOBCOL BLOB) ENGINE=Innodb; SET binlog_format=row; --sync_slave_with_master alter table BLACK engine=blackhole; --connection master INSERT INTO BLACK VALUES(1,'TESTSTRING', 'TESTBLOB'); INSERT INTO BLACK VALUES(2,'TESTSTRING_2', 'TESTBLOB_2'); flush binary logs; --sleep 5 --connection slave flush binary logs; --connection master UPDATE BLACK SET TEXTCOL='teststring_update' where ID=1; UPDATE BLACK SET BLOBCOL='testblob_update' where ID=2; SELECT * FROM BLACK; --exec $MYSQL_BINLOG -vv --base64-output=decode-rows $server_1_datadir/master-bin.000002 --exec $MYSQL_BINLOG -vv --base64-output=decode-rows $server_2_datadir/slave-bin.000002