Quartiz.com is hosted on a Linux server based in Pennsylvania, USA and from time to time, the server needs to be upgraded and rebooted for maintenance. Mostly admins do this during the wee hours, but our company has offices and clients in six different countries across many time zones and we experience downtime during business hours and we cannot afford to have even have a few minutes of downtime. Is there a way to split the DNS settings (I know there can be more than one server names and priority) such a way that if one of the server goes down, another one’s DNS setting is being picked up automatically! To make matters worse, there is an interactive quote form for potential prospects to contact us via Quartiz.com and we store this data in a table on this web server. If we failover to a different server, how could I sync the databases? Has someone resolved such a case successfully? We have our own data centers for running our clients’ applications with redundancy set up, but bringing our own site and prospect response emails to own data center is a security and management issue, without having to separate client sites and ours.
Really really really appreciate a DNS setting based solution (based on server priority) on this one, even if we have to manually sync databases after failover.