1include/master-slave.inc 2[connection master] 3**** On Master **** 4CREATE TABLE t1 (a INT PRIMARY KEY, b LONG) ENGINE=NDB; 5INSERT INTO t1 VALUES (1,1), (2,2); 6SELECT * FROM t1 ORDER BY a,b; 7a b 81 1 92 2 10**** On Slave **** 11INSERT INTO t1 VALUE (3,3); 12SELECT * FROM t1 ORDER BY a,b; 13a b 141 1 152 2 163 3 17**** On Master **** 18TRUNCATE TABLE t1; 19SELECT * FROM t1 ORDER BY a,b; 20a b 21**** On Slave **** 22SELECT * FROM t1 ORDER BY a,b; 23a b 24**** On Master **** 25DROP TABLE t1; 26show binlog events from <binlog_start>; 27Log_name Pos Event_type Server_id End_log_pos Info 28master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT PRIMARY KEY, b LONG) ENGINE=NDB 29master-bin.000001 # Query # # BEGIN 30master-bin.000001 # Table_map # # table_id: # (test.t1) 31master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status) 32master-bin.000001 # Write_rows # # table_id: # 33master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F 34master-bin.000001 # Query # # COMMIT 35master-bin.000001 # Query # # use `test`; TRUNCATE TABLE t1 36master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */ 37**** On Master **** 38CREATE TABLE t1 (a INT PRIMARY KEY, b LONG) ENGINE=NDB; 39INSERT INTO t1 VALUES (1,1), (2,2); 40SELECT * FROM t1 ORDER BY a,b; 41a b 421 1 432 2 44**** On Slave **** 45INSERT INTO t1 VALUE (3,3); 46SELECT * FROM t1 ORDER BY a,b; 47a b 481 1 492 2 503 3 51**** On Master **** 52DELETE FROM t1; 53SELECT * FROM t1 ORDER BY a,b; 54a b 55**** On Slave **** 56SELECT * FROM t1 ORDER BY a,b; 57a b 583 3 59**** On Master **** 60DROP TABLE t1; 61show binlog events from <binlog_start>; 62Log_name Pos Event_type Server_id End_log_pos Info 63master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT PRIMARY KEY, b LONG) ENGINE=NDB 64master-bin.000001 # Query # # BEGIN 65master-bin.000001 # Table_map # # table_id: # (test.t1) 66master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status) 67master-bin.000001 # Write_rows # # table_id: # 68master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F 69master-bin.000001 # Query # # COMMIT 70master-bin.000001 # Query # # use `test`; TRUNCATE TABLE t1 71master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */ 72master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT PRIMARY KEY, b LONG) ENGINE=NDB 73master-bin.000001 # Query # # BEGIN 74master-bin.000001 # Table_map # # table_id: # (test.t1) 75master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status) 76master-bin.000001 # Write_rows # # table_id: # 77master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F 78master-bin.000001 # Query # # COMMIT 79master-bin.000001 # Query # # BEGIN 80master-bin.000001 # Table_map # # table_id: # (test.t1) 81master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status) 82master-bin.000001 # Write_rows # # table_id: # 83master-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F 84master-bin.000001 # Query # # COMMIT 85master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */ 86include/rpl_end.inc 87