Any configuration to minimzie how long rlm_sql leaves connections open

[Coy Hile (BLOOMBERG/ 919 3RD A)]

Hi all,

We run into a bit of a strange edge case when our DBAs have to perform maintenance on a database cluster. Within a minute, the master has flipped, so new connections to the load-balancer name will get the new read-write replica.

However, when this happened last month, we aw it take about 8 minutes before we stopped seeing ERROR 1290, DG is readonly (paraphrased) in radiusd.log.

Is there anything in particular we can tweak in the SQL config to minimize that time between reconnections?

Thanks,
-Coy