Need:

Failover

Suggestions:

Consider: Live Backups of MySQL using Replication