Re: ApacheCon: Getting the word out internally

On 7/19/2016 9:58 AM, [email protected] wrote:
> Jie,
>
> I have been using Apache::DBI, but I don't think it is something like 
> JDBC.
>
Thankfully not - JDBC is one of the biggest nightmares our DBAs face - 
if we have
network issues (firewall session timeout e.g.) we have had all sorts of 
problems with
oracle jdbc connections.

We actually don't even use Apache::DBI (we are primarily MySQL) as the 
"uncontrolled"
caching of connections can lead to problems - flooding database servers 
with open
connections, connections failing because of firewall issues. We 
explicitly cache (and
reconnect) using DBIx::Connector to cope with the few databases we 
explicitly want
vast connections...

Admitedly many of our servers have upward of 30-40 apps on them, talking 
to 40-50
different databases (quite often on the same server!)




-- 
 The Wellcome Trust 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.