2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
==========MASTER==========
8
show global variables like 'binlog_format%';
11
show session variables like 'binlog_format%';
14
select @@global.binlog_format, @@session.binlog_format;
15
@@global.binlog_format @@session.binlog_format
17
==========SLAVE===========
18
show global variables like 'binlog_format%';
21
show session variables like 'binlog_format%';
24
select @@global.binlog_format, @@session.binlog_format;
25
@@global.binlog_format @@session.binlog_format
28
******************** DDL for database ********************
29
DROP DATABASE IF EXISTS test_rpl;
30
DROP DATABASE IF EXISTS test_rpl_1;
31
CREATE DATABASE test_rpl_1 CHARACTER SET utf8 COLLATE utf8_general_ci;
32
ALTER DATABASE test_rpl_1 CHARACTER SET latin1 COLLATE latin1_general_ci;
33
DROP DATABASE test_rpl_1;
34
CREATE DATABASE test_rpl CHARACTER SET utf8 COLLATE utf8_general_ci;
35
ALTER DATABASE test_rpl CHARACTER SET latin1 COLLATE latin1_swedish_ci;
36
==========MASTER==========
37
SHOW DATABASES LIKE 'test_rpl%';
40
==========SLAVE===========
41
SHOW DATABASES LIKE 'test_rpl%';
46
******************** DDL for tables ********************
47
CREATE TABLE t0 (a int auto_increment not null, c int not null, PRIMARY KEY(a), KEY index2 (c)) ENGINE=innodb;
48
ALTER TABLE t0 DROP INDEX index2;
49
ALTER TABLE t0 ADD COLUMN b char(254);
50
ALTER TABLE t0 ADD INDEX index1 (b);
51
ALTER TABLE t0 DROP COLUMN c;
52
RENAME TABLE t0 TO t1;
53
CREATE TABLE t2 LIKE t1;
54
==========MASTER==========
57
t1 CREATE TABLE `t1` (
58
`a` int(11) NOT NULL AUTO_INCREMENT,
59
`b` char(254) DEFAULT NULL,
62
) ENGINE=InnoDB DEFAULT CHARSET=latin1
65
t2 CREATE TABLE `t2` (
66
`a` int(11) NOT NULL AUTO_INCREMENT,
67
`b` char(254) DEFAULT NULL,
70
) ENGINE=InnoDB DEFAULT CHARSET=latin1
71
==========SLAVE===========
75
t1 CREATE TABLE `t1` (
76
`a` int(11) NOT NULL AUTO_INCREMENT,
77
`b` char(254) DEFAULT NULL,
80
) ENGINE=InnoDB DEFAULT CHARSET=latin1
83
t2 CREATE TABLE `t2` (
84
`a` int(11) NOT NULL AUTO_INCREMENT,
85
`b` char(254) DEFAULT NULL,
88
) ENGINE=InnoDB DEFAULT CHARSET=latin1
90
******************** DDL for indexes ********************
91
ALTER TABLE t2 ADD COLUMN d datetime;
92
CREATE INDEX index2 on t2 (d);
93
CREATE INDEX index3 on t2 (a, d);
94
==========MASTER==========
97
t1 CREATE TABLE `t1` (
98
`a` int(11) NOT NULL AUTO_INCREMENT,
99
`b` char(254) DEFAULT NULL,
102
) ENGINE=InnoDB DEFAULT CHARSET=latin1
103
SHOW CREATE TABLE t2;
105
t2 CREATE TABLE `t2` (
106
`a` int(11) NOT NULL AUTO_INCREMENT,
107
`b` char(254) DEFAULT NULL,
108
`d` datetime DEFAULT NULL,
112
KEY `index3` (`a`,`d`)
113
) ENGINE=InnoDB DEFAULT CHARSET=latin1
114
==========SLAVE===========
116
SHOW CREATE TABLE t1;
118
t1 CREATE TABLE `t1` (
119
`a` int(11) NOT NULL AUTO_INCREMENT,
120
`b` char(254) DEFAULT NULL,
123
) ENGINE=InnoDB DEFAULT CHARSET=latin1
124
SHOW CREATE TABLE t2;
126
t2 CREATE TABLE `t2` (
127
`a` int(11) NOT NULL AUTO_INCREMENT,
128
`b` char(254) DEFAULT NULL,
129
`d` datetime DEFAULT NULL,
133
KEY `index3` (`a`,`d`)
134
) ENGINE=InnoDB DEFAULT CHARSET=latin1
135
ALTER TABLE t2 DROP COLUMN d;
138
******************** SHOW BINLOG EVENTS ********************
139
show binlog events from 1;
140
Log_name Pos Event_type Server_id End_log_pos Info
141
master-bin.000001 # Format_desc 1 # Server ver: #
142
master-bin.000001 # Query 1 # DROP DATABASE IF EXISTS test_rpl
143
master-bin.000001 # Query 1 # DROP DATABASE IF EXISTS test_rpl_1
144
master-bin.000001 # Query 1 # CREATE DATABASE test_rpl_1 CHARACTER SET utf8 COLLATE utf8_general_ci
145
master-bin.000001 # Query 1 # ALTER DATABASE test_rpl_1 CHARACTER SET latin1 COLLATE latin1_general_ci
146
master-bin.000001 # Query 1 # DROP DATABASE test_rpl_1
147
master-bin.000001 # Query 1 # CREATE DATABASE test_rpl CHARACTER SET utf8 COLLATE utf8_general_ci
148
master-bin.000001 # Query 1 # ALTER DATABASE test_rpl CHARACTER SET latin1 COLLATE latin1_swedish_ci
149
master-bin.000001 # Query 1 # use `test_rpl`; CREATE TABLE t0 (a int auto_increment not null, c int not null, PRIMARY KEY(a), KEY index2 (c)) ENGINE=innodb
150
master-bin.000001 # Query 1 # use `test_rpl`; ALTER TABLE t0 DROP INDEX index2
151
master-bin.000001 # Query 1 # use `test_rpl`; ALTER TABLE t0 ADD COLUMN b char(254)
152
master-bin.000001 # Query 1 # use `test_rpl`; ALTER TABLE t0 ADD INDEX index1 (b)
153
master-bin.000001 # Query 1 # use `test_rpl`; ALTER TABLE t0 DROP COLUMN c
154
master-bin.000001 # Query 1 # use `test_rpl`; RENAME TABLE t0 TO t1
155
master-bin.000001 # Query 1 # use `test_rpl`; CREATE TABLE t2 LIKE t1
156
master-bin.000001 # Query 1 # use `test_rpl`; ALTER TABLE t2 ADD COLUMN d datetime
157
master-bin.000001 # Query 1 # use `test_rpl`; CREATE INDEX index2 on t2 (d)
158
master-bin.000001 # Query 1 # use `test_rpl`; CREATE INDEX index3 on t2 (a, d)
159
master-bin.000001 # Query 1 # use `test_rpl`; ALTER TABLE t2 DROP COLUMN d
160
drop database test_rpl;