“This tutorial describes how to set up MySQL master-master replication. We need to replicate MySQL servers to achieve high-availability. In my case I need two masters that are synchronized with each other so that if one of them drops down, other could take over and no data is lost. Similarly when the first one goes up again, it will still be used as slave for the live one. Here is a basic step by step tutorial, that will cover the mysql master and slave replication and also will describe the mysql master and master replication.”
Here they describe how to manage multimaster replication
auto_inc key issues
http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replic…
thanks, that’s an excellent article