adding redundancy
helloI've 2 servers and an account that uses MySQL on 1 server
Can anyone please give suggestions (or tutorials) about adding redundancy to this domain?
The site doesn't have very important DBs (ie, I can restore it from logs that I get on E-Mail on each change... it's fast to do it for the last 24 hours for example)
My idea:
1) set the domain on DNS of server1 and server2 to point to one of the servers (for example, server1)
2) set the domains nameservers as server1 and server2
3) set server1 to compress the account folder and DB each 24 hours and send it to server2, that will decompress
in case of problems, I'd manually (or set a script to check and do this) change both DNS to point to server2
anyone know a better solution for this?