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
