Hi a bit stuck at the moment, I am trying to implement a DB fail over to a slave database through CF 9. I am using MYSQL as a DB. I have setup datasource in the application.cfc to point to the main db. When i trigger a stop service on the main db - which causes a failed db connection, i'm trying to get CF to change the datasource to the failover database. All that happens is the site keeps trying to connect to the main db without updating the db datasource in the cfcatch. Note: this code below works if i have a syntax error in the query, but not for a DB connection failure.
See my code below, which i am putting in the onRequestStart and i have unchecked "Maintain Connections" in the datasource settings. <cftry> <!--- Test whether the DB this application uses is accessible by getting some data. ---> <cfquery name="testDB" dataSource="#application.primary_datasource#" maxrows="2"> SELECT id FROM user </cfquery> <cfcatch type="database"> <cfset application.primary_datasource = "failoverdb"> </cfcatch> </cftry> I welcome any thoughts and assistance thanks in advance. Bas. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:346072 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm