文档介绍：How To Set Up A Load-Balanced MySQL Cluster
How To Set Up A Load-Balanced MySQL Cluster
Version
Author: Falko Timme <ft [at] falkotimme [dot] com>
Last edited 03/27/2006
This tutorial shows how to configure a MySQL 5 cluster with three nodes: two storage nodes and one
management node. This cluster is load-balanced by a high-availability load balancer that in fact has two
nodes that use the Ultra Monkey package that provides heartbeat (for checking if the other node is still
alive) and ldirectord (to split up the requests to the nodes of the MySQL cluster).
In this document I use Debian Sarge for all nodes. Therefore the setup might differ a bit for other
distributions. The MySQL version I use in this setup is . If you do not want to use MySQL 5, you
can use MySQL as well, although I haven't tested it.
This howto is meant as a practical guide; it does not cover the theoretical backgrounds. They are treated in
a lot of other documents in the web.
This es without warranty of any kind! I want to say that this is not the only way of setting
up such a system. There are many ways of achieving this goal but this is the way I take. I do not issue any
guarantee that this will work for you!
1 My Servers
I use the following Debian servers that are all in the work ( in this example):
sql1. : MySQL cluster node 1
sql2. : MySQL cluster node 2
loadb1. : Load Balancer 1 / MySQL cluster management server
loadb2. : Load Balancer 2
In addition to that we need a virtual IP address : . It will be assigned to the MySQL cluster
by the load balancer so that applications have a single IP address to access the cluster.
Although we want to have two MySQL cluster nodes in our MySQL cluster, we still need a third node, the
MySQL cluster management server, for mainly one reason: if one of the two MySQL cluster nodes fails,
and the managem