You can use something like heartbeat for the failover. It basicly works by having slaves ping the master server, if the master doesn't respond it then assumes the ip of the master until it responds again. You would need to setup some type of central storage for this to work correctly since it sounds like your sites serve dynamic content.
|