simple DNS redundency, and mysql suggestions
Hello,Before putting this into place I wanted to see if im overlooking anything. Heres the plan.
I want to have some web server redundancy in 3 different datacenters in US. NJ, NY and Chicago.
When any machine in any of these places has a problem/ knocked offline I want the others to kick in.
Each machine will host DNS and webserver of the identical sites.
ns1.light-speed.com - Chicago
ns2.light-speed.com - NY
ns3.light-speed.com - NJ
the zone files will have identical serials
the zone file for each DNS server will point to itself. Because after all if the DNS box responds the apache on that same server should as well.
The only problem I have is the mysql server. For example if mysql is on ns1, when ns1 is knocked offline, the others wont have a database.
of course we could send a dump to the ns2 and ns3. but for real time redundency what should I do?
Do you think this type of idea will work?
Thanks!
Ben