Re: ApacheCon: Getting the word out internally

On 07/19/2016 05:37 AM, James Smith wrote:
> 
> 
> 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.
>>

There is a ODBC driver under DBD if someone wanted to use it (for
whatever reason)

> 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!)
> 
> 
> 
> 


-- 
So many immigrant groups have swept through our town
that Brooklyn, like Atlantis, reaches mythological
proportions in the mind of the world - RI Safir 1998
http://www.mrbrklyn.com

DRM is THEFT - We are the STAKEHOLDERS - RI Safir 2002
http://www.nylxs.com - Leadership Development in Free Software
http://www2.mrbrklyn.com/resources - Unpublished Archive
http://www.coinhangout.com - coins!
http://www.brooklyn-living.com

Being so tracked is for FARM ANIMALS and and extermination camps,
but incompatible with living as a free human being. -RI Safir 2013