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 depe

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. > > Syste

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"