Mysql 2 way replication?
kimball at kimballlarsen.com
Sat Jan 14 14:36:01 MST 2006
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:
>> 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
> 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
> 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.
More information about the PLUG