[SteveSRS]

I have 2 servers in the UK and US. Currently they are rsync-ed and have a master - slave setup where the UK server is master.
Now when the master goes offline (which happens too often) the whole eCommerce system isn't working anymore.

So i'm looking for a setup to solve this problem. So far I've found that a master-master setup would solve the problem partly as
the ecommerce functionality wouldn't be offline if UK server is offline neither if US server is offline, however as far as I've researched looks like master - master setup has some drawbacks and when one server goes down and then comes back online it will most likely have replication issues which need manual fixing.

So what I need is a master - master with fail-over solution, however this seems to be very difficult with just 2 servers.

Does anybody have some suggestion for a master - master + fail-over solution?

I found this which seems interesting:
https://code.google....nal_replication

I think this does what I need, however I could use a bit more of step-by-step on what to do (a howto would be nice).

Thanks.

Best regards,

P.s. also willing to pay for setting this up

[SteveSRS]

just for others

In end end We setup the following
master - master with auto-increment-offset option
installed maatkit which checks critical tables (by checksum) every 12 hours (3 times with intervals of couple minutes) if they are in-sync on the both servers. If not it syncs the 2 servers and it sends me a notification (you could also just choose a notification).

The new system isn't yet completely in production but seems to be working smooth so far. Soon we will put new website plus new system completely in production (at the moment mysql writing is still only done on UK not at both yet).

Best regards,