Check that server2 is not writing binlog CREATE TABLE t1 ( a bigint unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY, b int unsigned not null, c int unsigned ) engine=ndbcluster; insert records into table on server1 insert records into table on server2 to get cached auto_increment values Check that auto_increment values are correctly generated select count(*) from t1; count(*) 5000 select * from t1 order by a limit 2; a b c 1 509 2500 2 510 7 truncate table t1; Check that server2 has properly reset the cached auto_increment values select count(*) from t1; count(*) 0 insert into t1 values(NULL,1,1),(NULL,2,2); select * from t1 order by a; a b c 1 1 1 2 2 2 drop table t1;