i want to create this scenario (or other recommended solution)
I want to have 3 running instances on amazon EC2 (3 different servers)
- database (MySQL)
- my web application (uses instance 1 as its db)
- mirror application of 2 (also uses instance 1 as its db)
I want that a user that goes to my domain http://www.xxx.com will go to instance 2 as default action.
In case server 2 is down or overloaded it will automatically redirect to the mirror application (3)
how can i achieve such functionality ?