DBI load balancing / high availability: DBIx::HA vs DBD::Multi vs DBD::Multiplexby andye (Curate)
|on Aug 22, 2012 at 17:34 UTC||Need Help??|
andye has asked for the
wisdom of the Perl Monks concerning the following question:
Hi fellow monks,
I'm converting an existing web application to a cloud environment.
I need to do failover / load balancing for the MySQL database connection.
One option I'm looking at is doing that from within Perl. (I'm aware that there are other options such as HAProxy etc - they have their pros and cons).
So, Perl module options for load balancing with failover for non-responsive connections seem to be:
I'm aware that each of these modules is designed for a slightly different scenario, but in fact any of them would fit the bill for my scenario, which is:
I have no experience using any of the above modules; I've been using DBI in general for about 10 years.
The app is running on Apache2, mod_perl2, Apache::DBI.
So, Q2: Does anyone have any experience with any of the above modules which they'd be willing to share?
Thoughts or recommendations?
I see that Tim Bunce is involved with DBD::Multiplex, behind the scenes, and that that module is now on v2. Those things make me think happy thoughts about it. I don't know anything much at all about the maintenance of the other two modules (not to say that it's not great, it may be fantastic, just that I'm ill-informed on this).
Thank you, and Happy Wednesday.