[mp2] Using DBI instead of Apache::DBI

[Georg Botorog]

 Hello,
 
 In mod_perl1, using persistent (Apache::DBI) and dedicated, per-user
 connections (DBI) on the same machine required running two Apache
 instances, one with Apache::DBI and the other without it.
 
 Has anything about that changed in mod_perl2?
 
 Moreover, how does Apache2 know it has to load Apache::DBI? There is
 no PerlModule Apache::DBI statement in my httpd.conf (as it was
 under mp1), neither a use Apache::DBI in startup.pl or in any other
 module. Or, to put it the other way around: how can I avoid including
 Apache::DBI (in the DBI-only instance)?
 
 Thanks
 George
 

RE: Connection pool with Apache::DBI and Oracle

[Georg Botorog]

I don't understand. The Apache server I am using has 50 ThreadsPerChild
(default in httpd.conf). Thus, Apache is able to handle quite a few
requests simultaneously. However, Oracle has only one session for the
job. As a consequence, starting two identical requests from distinct
clients leads to blocking the second request until the first one is
served. Now, to my modest understanding, this is bottleneck.

But maybe I'm doing something wrong here. Or perhaps I have
misunderstood something.



 -Original Message-
 From: Perrin Harkins [SMTP:[EMAIL PROTECTED]]
 Sent: Friday, January 24, 2003 7:30 PM
 To:   Georg Botorog
 Cc:   [EMAIL PROTECTED]
 Subject:  Re: Connection pool with Apache::DBI and Oracle
 
 Georg Botorog wrote:
  More precisely, I am using Apache::DBI to create and cache the
  connection to the DB. As this connection uses a single Oracle
 session,
  it is obvious that it becomes a bottleneck.
 
 Apache::DBI uses one connection per process.  There is no bottleneck 
 there.  Each process only handles one request at a time so it would
 have 
 no use for more than one database connection.
 
   Ideally, one would have a pool of DB
  sessions (= DB handles) that the Apache threads would use in serving
 the
  requests coming from clients.
 
 That's only ideal if your code spends a lot of time doing things that 
 don't involve a database.  You shgould be running with a reverse proxy
 
 in front, so that mod_perl processed will not be serving static files.
 
  Alternatively, is it possible to convince several Apache servers
 running
  concurrently to cooperate (i.e., load balance) in answering incoming
  requests? If yes, how?
 
 Any load-balancer will do that.  There are dozens, both commercial and
 
 open source.  See the mod_perl documentation for a list you can start
 with.
 
 - Perrin
 

Connection pool with Apache::DBI and Oracle

[Georg Botorog]

Hi,

I would like to know if there is a module that implements a pool of
connections to an Oracle database.

More precisely, I am using Apache::DBI to create and cache the
connection to the DB. As this connection uses a single Oracle session,
it is obvious that it becomes a bottleneck. On the other hand, opening
and closing a connection for each request (i.e., using DBI instead of
Apache::DBI) is not acceptable. Ideally, one would have a pool of DB
sessions (= DB handles) that the Apache threads would use in serving the
requests coming from clients. Was such functionality implemented?

Alternatively, is it possible to convince several Apache servers running
concurrently to cooperate (i.e., load balance) in answering incoming
requests? If yes, how?

Thanks,
George