cfcatch DB connection failure - for failover

2011-07-05 Thread Sebastian Powell
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 t

Re: cfcatch DB connection failure - for failover

2011-07-06 Thread eric.da...@vmmc.org eric.da...@vmmc.org
I was able to get the following code to run sucessfully. I took the database offline so CF couldn't connect to it. As a second test, I also changed the server name to an invalid on in the datasource setup, and both scenarios worked. Select * from testdb Select * from