Our setup is a Lucee cluster with a multi-AZ Aurora (MySQL) database. Whenever the Aurora cluster does a failover, which has occurred 3 times aver the last few months, our datasource connections go stale but do not fail/close. The result we see are Lucee requests timing out and our systems go unresponsive until we reboot the servers.
Our datasources use a “Connection timeout” of 1 minute and “Auto reconnect” set to true.
Does anyone have any tips for a successful strategy to reconnect stale database connections in this situation?
OS: Windows Server 2016
Java Version: 1.8
Tomcat Version: 8.5
Lucee Version: 5.2.5