Grouper Users - Open Discussion List

["Wessel, Keith" <>]

Hi, all,

 

We’re running a fairly vanilla Grouper installation at this point, with few changes from what the Grouper Installer did. One change is that we’re talking to a remote MySQL database server instead of HSQL.

 

I’ve noticed, the first time we connect to Grouper after a Tomcat restart or after a while of inactivity, things take a while to return – usually longer than the 15 second time-out we have configured in Apache mod_proxy. That means that the first page load usualy results in a 503 from Apache.

 

How would I go about configuring connection pooling and starting up some initial connections on Tomcat start as well as a validation check and occasional retirement/regeneration of db connections? Is there a way to interface something like Tomcat CP or HikariCP with Grouper, or should I just use the options available in the MySQL Connector JAR?

 

Thanks,

Keith