rpl_truncate_2myisam.result 5.9 KB
Newer Older
1 2 3 4 5 6
stop slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
reset master;
reset slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
start slave;
7 8 9 10 11
STOP SLAVE;
DROP TABLE IF EXISTS t1;
DROP TABLE IF EXISTS t1;
RESET SLAVE;
START SLAVE;
12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
**** On Master ****
SET SESSION BINLOG_FORMAT=STATEMENT;
SET GLOBAL  BINLOG_FORMAT=STATEMENT;
CREATE TABLE t1 (a INT, b LONG) ENGINE=MyISAM;
INSERT INTO t1 VALUES (1,1), (2,2);
SELECT * FROM t1;
a	b
1	1
2	2
**** On Slave ****
INSERT INTO t1 VALUE (3,3);
SELECT * FROM t1;
a	b
1	1
2	2
3	3
**** On Master ****
TRUNCATE TABLE t1;
SELECT * FROM t1;
a	b
**** On Slave ****
SELECT * FROM t1;
a	b
**** On Master ****
DROP TABLE t1;
unknown's avatar
unknown committed
37
show binlog events from <binlog_start>;
38
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
39
master-bin.000001	#	Query	#	#	use `test`; DROP TABLE IF EXISTS t1
unknown's avatar
unknown committed
40 41 42 43
master-bin.000001	#	Query	#	#	use `test`; CREATE TABLE t1 (a INT, b LONG) ENGINE=MyISAM
master-bin.000001	#	Query	#	#	use `test`; INSERT INTO t1 VALUES (1,1), (2,2)
master-bin.000001	#	Query	#	#	use `test`; TRUNCATE TABLE t1
master-bin.000001	#	Query	#	#	use `test`; DROP TABLE t1
44 45 46 47 48 49
RESET MASTER;
STOP SLAVE;
DROP TABLE IF EXISTS t1;
DROP TABLE IF EXISTS t1;
RESET SLAVE;
START SLAVE;
50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74
**** On Master ****
SET SESSION BINLOG_FORMAT=MIXED;
SET GLOBAL  BINLOG_FORMAT=MIXED;
CREATE TABLE t1 (a INT, b LONG) ENGINE=MyISAM;
INSERT INTO t1 VALUES (1,1), (2,2);
SELECT * FROM t1;
a	b
1	1
2	2
**** On Slave ****
INSERT INTO t1 VALUE (3,3);
SELECT * FROM t1;
a	b
1	1
2	2
3	3
**** On Master ****
TRUNCATE TABLE t1;
SELECT * FROM t1;
a	b
**** On Slave ****
SELECT * FROM t1;
a	b
**** On Master ****
DROP TABLE t1;
unknown's avatar
unknown committed
75
show binlog events from <binlog_start>;
76
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
77
master-bin.000001	#	Query	#	#	use `test`; DROP TABLE IF EXISTS t1
unknown's avatar
unknown committed
78 79 80 81
master-bin.000001	#	Query	#	#	use `test`; CREATE TABLE t1 (a INT, b LONG) ENGINE=MyISAM
master-bin.000001	#	Query	#	#	use `test`; INSERT INTO t1 VALUES (1,1), (2,2)
master-bin.000001	#	Query	#	#	use `test`; TRUNCATE TABLE t1
master-bin.000001	#	Query	#	#	use `test`; DROP TABLE t1
82 83 84 85 86 87
RESET MASTER;
STOP SLAVE;
DROP TABLE IF EXISTS t1;
DROP TABLE IF EXISTS t1;
RESET SLAVE;
START SLAVE;
88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
**** On Master ****
SET SESSION BINLOG_FORMAT=ROW;
SET GLOBAL  BINLOG_FORMAT=ROW;
CREATE TABLE t1 (a INT, b LONG) ENGINE=MyISAM;
INSERT INTO t1 VALUES (1,1), (2,2);
SELECT * FROM t1;
a	b
1	1
2	2
**** On Slave ****
INSERT INTO t1 VALUE (3,3);
SELECT * FROM t1;
a	b
1	1
2	2
3	3
**** On Master ****
TRUNCATE TABLE t1;
SELECT * FROM t1;
a	b
**** On Slave ****
SELECT * FROM t1;
a	b
**** On Master ****
DROP TABLE t1;
unknown's avatar
unknown committed
113
show binlog events from <binlog_start>;
114
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
115
master-bin.000001	#	Query	#	#	use `test`; DROP TABLE IF EXISTS t1
unknown's avatar
unknown committed
116 117 118 119 120
master-bin.000001	#	Query	#	#	use `test`; CREATE TABLE t1 (a INT, b LONG) ENGINE=MyISAM
master-bin.000001	#	Table_map	#	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	use `test`; TRUNCATE TABLE t1
master-bin.000001	#	Query	#	#	use `test`; DROP TABLE t1
121 122 123 124 125 126
RESET MASTER;
STOP SLAVE;
DROP TABLE IF EXISTS t1;
DROP TABLE IF EXISTS t1;
RESET SLAVE;
START SLAVE;
127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151
**** On Master ****
SET SESSION BINLOG_FORMAT=STATEMENT;
SET GLOBAL  BINLOG_FORMAT=STATEMENT;
CREATE TABLE t1 (a INT, b LONG) ENGINE=MyISAM;
INSERT INTO t1 VALUES (1,1), (2,2);
SELECT * FROM t1;
a	b
1	1
2	2
**** On Slave ****
INSERT INTO t1 VALUE (3,3);
SELECT * FROM t1;
a	b
1	1
2	2
3	3
**** On Master ****
DELETE FROM t1;
SELECT * FROM t1;
a	b
**** On Slave ****
SELECT * FROM t1;
a	b
**** On Master ****
DROP TABLE t1;
unknown's avatar
unknown committed
152
show binlog events from <binlog_start>;
153
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
154
master-bin.000001	#	Query	#	#	use `test`; DROP TABLE IF EXISTS t1
unknown's avatar
unknown committed
155 156 157 158
master-bin.000001	#	Query	#	#	use `test`; CREATE TABLE t1 (a INT, b LONG) ENGINE=MyISAM
master-bin.000001	#	Query	#	#	use `test`; INSERT INTO t1 VALUES (1,1), (2,2)
master-bin.000001	#	Query	#	#	use `test`; DELETE FROM t1
master-bin.000001	#	Query	#	#	use `test`; DROP TABLE t1
159 160 161 162 163 164
RESET MASTER;
STOP SLAVE;
DROP TABLE IF EXISTS t1;
DROP TABLE IF EXISTS t1;
RESET SLAVE;
START SLAVE;
165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189
**** On Master ****
SET SESSION BINLOG_FORMAT=MIXED;
SET GLOBAL  BINLOG_FORMAT=MIXED;
CREATE TABLE t1 (a INT, b LONG) ENGINE=MyISAM;
INSERT INTO t1 VALUES (1,1), (2,2);
SELECT * FROM t1;
a	b
1	1
2	2
**** On Slave ****
INSERT INTO t1 VALUE (3,3);
SELECT * FROM t1;
a	b
1	1
2	2
3	3
**** On Master ****
DELETE FROM t1;
SELECT * FROM t1;
a	b
**** On Slave ****
SELECT * FROM t1;
a	b
**** On Master ****
DROP TABLE t1;
unknown's avatar
unknown committed
190
show binlog events from <binlog_start>;
191
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
192
master-bin.000001	#	Query	#	#	use `test`; DROP TABLE IF EXISTS t1
unknown's avatar
unknown committed
193 194 195 196
master-bin.000001	#	Query	#	#	use `test`; CREATE TABLE t1 (a INT, b LONG) ENGINE=MyISAM
master-bin.000001	#	Query	#	#	use `test`; INSERT INTO t1 VALUES (1,1), (2,2)
master-bin.000001	#	Query	#	#	use `test`; DELETE FROM t1
master-bin.000001	#	Query	#	#	use `test`; DROP TABLE t1
197 198 199 200 201 202
RESET MASTER;
STOP SLAVE;
DROP TABLE IF EXISTS t1;
DROP TABLE IF EXISTS t1;
RESET SLAVE;
START SLAVE;
203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228
**** On Master ****
SET SESSION BINLOG_FORMAT=ROW;
SET GLOBAL  BINLOG_FORMAT=ROW;
CREATE TABLE t1 (a INT, b LONG) ENGINE=MyISAM;
INSERT INTO t1 VALUES (1,1), (2,2);
SELECT * FROM t1;
a	b
1	1
2	2
**** On Slave ****
INSERT INTO t1 VALUE (3,3);
SELECT * FROM t1;
a	b
1	1
2	2
3	3
**** On Master ****
DELETE FROM t1;
SELECT * FROM t1;
a	b
**** On Slave ****
SELECT * FROM t1;
a	b
3	3
**** On Master ****
DROP TABLE t1;
unknown's avatar
unknown committed
229
show binlog events from <binlog_start>;
230
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
231
master-bin.000001	#	Query	#	#	use `test`; DROP TABLE IF EXISTS t1
unknown's avatar
unknown committed
232 233 234 235 236 237
master-bin.000001	#	Query	#	#	use `test`; CREATE TABLE t1 (a INT, b LONG) ENGINE=MyISAM
master-bin.000001	#	Table_map	#	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	#	#	table_id: # (test.t1)
master-bin.000001	#	Delete_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	use `test`; DROP TABLE t1
238
RESET MASTER;