Datasource auto reconnect

We had an incident last night where our AWS RDS instance failed over from one zone to another, which resulted in our Lucee servers becoming unresponsive. There were a whole pile of Timeout and InterruptedException errors in the logs on each server. Restarting Lucee solved the issue, but we’re looking for a more streamlined solution.

It seems that the “Auto reconnect” setting on each of our Datasources might do the job, but the warning in the Administrator recommends against it, suggesting the application should “handle SQLExceptions resulting from dead and stale connections”. A Google search didn’t turn up anything useful on the topic and I thought someone might be able to fill us in on what we might need to understand (and/or do) to avoid a repeat of the unresponsive servers scenario.