RE: How should I connect via DBD::Oracle to efficiently obtain 2000+ simultaneous connections?
- From: Philip.Garrett@xxxxxxxxxxx (Philip Garrett)
- Date: Thu, 16 Nov 2006 10:39:29 -0500
Chris Drake wrote:
I'm expanding, and adding extra web servers to handle my load. My
Apache/mod_perl environment maintains a new connection for each
process, and these processes seem to chew up a lot of server
resources.
What is the normal acceptable way to maintain large numbers of
simultaneous connections?
I have enabled "shared server" support in my database, but I suspect
it's not being utilized, since I only get a few hundred connections
before hitting the "too many connections" error.
Am I supposed to be passing a switch in with my initical "connection"
requests to request a shared (instead of dedicated) connection maybe
?
You'll want to read the Oracle Net Services Administrator's Guide.
http://www.lc.leidenuniv.nl/awcourse/oracle/network.920/a96580/mts.htm#4
53189
From a higher-level architectural viewpoint, you could use some loadbalancing. Look into SQLRelay. It provides out-of-process connection
pooling that can work for mod_perl servers.
http://sqlrelay.sourceforge.net/
Regards,
Philip
.
- Follow-Ups:
- Prev by Date: How should I connect via DBD::Oracle to efficiently obtain 2000+ simultaneous connections?
- Next by Date: RE: Creating XML from an Oracle DB
- Previous by thread: Re: How should I connect via DBD::Oracle to efficiently obtain 2000+ simultaneous connections?
- Next by thread: Re[2]: How should I connect via DBD::Oracle to efficiently obtain 2000+ simultaneous connections?
- Index(es):
Relevant Pages
|
|
