auto increment offset

MySQL Master Master Replication and auto_increment_increment / auto_increment_offset

In this post we will see importance of replication related variables auto_increment_increment & auto_increment_offset with respect to MySQL Master Master setup. Consider we’ve already set a master-master replication. Now create following table on Server1: `id` int(10) NOT NULL auto_increment, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1; The table will will get replicated on Mysql Server2 in the master-master setup. Now insert value on Mysql Server1 as follows: mysql>insert into temp values(null); On Mysql Server2 in replication you will see single row inserted. Now insert one row from Mysql Server2 as follows: mysql>insert into temp values(null); You should see an...