I have a CENTOS server running a PHP, Apache and MySQL site. I want to create a second server that can do the following:
- Keep the databases between server 1 and server 2 synched (preferably in realtime as transactions happen).
- Can be set at a domain level (or some other way) to switch to the second server should anything break on Server 1?
- Avoid the use of a 3rd Load Balancing server?
The reason why I don't want the third load balancer, is because I don't want to be in a situation where the load balancer itself goes down. I want to only rely on the actually working solution servers.
Is this possible and what is the easiest way?
My biggest concern is that this can't be done on a DNS level due to propogation, so I do think there might have to be some kind of 3rd intermediary that determines where the traffic goes?