Re: ApacheCon: Getting the word out internally

how about this module for connection caching?
http://search.cpan.org/~timb/DBI-1.636/lib/DBD/Gofer.pm

thanks

On 2016/7/19 17:37, 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.
>>
> 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!)
>
>
>
>