Peter Zaitsev wrote:
On Fri, 2006-08-04 at 15:54 -0400, Ed Pauley II 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.
As some people mentioned there is "Continuent" solution, this is what
was Emic networks previously.
If you're building solution on your own such as master and number of
slaves there are plenty of things to think, regarding load balancing,
for example if replication breaks for any reason of falls behind on one
of the slaves you might want to kick it up.
For very basic setup you even can use DNS for load balancing, which does
not solve many of the problems describe.
The same kind of simple load balancing is build in MySQL JDBC Driver.
In general everyone seems to implement something on their own, working
well for their application.
Continuent's m/cluster will not work for me as it does not allow
replication across a WAN. We have an offsite backup that needs to be in
the replication (2-way to make switching back and forth easy) chain. I
am thinking of a master, slave setup at each location where the masters
continue to replicate both ways and then each replicates to it's own
slaves. I would like to load balance these slaves on each end. I have
not been able to find an appliance that will balance the reads for me. I
have looked into possible solutions such as Sequoia, which I know would
require a different setup. Is anyone actually using Sequoia? Does anyone
use an appliance for load balancing MySQL? LVS seems like a good
possibility but I would rather have an out-of-box solution since I will
be repeating this setup at a remote location.
--
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]
