[Building Sakai] Database connection pooling in Sakai

[Sam Ottenhoff]

Hi K.R.N.,

Sakai 2.9.1 is very old software.  Test with the latest code from Sakai's
GitHub repository.  It includes easy switching from DBCP to TomcatCP to
HikariCP.  Note that connection pools do validation in different ways.
Comparing performance tests without taking into account validation
strategies will produce bad results.

  https://github.com/brettwooldridge/HikariCP/wiki/FAQ

To change the pool, you modify the
$TOMCAT_HOME/sakai/sakai-configuration.xml file like this:

  https://gist.github.com/ottenhoff/7f7781e966b44aa47806

--Sam


On Thu, Apr 2, 2015 at 5:25 AM, GSA SMIT <smit.gsa at gmail.com> wrote:

> Hello all,
>
> My name is Kashyap, and I'm interning at a software dev. company in India.
> I am new to the Sakai platform and in need some of help.
>
> I have been assigned the task of testing and analysis of various
> connections pools in Sakai such as tomcatcp, dbcp, c3p0, vibur, bonecp and
> hikaricp.
>
> I have searched the internet and have found a lot of information and data
> about the above mentioned. Now I want help in deploying them into my rSmart
> Sakai 2.9.1 .
>
> I want to know if you can tell me on how to use one of them in Sakai so
> that I can learn and go on with the others. I would like to get an
> elaborate guide on this.
>
> I was told to test their performance using JMeter and JDBmonitor. Are
> there any better tools?
>
> I am in need. Thanking you in prior.
>
> K.R.N Kashyap
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20150402/c006ff12/attachment.html