Mysql 2 way replication?

[Kimball Larsen]

On Jan 13, 2006, at 4:31 PM, Nicholas Leippe wrote:

> On Friday 13 January 2006 03:00 pm, Kimball Larsen wrote:
>> This has come up in the past, but I've recently taken a fresh
>> interest.  The last time I looked into 2 way replication with Mysql,
>> I was told that it basically was a really bad idea.  Now, it appears
>> that it may not only be a not-so-bad idea, but the fine folks at
>> Mysql mention some caveats to watch for when setting it up:
>>
>> http://dev.mysql.com/doc/refman/5.0/en/replication-faq.html
>>
>> However, they don't mention HOW to set it up.  Do you just set up
>> each note to be both a master and slave and point them the way you  
>> need?
>
> Yes.  Just make sure each node has a unique server id.  You can, in  
> fact, set
> up a ring of servers.  The only caveats are properly writing your  
> application
> since unique ids (auto_increment) becomes unreliable.  (As do anything
> depending on random numbers, although this may have been fixed).

Sounds simple enough - luckily our application has already been set  
up correctly to avoid the current pitfalls of Mysql replication, so  
we should be ok.

-- Kimball