Debian Codegraph @

mysql-test/suite/rpl/t/rpl_binlog_compress.test

raw
1 #
2 # Test of compressed binlog with replication
3 #
4
5 source include/master-slave.inc;
6
7 set @old_log_bin_compress=@@log_bin_compress;
8 set @old_log_bin_compress_min_len=@@log_bin_compress_min_len;
9 set @old_binlog_format=@@binlog_format;
10 set @old_binlog_row_image=@@binlog_row_image;
11
12 set global log_bin_compress=on;
13 set global log_bin_compress_min_len=10;
14
15 drop table if exists t1;
16 CREATE 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;
17
18 set binlog_format=statement;
19 insert into t1 (pr_page, pr_type, test) values(1,"one",0),(2,"two",0);
20 replace into t1 (pr_page, pr_type,test) values(1,"one",2);
21 update t1 set test=test+1 where pr_page > 1;
22 delete from t1 where test=1;
23
24 select * from t1;
25 sync_slave_with_master;
26 connection slave;
27 select * from t1;
28 connection master;
29
30
31 set binlog_format=row;
32 insert into t1 (pr_page, pr_type, test) values(3,"three",0),(4,"four",4),(5, "five", 0);
33 replace into t1 (pr_page, pr_type,test) values(3,"one",2);
34 update t1 set test=test+1 where pr_page > 3;
35 delete from t1 where test=1;
36
37 select * from t1;
38 sync_slave_with_master;
39 connection slave;
40 select * from t1;
41 connection master;
42
43
44 set binlog_row_image=minimal;
45 insert into t1 (pr_page, pr_type, test) values(6,"six",0),(7,"seven",7),(8, "eight", 0);
46 replace into t1 (pr_page, pr_type,test) values(6,"six",2);
47 update t1 set test=test+1 where pr_page > 6;
48 delete from t1 where test=1;
49
50 select * from t1;
51 sync_slave_with_master;
52 connection slave;
53 select * from t1;
54 connection master;
55 drop table t1;
56
57 set global log_bin_compress=@old_log_bin_compress;
58 set global log_bin_compress_min_len=@old_log_bin_compress_min_len;
59 set binlog_format=@old_binlog_format;
60 set binlog_row_image=@old_binlog_row_image;
61 --source include/rpl_end.inc