External load balancer solutions between EC2 and Rackspace
We use dnsmadeeasy for exact same thing. DNS monitoring and failover would help you with this. For mysql, you can setup 2 way or one way replication; two-way replication is better as you don't have to worry about replicating data back when you switch back. And everything can be completely automated failrly easily.