1、vm下linux+keepalived+mysql以前的試驗做過用法手動的配置使兩臺mysql數(shù)據(jù)庫服務器可以數(shù)據(jù)同步，這個采納mysql-cluster簡化了配置的過程，并且很從容的可以擴容大量的節(jié)點，詳細mysql-cluster的介紹可以參見mysql的官方網(wǎng)站，這里不啰嗦。 ip規(guī)劃： ld1(器)：1 ld2：2 sql1：1 sql2：2 ndb1：1 ndb2：2 mgm：96 vip：00 試驗原理：兩臺

2、sql和兩臺ndb和兩臺ldf分離實現(xiàn)高可用，ld對sql的調(diào)度實現(xiàn)負載均衡。 第一：在兩臺ld（負載均衡器上的設置，兩者大致相同，故這里只設置其中一臺，并且標出需要修改的地方） rootlocalhost yum -y install ipvsadm kernel-devel openssl openssl-devel rootlocalhost -s /usr/src/kerne/2.6.18-194.el5-i686/ /usr/src/linux rootlocalhost wget /software/keepalived-1.2.1.ta

3、r.gz rootlocalhost ls keepalived-1.2.1.tar.gz keepalived-1.2.1.tar.gz rootlocalhost tar zxvf keepalived-1.2.1.tar.gz rootlocalhost keepalived-1.2.1 rootlocalhost keepalived-1.2.1 ./configure /結(jié)束后浮現(xiàn)以下的內(nèi)容表示可以編譯安裝了 keepalived configuration - keepalived version : 1.2.1 compiler : gcc compiler flags : -g

4、 -o2 -dethertype_ipv6=0x86 exa lib : -lpopt -lssl -lcrypto use ipvs framework : yes ipvs sy daemon pport : yes use vrrp framework : yes use debug flags : no rootlocalhost keepalived-1.2.1 make make install rootlocalhost /etc/keepalived rootlocalhost /usr/local/etc/keepalived/keepalived.conf /etc/kee

5、palived/keepalived.conf rootlocalhost cp /usr/local/etc/sysconfig/keepalived /etc/sysconfig/keepalived rootlocalhost cp /usr/local/sbin/keepalived /usr/sbin/keepalived rootlocalhost cp /usr/local/etc/rc.d/init.d/keepalived /etc/init.d/keepalived rootlocalhost vi /etc/keepalived/cc.conf ! configurati

6、on file for keepalived global_defs notifiion_email 38205036 notification_email_from alandre.cassenfire.loc smtp_server 96 smtp_connect_out 30 router_ lvs_devel vrrp_group vgm group v_mysql vrrp_instance v_mysql e master /備用節(jié)點上這里修改為backup interface eth0 lvs_sync_daemon_interface eth0 virtu

7、al_router_id 51 priority 100 /備用節(jié)點上這里修改為90 advert_int 5 authentication auth_typepass auth_pass 1111 virtual_ipaddress 00/24 dev eth0 virtual_server 00 3306 delay_loop 6 lb_algo rr lb_kind dr persistence_timeout 6 proto tcp real_server 1 3306 weight 100 tcp_check conn

8、ect_timeout 3 nb_get_retry 3 delay_before_retry 3 connect_port 3306 real_server 2 3306 weight 100 tcp_check connect_timeout 3 nb_get_retry 3 delay_before_retry 3 connect_port 3306 其次：在sql上的設置 兩個sql節(jié)點上都要運行一個腳本，并且兩個節(jié)點配置基本相同 rootlocalhost vi /etc/init.d/lvscdr /編寫arp及vip綁定腳本（兩節(jié)點徹低相同） !/bin/bash descrpption :start realserver dr vip=00 ./etc/rc.d/init.d/functions case $1 in start) echo start lvs of realserver dr /sbin/ lo:0 $vip