I presume you already have the database clustering sorted and just want to handle the CF DSN side of things ? The easy way to do this is to have 2 DSN's, one pointing to each server. In your OnRequest method simply check the database connection, if it fails, switch to the other DSN.
Russ On Fri, Aug 19, 2011 at 9:10 PM, Mallory Woods <mallory.wo...@gmail.com>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:346868 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm