On 8 Jul 2009, at 22:26, Aaron Blew wrote:
The simplest method may be to set them up in a multi-master configuration,similar to what's documented here: http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.htmlThis way you won't have to worry about switching between two masters in afailover scenario since they're both writable.
That setup works very well for me, but I also use google's mmm on top of it so that the switch is transparent to client apps. Works beautifully.
https://launchpad.net/mysql-mmm Marcus -- Marcus Bointon Synchromedia Limited: Creators of http://www.smartmessages.net/ UK resellers of i...@hand CRM solutions mar...@synchromedia.co.uk | http://www.synchromedia.co.uk/
smime.p7s
Description: S/MIME cryptographic signature