Russ & Wil Thanks I will be looking at that slideshow. On Fri, Aug 19, 2011 at 4:20 PM, Wil Genovese <[email protected]> wrote:
> > 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:346871 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
