Re: mysql connection pooling

2013-10-25 Thread Perrin Harkins
xinhuan > > From: Perrin Harkins > Date: Thursday, June 27, 2013 3:05 PM > To: xiaolan > Cc: "modperl@perl.apache.org" > Subject: Re: mysql connection pooling > > Hi, > > There is nothing exactly like the database pool in JDBC. However, there > are so

Re: mysql connection pooling

2013-10-24 Thread Xinhuan Zheng
; mailto:modperl@perl.apache.org>> Subject: Re: mysql connection pooling Hi, There is nothing exactly like the database pool in JDBC. However, there are solutions for this problem. The first thing you should do is run a reverse proxy in front of your mod_perl server. That typically reduce

Re: mysql connection pooling

2013-06-27 Thread xiaolan
Thank you Perrin. Yes I should use Nginx as a reverse-proxy for modperl appservers, but I don't yet. I will check it. Thanks. On Fri, Jun 28, 2013 at 3:05 AM, Perrin Harkins wrote: > Hi, > > There is nothing exactly like the database pool in JDBC. However, there > are solutions for this proble

Re: mysql connection pooling

2013-06-27 Thread Perrin Harkins
Hi, There is nothing exactly like the database pool in JDBC. However, there are solutions for this problem. The first thing you should do is run a reverse proxy in front of your mod_perl server. That typically reduces the number of mod_perl processes by a factor of 10, i.e. 1000 mod_perl proces

mysql connection pooling

2013-06-26 Thread xiaolan
Hi, Currently I have been using Apache::DBI for long connections to Mysql. But having the problem that, if the apache processes are 1, they open 1 connections to mysql, this make the DB crashed. Is there any software for modperl working like Java's JDBC for connection pooling? Thanks.