This is no more an issue with latest-5.6. Please upgrade and re-try. source-node: mysql> CREATE TABLE `t2` ( -> `id` int(11) NOT NULL AUTO_INCREMENT, -> `idd` int(11) DEFAULT NULL, -> PRIMARY KEY (`id`) -> ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COLLATE=utf8_bin -> ; Query OK, 0 rows affected (0.06 sec) mysql> select * from t2; Empty set (0.00 sec) mysql> insert into t2 values (1, 100); Query OK, 1 row affected (0.02 sec) mysql> select * from t2; +----+------+ | id | idd | +----+------+ | 1 | 100 | +----+------+ 1 row in set (0.00 sec) mysql> update t2 set id=40 where id=1; Query OK, 1 row affected (0.02 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> select * from t2; +----+------+ | id | idd | +----+------+ | 40 | 100 | +----+------+ 1 row in set (0.00 sec) mysql> replace t2 values(40,2); Query OK, 2 rows affected (0.01 sec) mysql> select * from t2; +----+------+ | id | idd | +----+------+ | 40 | 2 | +----+------+ 1 row in set (0.00 sec) mysql> show create table t2; +-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | t2 | CREATE TABLE `t2` ( `id` int(11) NOT NULL AUTO_INCREMENT, `idd` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 COLLATE=utf8_bin | +-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> select * from t2; +----+------+ | id | idd | +----+------+ | 40 | 2 | | 41 | 0 | +----+------+ 2 rows in set (0.00 sec) mysql> --------- replicated-node mysql> select * from t2; +----+------+ | id | idd | +----+------+ | 40 | 100 | +----+------+ 1 row in set (0.00 sec) mysql> select * from t2; +----+------+ | id | idd | +----+------+ | 40 | 2 | +----+------+ 1 row in set (0.00 sec) mysql> show create table t2; +-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | t2 | CREATE TABLE `t2` ( `id` int(11) NOT NULL AUTO_INCREMENT, `idd` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 COLLATE=utf8_bin | +-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> insert into t2(idd) values(0); Query OK, 1 row affected (0.01 sec) mysql> select * from t2; +----+------+ | id | idd | +----+------+ | 40 | 2 | | 41 | 0 | +----+------+ 2 rows in set (0.00 sec) mysql>