How can I use connection pooling in perl using MySQL?

Question

We have a Perl application that is using DBI to connect to MySQL and execute SQL statements. It creates multi connections, so I want to handle this using connection pooling and I have no idea about connection pooling.

How do I do this?

score 1 · Answer 1 · answered Jul 28 '16 at 10:20

1

If there are multiple connections to the same database with the same DSN inside one process, you can simply replace all calls to DBI->connect with DBI->connect_cached and the DBI will take care of reusing connections. That's not pooling, but it should work.

answered Jul 28 '16 at 10:20

simbabque

53,749
8
73
136

Thanks simbabque, Is that possible 'connection pooling' in DBI or not? – Rakesh Jul 28 '16 at 11:00
I don't know. That's why I answered an alternative. – simbabque Jul 28 '16 at 11:02

How can I use connection pooling in perl using MySQL?

1 Answers1