Is there any product that make mysql master/slave failover process easier? something that can happen automatically, rather than manually fix it.
A:
The actual failover bit can be managed with heartbeat (part of the Linux HA project; http://linux-ha.org/), and I'm told that there's some tools in the MySQL Enterprise grab bag that helps with managing replication, although I've never used it myself.
womble
2009-02-11 05:14:17