Re: Re: Resource Request - MySQL Data Pool

2019-03-28 Thread Richard Huntrods
Chris, Thanks. Lots to go through... On 3/26/2019 9:00 AM, Christopher Schultz wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Richard, On 3/25/19 14:15, Richard Huntrods wrote: It's time to update my application to use "real" (i.e. current best practices) data connection pooling.

Re: Re: Resource Request - MySQL Data Pool

2019-03-28 Thread Richard Huntrods
Luis, Thanks very much. I'll have a look. Cheers, -Richard On 3/26/2019 1:43 AM, Luis Rodríguez Fernández wrote: Hello Richard, In my experience the best is to "start simple". I would have a look at the apache tomcat doc [1], configure your pool with a minimal setup and test. Everything

Re: Resource Request - MySQL Data Pool

2019-03-26 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Richard, On 3/25/19 14:15, Richard Huntrods wrote: > It's time to update my application to use "real" (i.e. > current best practices) data connection pooling. :) > My application is Java Servlets, no beans, no JSP. Database is > MySQL. > >

Re: Resource Request - MySQL Data Pool

2019-03-26 Thread Luis Rodríguez Fernández
Hello Richard, In my experience the best is to "start simple". I would have a look at the apache tomcat doc [1], configure your pool with a minimal setup and test. Everything depends on your application workload, how your queries looks like, etc, so I am afraid that there are no "silver bullets"

Resource Request - MySQL Data Pool

2019-03-25 Thread Richard Huntrods
It's time to update my application to use "real" (i.e. current best practices) data connection pooling. My application is Java Servlets, no beans, no JSP. Database is MySQL. System etc. details: Ubuntu live server 18.04.2, built March 6, 2019. MySQL - latest installed via 'apt-get install