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;
1
include/master-slave.inc
7
3
==========MASTER==========
8
4
show global variables like 'binlog_format%';
138
134
******************** SHOW BINLOG EVENTS ********************
139
show binlog events from 1;
135
show binlog events from <binlog_start>;
140
136
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
137
master-bin.000001 # Query # # DROP DATABASE IF EXISTS test_rpl
138
master-bin.000001 # Query # # DROP DATABASE IF EXISTS test_rpl_1
139
master-bin.000001 # Query # # CREATE DATABASE test_rpl_1 CHARACTER SET utf8 COLLATE utf8_general_ci
140
master-bin.000001 # Query # # ALTER DATABASE test_rpl_1 CHARACTER SET latin1 COLLATE latin1_general_ci
141
master-bin.000001 # Query # # DROP DATABASE test_rpl_1
142
master-bin.000001 # Query # # CREATE DATABASE test_rpl CHARACTER SET utf8 COLLATE utf8_general_ci
143
master-bin.000001 # Query # # ALTER DATABASE test_rpl CHARACTER SET latin1 COLLATE latin1_swedish_ci
144
master-bin.000001 # Query # # use `test_rpl`; CREATE TABLE t0 (a int auto_increment not null, c int not null, PRIMARY KEY(a), KEY index2 (c)) ENGINE=innodb
145
master-bin.000001 # Query # # use `test_rpl`; ALTER TABLE t0 DROP INDEX index2
146
master-bin.000001 # Query # # use `test_rpl`; ALTER TABLE t0 ADD COLUMN b char(254)
147
master-bin.000001 # Query # # use `test_rpl`; ALTER TABLE t0 ADD INDEX index1 (b)
148
master-bin.000001 # Query # # use `test_rpl`; ALTER TABLE t0 DROP COLUMN c
149
master-bin.000001 # Query # # use `test_rpl`; RENAME TABLE t0 TO t1
150
master-bin.000001 # Query # # use `test_rpl`; CREATE TABLE t2 LIKE t1
151
master-bin.000001 # Query # # use `test_rpl`; ALTER TABLE t2 ADD COLUMN d datetime
152
master-bin.000001 # Query # # use `test_rpl`; CREATE INDEX index2 on t2 (d)
153
master-bin.000001 # Query # # use `test_rpl`; CREATE INDEX index3 on t2 (a, d)
154
master-bin.000001 # Query # # use `test_rpl`; ALTER TABLE t2 DROP COLUMN d
160
155
drop database test_rpl;