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; create table t1 (a int key, b int) engine innodb; create table t2 (a int key, b int) engine innodb; alter table t1 engine ndb; alter table t2 engine ndb; insert into t1 values (1,2); select @start_pos:=start_pos, @end_pos:=end_pos from mysql.ndb_apply_status; @start_pos:=start_pos @end_pos:=end_pos show binlog events from limit 1; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 Query 1 # use `test`; insert into t1 values (1,2) show binlog events from limit 1,1; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Xid 1 445 COMMIT /* XID */ begin; insert into t1 values (2,3); insert into t2 values (3,4); commit; select @start_pos:=start_pos, @end_pos:=end_pos from mysql.ndb_apply_status; @start_pos:=start_pos @end_pos:=end_pos show binlog events from limit 1; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 Query 1 # use `test`; BEGIN show binlog events from limit 1,2; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # use `test`; insert into t1 values (2,3) master-bin.000001 # Query # # use `test`; insert into t2 values (3,4) show binlog events from limit 3,1; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Xid 1 COMMIT /* XID */ DROP TABLE t1,t2; CREATE TABLE t1 (c1 INT AUTO_INCREMENT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 INT NOT NULL); SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL AUTO_INCREMENT, `c2` int(11) NOT NULL, `c3` int(11) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ***** insert some data ***** SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL AUTO_INCREMENT, `c2` int(11) NOT NULL, `c3` int(11) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 select @start_pos:=start_pos, @end_pos:=end_pos from mysql.ndb_apply_status; @start_pos:=start_pos @end_pos:=end_pos show binlog events from limit 1; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 Intvar 1 # INSERT_ID=10 show binlog events from limit 1,1; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query 1 126 use `test`; INSERT INTO t1 VALUES(NULL,1*2,1+3) set autocommit=0; select * from mysql.ndb_apply_status; server_id epoch log_name start_pos end_pos 1 0 master-bin.000001 2488 3845 select @start_pos:=start_pos, @end_pos:=end_pos from mysql.ndb_apply_status; @start_pos:=start_pos @end_pos:=end_pos SHOW BINLOG EVENTS; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 4 Format_desc 1 106 Server ver: 5.1.18-ndb-6.2.1-log, Binlog ver: 4 master-bin.000001 106 Query 1 217 use `test`; create table t1 (a int key, b int) engine innodb master-bin.000001 217 Query 1 328 use `test`; create table t2 (a int key, b int) engine innodb master-bin.000001 328 Query 1 90 use `test`; insert into t1 values (1,2) master-bin.000001 418 Xid 1 445 COMMIT /* xid=17 */ master-bin.000001 445 Query 1 513 use `test`; BEGIN master-bin.000001 513 Query 1 90 use `test`; insert into t1 values (2,3) master-bin.000001 603 Query 1 180 use `test`; insert into t2 values (3,4) master-bin.000001 693 Xid 1 720 COMMIT /* xid=24 */ master-bin.000001 720 Query 1 799 use `test`; DROP TABLE t1,t2 master-bin.000001 799 Query 1 956 use `test`; CREATE TABLE t1 (c1 INT AUTO_INCREMENT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 INT NOT NULL) master-bin.000001 956 Intvar 1 28 INSERT_ID=1 master-bin.000001 984 Query 1 128 use `test`; INSERT INTO t1 VALUES(NULL,10*2,10+3) master-bin.000001 1084 Xid 1 1111 COMMIT /* xid=39 */ master-bin.000001 1111 Intvar 1 28 INSERT_ID=2 master-bin.000001 1139 Query 1 126 use `test`; INSERT INTO t1 VALUES(NULL,9*2,9+3) master-bin.000001 1237 Xid 1 1264 COMMIT /* xid=40 */ master-bin.000001 1264 Intvar 1 28 INSERT_ID=3 master-bin.000001 1292 Query 1 126 use `test`; INSERT INTO t1 VALUES(NULL,8*2,8+3) master-bin.000001 1390 Xid 1 1417 COMMIT /* xid=41 */ master-bin.000001 1417 Intvar 1 28 INSERT_ID=4 master-bin.000001 1445 Query 1 126 use `test`; INSERT INTO t1 VALUES(NULL,7*2,7+3) master-bin.000001 1543 Xid 1 1570 COMMIT /* xid=42 */ master-bin.000001 1570 Intvar 1 28 INSERT_ID=5 master-bin.000001 1598 Query 1 126 use `test`; INSERT INTO t1 VALUES(NULL,6*2,6+3) master-bin.000001 1696 Xid 1 1723 COMMIT /* xid=43 */ master-bin.000001 1723 Intvar 1 28 INSERT_ID=6 master-bin.000001 1751 Query 1 126 use `test`; INSERT INTO t1 VALUES(NULL,5*2,5+3) master-bin.000001 1849 Xid 1 1876 COMMIT /* xid=44 */ master-bin.000001 1876 Intvar 1 28 INSERT_ID=7 master-bin.000001 1904 Query 1 126 use `test`; INSERT INTO t1 VALUES(NULL,4*2,4+3) master-bin.000001 2002 Xid 1 2029 COMMIT /* xid=45 */ master-bin.000001 2029 Intvar 1 28 INSERT_ID=8 master-bin.000001 2057 Query 1 126 use `test`; INSERT INTO t1 VALUES(NULL,3*2,3+3) master-bin.000001 2155 Xid 1 2182 COMMIT /* xid=46 */ master-bin.000001 2182 Intvar 1 28 INSERT_ID=9 master-bin.000001 2210 Query 1 126 use `test`; INSERT INTO t1 VALUES(NULL,2*2,2+3) master-bin.000001 2308 Xid 1 2335 COMMIT /* xid=47 */ master-bin.000001 2335 Intvar 1 28 INSERT_ID=10 master-bin.000001 2363 Query 1 126 use `test`; INSERT INTO t1 VALUES(NULL,1*2,1+3) master-bin.000001 2461 Xid 1 2488 COMMIT /* xid=48 */ master-bin.000001 2488 Query 1 2556 use `test`; BEGIN master-bin.000001 2556 Intvar 1 28 INSERT_ID=11 master-bin.000001 2584 Query 1 128 use `test`; INSERT INTO t1 VALUES(NULL,10*2,10+3) master-bin.000001 2684 Intvar 1 156 INSERT_ID=12 master-bin.000001 2712 Query 1 254 use `test`; INSERT INTO t1 VALUES(NULL,9*2,9+3) master-bin.000001 2810 Intvar 1 282 INSERT_ID=13 master-bin.000001 2838 Query 1 380 use `test`; INSERT INTO t1 VALUES(NULL,8*2,8+3) master-bin.000001 2936 Intvar 1 408 INSERT_ID=14 master-bin.000001 2964 Query 1 506 use `test`; INSERT INTO t1 VALUES(NULL,7*2,7+3) master-bin.000001 3062 Intvar 1 534 INSERT_ID=15 master-bin.000001 3090 Query 1 632 use `test`; INSERT INTO t1 VALUES(NULL,6*2,6+3) master-bin.000001 3188 Intvar 1 660 INSERT_ID=16 master-bin.000001 3216 Query 1 758 use `test`; INSERT INTO t1 VALUES(NULL,5*2,5+3) master-bin.000001 3314 Intvar 1 786 INSERT_ID=17 master-bin.000001 3342 Query 1 884 use `test`; INSERT INTO t1 VALUES(NULL,4*2,4+3) master-bin.000001 3440 Intvar 1 912 INSERT_ID=18 master-bin.000001 3468 Query 1 1010 use `test`; INSERT INTO t1 VALUES(NULL,3*2,3+3) master-bin.000001 3566 Intvar 1 1038 INSERT_ID=19 master-bin.000001 3594 Query 1 1136 use `test`; INSERT INTO t1 VALUES(NULL,2*2,2+3) master-bin.000001 3692 Intvar 1 1164 INSERT_ID=20 master-bin.000001 3720 Query 1 1262 use `test`; INSERT INTO t1 VALUES(NULL,1*2,1+3) master-bin.000001 3818 Xid 1 3845 COMMIT /* xid=56 */ show binlog events from limit 1; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 Query 1 # use `test`; BEGIN show binlog events from limit 1,1; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Intvar 1 28 INSERT_ID=11 select * from mysql.ndb_apply_status; server_id epoch log_name start_pos end_pos 1 0 master-bin.000001 2488 3845