These days I'm all about letting someone else manage my data. That of course carries with it the questions of whether or not you can trust others with it ....
I'm looking at Amazon's RDS. If you set up multiple availability zones, it automatically replicates and fails over. No DNS changes needed. (Plus they handle backups, etc) I know the MySQL version offers this - not sure about the Oracle flavor. (No SQL Server however) I believe SQL Server Azure provides this functionality. Billy Cravens On Thu, Aug 25, 2011 at 9:57 PM, Al Musella, DPM <muse...@virtualtrials.com>wrote: > > Hi > I am getting a little worried about this hurricane.. we were just > told to evacuate on Saturday.. > I have my server in my office. The website runs a brain cancer > registry with pretty important database stuff. More valuable than money:) > > How would you approach setting up a redundant server across the > country so if my town gets wiped out, we still have access to the website? > The problem would be: > keeping the databases synched > DNS stuff: how to set up DNS so that if my main server goes down, > people are directed to the backup website and when the server is back > up, the dns reverts back to the main site? > > I use MS SQL server for the database. It is not a high volume of > transactions per day - but they are kind of important. > > thanks > Al > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347022 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
