Linux MySQL集群与LVS实现apache负载均衡

先讲MySQL：
groupadd -g 40 &&
useradd -c "MySQL Server" -d /dev/null -g mysql -s /bin/false \
-u 40 mysql

CPPFLAGS="-D_GNU_SOURCE" ./configure --prefix=/usr/local/mysql --sysconfdir=/etc \
--localstatedir=/srv/mysql --with-unix-socket-path=/var/run/mysql/mysql.sock \
--enable-thread-safe-client \
--with-named-thread-libs=-lpthread \
--enable-local-infile --with-charset=ascii \
--with-extra-charsets=gb2312,gbk,utf8 --enable-assembler \
--with-ndbcluster --without-ndb-debug \
--without-debug --without-bench --without-readline
make && make install

ln -v -sf ../local/mysql/lib/mysql/libmysqlclient{,_r}.so* /usr/lib

install -v -m644 /usr/local/mysql/share/mysql/my-medium.cnf /etc/my.cnf

/usr/local/mysql/bin/mysql_install_db --user=mysql &&
chgrp -v mysql /srv/mysql{,/test,/mysql}
/usr/local/mysql/bin/mysqld_safe --user=mysql 2>&1 >/dev/null &

mkdir -p /data/cluster/{manager, ndb111,ndb112,ndb113}

管理机上设置如下：
cat > /data/cluster/manager/config.ini << EOF
[NDBD DEFAULT]
NoOfReplicas=3

[TCP DEFAULT]
PortNumber=2202

# Managment Server 管理机
[NDB_MGMD]
HostName=192.168.126.100

# Storage Engines 存贮服务器
[NDBD]
HostName=192.168.126.111
DataDir=/data/cluster/ndb111
[NDBD]
HostName=192.168.126.112
DataDir=/data/cluster/ndb112
[NDBD]
HostName=192.168.126.113
DataDir=/data/cluster/ndb113

# SQL node options: 检索服务器
[MYSQLD]
[MYSQLD]
[MYSQLD]
EOF

用下面的命令启动管理机服务
/usr/local/mysql/libexec/ndb_mgmd -f /data/cluster/manager/config.ini

其它各节点服务器设置
cat > /etc/my.cnf << EOF
[mysqld]
ndbcluster
ndb-connectstring=192.168.126.100
[mysql_cluster]
ndb-connectstring=192.168.126.100
EOF

启动初始化其它节点服务
/usr/local/mysql/libexec/ndbd --initial

注：只有第一次运行或者管理机改动了config.ini文件，要不只执行以下命令即可
/usr/local/mysql/libexec/ndbd

启动各节点mysqld服务
/usr/local/mysql/bin/mysqld_safe --user=mysql 2>&1 >/dev/null &

在管理机上运行
/usr/local/mysql/bin/ndb_mgm

LVS:有关内核配置待整理中。。。
director:
echo 1 > /proc/sys/net/ipv4/ip_forward
echo 1 > /proc/sys/net/ipv4/conf/all/send_redirects
echo 1 > /proc/sys/net/ipv4/conf/all/hidden
echo 1 > /proc/sys/net/ipv4/conf/default/send_redirects

ifconfig dummy up
ifconfig dummy0 up
ifconfig dummy0 192.168.126.121 netmask 255.255.255.255 broadcast 192.168.126.121
route add -host 192.168.126.121 dev dummy0

ipvsadm -C
ipvsadm -A -t 192.168.126.121:80 -s wlc
ipvsadm -a -t 192.168.126.121:80 -r 192.168.126.52 -g
ipvsadm -a -t 192.168.126.121:80 -r 192.168.126.11 -g


web节点:
ifconfig dummy up
ifconfig dummy0 up
ifconfig dummy0 192.168.126.121 netmask 255.255.255.255 broadcast 192.168.126.121
route add -host 192.168.126.121 dev dummy0
echo 1 > /proc/sys/net/ipv4/conf/dummy0/hidden