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
/*
PLUG: http://plug.org, #utah on irc.freenode.net
Unsubscribe: http://plug.org/mailman/options/plug
Don't fear the penguin.
*/
