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
