Is it possible to do database connection pooling with mod_perl?
Currently, all of my source code has a my $dbh. Is it possible to have my
database stuff in a pool, and I just include it somehow?
TIA
Mag Gam wrote:
Is it possible to do database connection pooling with mod_perl?
Currently, all of my source code has a my $dbh. Is it possible to have
my database stuff in a pool, and I just include it somehow?
DBI::Pool is a partially complete module for doing this. Tim Bunce and
Stas Bekma
My information is not up to date -- I looked into this a year or so ago.
With the prefork MPM, connection pooling is a problem because of the way
the Apache process model works. With a threaded MPM, the situation is
different. I think the preferred approach (and I don't know how well it
work
On Nov 24, 2007 9:45 PM, Mag Gam <[EMAIL PROTECTED]> wrote:
> Is it possible to do database connection pooling with mod_perl?
There are options. Are you getting close to the maximum connection
your database can handle? You should be running a reverse proxy in
front of your mod_perl server, which
Perrin Harkins wrote:
If you have a reverse proxy, and still have too many connections, you
can look at either SQL Relay or the DBI::Gofer stuff in the latest DBI
releases. DBI::Gofer was created to solve the issue of too many
connections for Shopzilla.com.
DBD::Gofer looks like an excellent s