Some other folks may be interested in the patches I've published for
DBD::Multi recently:

http://rt.cpan.org/Public/Dist/Display.html?Name=DBD-Multi

Perhaps most interesting might be a benchmarking script I made, and
related optimization patches:

http://rt.cpan.org/Ticket/Display.html?id=24460

Unfortunately, my benchmarks found the raw overhead of DBD::Multi be
significant. My patches reduced the overhead from 212% to 187%...

I suspect the overhead is much, much lower in a real-world scenario, but
I still get the sense there is further room for improvement.

Do people have other solutions for load-balancing and failover that they
recommend, at least for read-only access?

Today I ran across

ResourcePool
http://search.cpan.org/dist/ResourcePool/

and

SQL-Relay
http://sqlrelay.sourceforge.net/

But I find few references to people actually using these tools. I'm also
trying to weigh if my efforts to boost performance might be better spent
on a caching solutions, including memcached, or some form of HTTP-level
caching...

Thanks for your feedback!

    Mark

Reply via email to