I've done quite a lot of reading into this and I'm still I'm not sure where I stand.
Am I going to get database collisions (and then corruption) with two Masters both receiving writes ?
Now that MySQL (I'm using 5.1 on Debian and Ubuntu) has auto-increment running is this avoided and would it suit production ?
I've looked at MMM for only enabling one Master for writes but it has it's own issues and my topology is really geared towards having two Masters both receiving writes.
I'm not sure I believe this: http://www.neocodesoftware.com/replication/
Can any MySQL experts please help ? Thanks very much.
Half the stuff I read or people I ask say you'll still get corruption even using auto-increment ... and the other half say you won't ! Can someone who has run busy sites please clarify ?