Ed, in Jeremy Zawodny's (excellent) book "High Performance MySQL", there is a chapter on load balancing - though it's a bit more of a theoretical discussion than a how-to.
There are a couple of commercial products mentioned briefly - Veritas and EMIC Networks. One idea he presents might work for you, since you're already doing HTTP load balancing: have each HTTP server talk to a mysql instance on localhost, with the mysql instance configured as a replication slave. Depends on your situation but that could be elegantly simple - assuming you have a farm of servers, you just add mysql to your standard build image, rebuild them and start replicating. Roll out your app talking to localhost and you've got it. Of course rarely are things read-only; for something that writes as well as reads, you'll likely have to do some re-coding so that db writes go to the master and reads go to localhost. Then you have possible problems if you need reads to show the results of writes right away. It gets fun! Sound like this might work for you? Dan On 8/4/06, Ed Pauley II <[EMAIL PROTECTED]> wrote:
I am looking into a scale-out solution for MySQL. I have read white papers and searched the web but I can't find a load balancer that claims to work well for MySQL. MySQL's white paper shows NetScaler in the scale-out stack but nothing on Citrix.com mentions MySQL. I also read that friendster wrote a custom script for NetScaler to work in a MySQL environment. I would rather not have to do that. Is there an out-of-box solution for load balancing MySQL. My understanding is that MySQL is a little more complicated than HTTP load balancing, which we already do with Coyote Point Equalizers. I have thought about LVS. Has anyone had any experience with load balancing MySQL? Any recommendations? Thanks in advance. -Ed -- Ed Pauley II [EMAIL PROTECTED] http://www.brisnet.com http://www.brisbet.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
