> Note that I run RDS in multi-AZ mode which means that when the database shuts > down for any reason it fails > over to another instance with identical credentials. However it appears CF > was never able to reconnect, not even > when the original DB came back a few mins later. Moreover not only did the DB > connection fail, but CF also stopped > processing HTTP requests - no pages (even those without cfquery tags) would > load (well they may have done, but > see below for how long they suddenly take to process).
I think the problem here is with connection pooling. If you have open connections, and the database is no longer responding, those pooled connections are basically dead - even though you have another database with an identical connection string that can respond. The easy way to solve this is to simply disable connection pooling for these connections. You can do this in the data source settings in CF Administrator. The problem with doing this is that creating and destroying database connections on an as-needed basis is quite expensive. Alternatively, you need to disable database connections when the problem occurs, then reenable them, for the data source in question. This should be scriptable without too much effort. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:353239 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
