Grouper Users - Open Discussion List

["Hyzer, Chris" <>]

I would bump that timeout up J (whether or not startup takes a while… you don’t want a request failing because of timeout… make it 60 seconds at least).  Also in your tomcat start script maybe you could prime the pump by hitting the servlet?  I think if I made a patch that implemented the init() method on the servlet and started grouper it would get grouper ready to go automatically, do you want that?  Btw, I don’t think changing pooling would help, need hibernate to init and classes to load, that’s the bottleneck I think

 

Thanks

Chris

 

From: [mailto:] On Behalf Of Wessel, Keith
Sent: Monday, October 03, 2016 4:35 PM
To:
Subject: [grouper-users] Connection pooling to reduce first load time after Tomcat start

 

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