The master-master solution sounds actually pretty interesting, and its something i'd probably want to implement if it works well enough. Would there be huge contention issues? do you just create a vip and round robing between the masters?
That's pretty much what we're doing. Standard master/master MySQL with vrrp (keepalived) handling failover between the two machines. We could probably use two floating IPs and load balance if we needed to....but we haven't:)
--Justin
