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 […]

The post MySQL Master Master Replication and auto_increment_increment / auto_increment_offset first appeared on ..::CHANGE is INEVITABLE::...