1include/master-slave.inc 2[connection master] 3set @old_log_bin_compress=@@log_bin_compress; 4set @old_log_bin_compress_min_len=@@log_bin_compress_min_len; 5set @old_binlog_format=@@binlog_format; 6set @old_binlog_row_image=@@binlog_row_image; 7set global log_bin_compress=on; 8set global log_bin_compress_min_len=10; 9drop table if exists t1; 10Warnings: 11Note 1051 Unknown table 'test.t1' 12CREATE TABLE t1 (pr_id int(10) unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY, pr_page int(11) NOT NULL, pr_type varbinary(60) NOT NULL, test int, UNIQUE KEY pr_pagetype (pr_page,pr_type)) ENGINE=myisam AUTO_INCREMENT=136; 13set binlog_format=statement; 14insert into t1 (pr_page, pr_type, test) values(1,"one",0),(2,"two",0); 15replace into t1 (pr_page, pr_type,test) values(1,"one",2); 16update t1 set test=test+1 where pr_page > 1; 17delete from t1 where test=1; 18select * from t1; 19pr_id pr_page pr_type test 20138 1 one 2 21connection slave; 22connection slave; 23select * from t1; 24pr_id pr_page pr_type test 25138 1 one 2 26connection master; 27set binlog_format=row; 28insert into t1 (pr_page, pr_type, test) values(3,"three",0),(4,"four",4),(5, "five", 0); 29replace into t1 (pr_page, pr_type,test) values(3,"one",2); 30update t1 set test=test+1 where pr_page > 3; 31delete from t1 where test=1; 32select * from t1; 33pr_id pr_page pr_type test 34138 1 one 2 35140 4 four 5 36139 3 three 0 37142 3 one 2 38connection slave; 39connection slave; 40select * from t1; 41pr_id pr_page pr_type test 42138 1 one 2 43140 4 four 5 44139 3 three 0 45142 3 one 2 46connection master; 47set binlog_row_image=minimal; 48insert into t1 (pr_page, pr_type, test) values(6,"six",0),(7,"seven",7),(8, "eight", 0); 49replace into t1 (pr_page, pr_type,test) values(6,"six",2); 50update t1 set test=test+1 where pr_page > 6; 51delete from t1 where test=1; 52select * from t1; 53pr_id pr_page pr_type test 54138 1 one 2 55140 4 four 5 56139 3 three 0 57144 7 seven 8 58142 3 one 2 59146 6 six 2 60connection slave; 61connection slave; 62select * from t1; 63pr_id pr_page pr_type test 64138 1 one 2 65140 4 four 5 66139 3 three 0 67144 7 seven 8 68142 3 one 2 69146 6 six 2 70connection master; 71drop table t1; 72set global log_bin_compress=@old_log_bin_compress; 73set global log_bin_compress_min_len=@old_log_bin_compress_min_len; 74set binlog_format=@old_binlog_format; 75set binlog_row_image=@old_binlog_row_image; 76include/rpl_end.inc 77