30
30
SHOW BINLOG EVENTS;
31
31
Log_name Pos Event_type Server_id End_log_pos Info
32
master-bin.000001 4 Format_desc 1 102 Server ver: SERVER_VERSION, Binlog ver: 4
33
master-bin.000001 102 Query 1 219 use `test`; CREATE TABLE t1 (a INT PRIMARY KEY, b LONG) ENGINE=NDB
34
master-bin.000001 219 Query 1 283 BEGIN
35
master-bin.000001 283 Table_map 1 40 table_id: # (test.t1)
36
master-bin.000001 323 Table_map 1 95 table_id: # (mysql.ndb_apply_status)
37
master-bin.000001 378 Write_rows 1 137 table_id: #
38
master-bin.000001 420 Write_rows 1 184 table_id: # flags: STMT_END_F
39
master-bin.000001 467 Query 1 532 COMMIT
40
master-bin.000001 532 Query 1 612 use `test`; TRUNCATE TABLE t1
41
master-bin.000001 612 Query 1 688 use `test`; DROP TABLE t1
32
master-bin.000001 4 Format_desc 1 106 Server ver: SERVER_VERSION, Binlog ver: 4
33
master-bin.000001 106 Query 1 223 use `test`; CREATE TABLE t1 (a INT PRIMARY KEY, b LONG) ENGINE=NDB
34
master-bin.000001 223 Query 1 287 BEGIN
35
master-bin.000001 287 Table_map 1 40 table_id: # (test.t1)
36
master-bin.000001 327 Table_map 1 98 table_id: # (mysql.ndb_apply_status)
37
master-bin.000001 385 Write_rows 1 157 table_id: #
38
master-bin.000001 444 Write_rows 1 195 table_id: #
39
master-bin.000001 482 Write_rows 1 233 table_id: # flags: STMT_END_F
40
master-bin.000001 520 Query 1 585 COMMIT
41
master-bin.000001 585 Query 1 665 use `test`; TRUNCATE TABLE t1
42
master-bin.000001 665 Query 1 741 use `test`; DROP TABLE t1
42
43
**** On Master ****
43
44
CREATE TABLE t1 (a INT PRIMARY KEY, b LONG) ENGINE=NDB;
44
45
INSERT INTO t1 VALUES (1,1), (2,2);
66
67
SHOW BINLOG EVENTS;
67
68
Log_name Pos Event_type Server_id End_log_pos Info
68
master-bin.000001 4 Format_desc 1 102 Server ver: SERVER_VERSION, Binlog ver: 4
69
master-bin.000001 102 Query 1 219 use `test`; CREATE TABLE t1 (a INT PRIMARY KEY, b LONG) ENGINE=NDB
70
master-bin.000001 219 Query 1 283 BEGIN
71
master-bin.000001 283 Table_map 1 40 table_id: # (test.t1)
72
master-bin.000001 323 Table_map 1 95 table_id: # (mysql.ndb_apply_status)
73
master-bin.000001 378 Write_rows 1 137 table_id: #
74
master-bin.000001 420 Write_rows 1 184 table_id: # flags: STMT_END_F
75
master-bin.000001 467 Query 1 532 COMMIT
76
master-bin.000001 532 Query 1 612 use `test`; TRUNCATE TABLE t1
77
master-bin.000001 612 Query 1 688 use `test`; DROP TABLE t1
78
master-bin.000001 688 Query 1 805 use `test`; CREATE TABLE t1 (a INT PRIMARY KEY, b LONG) ENGINE=NDB
79
master-bin.000001 805 Query 1 869 BEGIN
80
master-bin.000001 869 Table_map 1 40 table_id: # (test.t1)
81
master-bin.000001 909 Table_map 1 95 table_id: # (mysql.ndb_apply_status)
82
master-bin.000001 964 Write_rows 1 137 table_id: #
83
master-bin.000001 1006 Write_rows 1 184 table_id: # flags: STMT_END_F
84
master-bin.000001 1053 Query 1 1118 COMMIT
85
master-bin.000001 1118 Query 1 1182 BEGIN
86
master-bin.000001 1182 Table_map 1 40 table_id: # (test.t1)
87
master-bin.000001 1222 Table_map 1 95 table_id: # (mysql.ndb_apply_status)
88
master-bin.000001 1277 Write_rows 1 137 table_id: #
89
master-bin.000001 1319 Delete_rows 1 176 table_id: # flags: STMT_END_F
90
master-bin.000001 1358 Query 1 1423 COMMIT
91
master-bin.000001 1423 Query 1 1499 use `test`; DROP TABLE t1
69
master-bin.000001 4 Format_desc 1 106 Server ver: SERVER_VERSION, Binlog ver: 4
70
master-bin.000001 106 Query 1 223 use `test`; CREATE TABLE t1 (a INT PRIMARY KEY, b LONG) ENGINE=NDB
71
master-bin.000001 223 Query 1 287 BEGIN
72
master-bin.000001 287 Table_map 1 40 table_id: # (test.t1)
73
master-bin.000001 327 Table_map 1 98 table_id: # (mysql.ndb_apply_status)
74
master-bin.000001 385 Write_rows 1 157 table_id: #
75
master-bin.000001 444 Write_rows 1 195 table_id: #
76
master-bin.000001 482 Write_rows 1 233 table_id: # flags: STMT_END_F
77
master-bin.000001 520 Query 1 585 COMMIT
78
master-bin.000001 585 Query 1 665 use `test`; TRUNCATE TABLE t1
79
master-bin.000001 665 Query 1 741 use `test`; DROP TABLE t1
80
master-bin.000001 741 Query 1 858 use `test`; CREATE TABLE t1 (a INT PRIMARY KEY, b LONG) ENGINE=NDB
81
master-bin.000001 858 Query 1 922 BEGIN
82
master-bin.000001 922 Table_map 1 40 table_id: # (test.t1)
83
master-bin.000001 962 Table_map 1 98 table_id: # (mysql.ndb_apply_status)
84
master-bin.000001 1020 Write_rows 1 157 table_id: #
85
master-bin.000001 1079 Write_rows 1 195 table_id: #
86
master-bin.000001 1117 Write_rows 1 233 table_id: # flags: STMT_END_F
87
master-bin.000001 1155 Query 1 1220 COMMIT
88
master-bin.000001 1220 Query 1 1284 BEGIN
89
master-bin.000001 1284 Table_map 1 40 table_id: # (test.t1)
90
master-bin.000001 1324 Table_map 1 98 table_id: # (mysql.ndb_apply_status)
91
master-bin.000001 1382 Write_rows 1 157 table_id: #
92
master-bin.000001 1441 Delete_rows 1 191 table_id: #
93
master-bin.000001 1475 Delete_rows 1 225 table_id: # flags: STMT_END_F
94
master-bin.000001 1509 Query 1 1574 COMMIT
95
master-bin.000001 1574 Query 1 1650 use `test`; DROP TABLE t1