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
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.
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
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
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
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
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.
>
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.
>>
>
>
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
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
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
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
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
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
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
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'
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
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
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
19 matches
Mail list logo