Re: mysql connection pooling

2013-10-25 Thread Perrin Harkins
, June 27, 2013 3:05 PM To: xiaolan practicalp...@gmail.com Cc: modperl@perl.apache.org 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

Re: mysql connection pooling

2013-10-24 Thread Xinhuan Zheng
@perl.apache.orgmailto: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

mysql connection pooling

2013-06-27 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.

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

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 phark...@gmail.com wrote: Hi, There is nothing exactly like the database pool in JDBC. However, there are solutions