We're in a similar situation with 20-40 databases per server. We use
PGBouncer for connection pooling.

On Sun, Feb 7, 2021 at 2:23 PM James Smith <j...@sanger.ac.uk> wrote:

> DBI sharing doesn't really gain you much - and can actually lead you into
> a whole world of pain. It isn't actually worth turning it on at all.
>
> We use dedicated DB caching in the cases where we benefit from it as and
> when you need it (low level caching database)...
>
> Although milage may vary - our problem was DB servers with 30 or 40
> databases on them being connected from a number of approximately 50-100
> child apaches, meant we ended up blowing up the connections to the database
> server really quickly...
>
>
> -----Original Message-----
> From: Vincent Veyron <vv.li...@wanadoo.fr>
> Sent: 07 February 2021 19:06
> To: Steven Haigh <net...@crc.id.au>
> Cc: James Smith <j...@sanger.ac.uk>; modperl@perl.apache.org
> Subject: Re: Moving ExecCGI to mod_perl - performance and custom 'modules'
> [EXT]
>
> On Sun, 07 Feb 2021 23:58:17 +1100
> Steven Haigh <net...@crc.id.au> wrote:
> >
> > I haven't gotten into the preload or DBI sharing yet - as that'll end
> > up needing a bit of a rewrite of code to take advantage of. I'd be
> > open to suggestions here from those who have done it in the past to
> > save me going down some dead ends :D
>
> I use mod_perl handlers, so not sure how it mixes with PerlRegistry, but
> you probably want to have a look at connect_cached
>
>
> --
>
>                                         Bien à vous, Vincent Veyron
>
>
> https://urldefense.proofpoint.com/v2/url?u=https-3A__compta.libremen.com&d=DwIFAw&c=D7ByGjS34AllFgecYw0iC6Zq7qlm8uclZFI0SqQnqBo&r=oH2yp0ge1ecj4oDX0XM7vQ&m=C0OcuGbNbfxaSa8ASgV3uFXzejn7MpjIUH1aP1RbiyU&s=GPr8VuKQ3rZCzCPwggyAHdCOojK6ZThmShKk0Jb3maI&e=
> Logiciel libre de comptabilité générale en partie double
>
>
>
> --
>  The Wellcome Sanger Institute is operated by Genome Research
>  Limited, a charity registered in England with number 1021457 and a
>  company registered in England with number 2742969, whose registered
>  office is 215 Euston Road, London, NW1 2BE.
>


-- 
John Dunlap
*CTO | Lariat *

*Direct:*
*j...@lariat.co <j...@lariat.co>*

*Customer Service:*
877.268.6667
supp...@lariat.co

Reply via email to