Connection Pooling

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

mysql connection pooling

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: Connection Pooling

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

Re: Connection Pooling

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 we

Re: Connection Pooling

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_pe

Re: Connection Pooling

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: mysql connection pooling

t; 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

processes are 1, they open >> 10000 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

Hi Perrin, I am facing a similar issue with Oracle database. Tim's slides doesn’t explain details of implementation. I have Apache httpd with mod_perl and DBI. Without many code changes, what does the proxy server look like to achieve the database connection pooling? What is "Apac

Re: mysql connection pooling

Hi, Are you already using a reverse proxy in front of mod_perl? That should be your first step, and solves this for most people. The next thing I'd recommend is looking at Oracle's connection pooling solutions. I haven't used Oracle recently, but I remember that they had mult

Connection pooling in Apache2

Hi, just because I came across it are there any plans to use mod_dbd-connection of Apache-2.2? http://httpd.apache.org/docs/2.1/mod/mod_dbd.html Tom signature.asc Description: OpenPGP digital signature

Re: Connection pooling in Apache2

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

Re: Connection pooling in Apache2

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

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

Re: Connection pooling in Apache2

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

mod_perl 2 and DBI connection pooling

What is the status of DBI connection pooling (a la Apache::DBI) in mod_perl 2? The 2.0 guide says, "a replacement for Apache::DBI based on the tipool will allow to reuse database connections between multiple threads of the same process." "will allow"? Does that mean it'

Re: mod_perl 2 and DBI connection pooling

John Siracusa wrote: What is the status of DBI connection pooling (a la Apache::DBI) in mod_perl 2? The 2.0 guide says, "a replacement for Apache::DBI based on the tipool will allow to reuse database connections between multiple threads of the same process." "will allow"? Doe

MP2: Second easy question: DB connection pooling

I've seen conflicting information in docs, websites, lists archives, etc. Is there currently a way to do database connection pooling with mod_perl2? I have tried using Apache::DBI with a use statement in my startup.pl but that doesn't seem to work. Using PerlModule Apache::DBI in my

Re: MP2: Second easy question: DB connection pooling

On Thu, 2004-08-12 at 14:05, Tim Howell wrote: > Is there currently a way to do database connection pooling with > mod_perl2? No. > I have tried using Apache::DBI with a use statement in my > startup.pl but that doesn't seem to work. It should. Make sure it comes before anyth