[ILUG] Dual Master MySQL replication ?

[Nick Murtagh]

Paul Reilly wrote:
> However the official MySQL docs suggest dual master is a no-go.

Yeah I don't think it will work. There's nothing to stop the
servers clobbering each other's updates.

> Ideas?

Don't use MySQL's built in replication, build your own using something
like Spread (there's a replication implementation for PostgreSQL that
uses this). Think of it as RAID-1 with two MySQL servers :)  It's not a
small task though!

http://www.spread.org/


Nick