Think about Loose Coupling | |
PerlMonks |
DBI load balancing / high availability: DBIx::HA vs DBD::Multi vs DBD::Multiplexby andye (Curate) |
on Aug 22, 2012 at 17:34 UTC ( [id://989110]=perlquestion: print w/replies, xml ) | 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: Q1: Does anyone know of any other options?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.
Back to
Seekers of Perl Wisdom
|
|