Mallory, A while back one of the CFGURU's, Mike Brunt, did an excellent presentation at CF.Objective() 2009 called the Server of Doom. What he covered in the preso was performance and redundancy. His slide show is still on SlideSix http://slidesix.com/view/mbruntcfwhisperercfobjective09
The last section covers the database performance and a simple but effective failover setup. It involves user SQL Server express as a "witness server" to determine when failover is needed. Mike's blog is here http://www.cfwhisperer.com/post.cfm/cfobjective-powerepoint-on-coldfusion-and-database-performance Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com [email protected] www.trunkful.com On Aug 19, 2011, at 3:10 PM, Mallory Woods wrote: > > Greetings, > > My boss has asked me to come up with a plan of action in case one of our > databases is off line or if we loose connectivity to it. > In this setup we have one DB in one location and another one at a different > ISP. I think he wants a solution in which if its possible that CF would be > able to make the > change if some sort of situation were to occur and we can't reach site A. > > One thing that I thought of would be to run a simple query and if it times > out or we get a DB error then we would switch to the alternate DB. I have > just started thinking about this scenario and since > I have never been tasked with this type of challenge before I thought I > would ask. > > Thanks, > > Mallory Woods > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:346869 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
