Re: Connection Pooling

2007-11-24 Thread Colin Wetherbee
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

Re: Connection Pooling

2007-11-24 Thread Perrin Harkins
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

Re: Connection Pooling

2007-11-24 Thread David Scott
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

Re: Connection Pooling

2007-11-24 Thread Colin Wetherbee
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

Re: Connection pooling in Apache2

2005-12-03 Thread Perrin Harkins
On Sat, 2005-12-03 at 19:32 +1100, Adam Kennedy wrote: > If mod_dbd is just providing the connection pooling, would it be > possible to write a mod_perl2 adapter/subclass/driver to let DBI pull > it's connections out of that pool? I think that's a question for someone who is deeply familiar with

Re: Connection pooling in Apache2

2005-12-03 Thread Adam Kennedy
Would that necesarily be the case? If mod_dbd is just providing the connection pooling, would it be possible to write a mod_perl2 adapter/subclass/driver to let DBI pull it's connections out of that pool? Adam K Perrin Harkins wrote: On Fri, 2005-12-02 at 19:34 +0100, Tom Schindl wrote: j

Re: Connection pooling in Apache2

2005-12-03 Thread Philip M. Gollucci
Perrin Harkins wrote: On Fri, 2005-12-02 at 19:34 +0100, Tom Schindl wrote: just because I came across it are there any plans to use mod_dbd-connection of Apache-2.2? Never heard of this before, but it looks like a replacement for DBI, so you'd probably have to rewrite all of your DBI code to

Re: Connection pooling in Apache2

2005-12-02 Thread Perrin Harkins
On Fri, 2005-12-02 at 19:34 +0100, Tom Schindl wrote: > just because I came across it are there any plans to use > mod_dbd-connection of Apache-2.2? Never heard of this before, but it looks like a replacement for DBI, so you'd probably have to rewrite all of your DBI code to use it. - Perrin