--source include/master-slave.inc --source include/have_innodb.inc set binlog_format='row'; CREATE TABLE `counter_test` ( `counter` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `counter_number` tinyint(3) unsigned NOT NULL, PRIMARY KEY (`counter`), UNIQUE KEY `counter_number` (`counter_number`) ) ENGINE=InnoDB AUTO_INCREMENT=50; REPLACE INTO `counter_test` (`counter_number`) VALUES (1); select * from counter_test; show create table counter_test; sleep 1; connection slave; select * from counter_test; show create table counter_test; connection master; REPLACE INTO `counter_test` (`counter_number`) VALUES (1); select * from counter_test; show create table counter_test; sleep 1; connection slave; select * from counter_test; show create table counter_test;