Showing entries 1 to 1
Displaying posts with tag: auto increment offset (reset)
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 […]

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

Showing entries 1 to 1