Ubuntu下LVS + Keepalived 實(shí)現(xiàn)MySQL高可用負(fù)載均衡實(shí)現(xiàn)

LVS Server   : 192.85.1.5
Virtual IP   : 192.85.1.10
Real Server1 : 192.85.1.4
Real Server2 : 192.85.1.9
在 LVS Server 上安裝 ipvsadm 和 keepalived。
$ sudo apt-get install ipvsadm keepalived
-
 

使用這兩個(gè)做配合時(shí)，無需配置 ipvsadm，直接修改 keepalived.conf 即可。
$ sudo vim /etc/keepalived/keepalived.conf

global_defs {
    router_id LVS_DEVEL
}

vrrp_instance VI_1 {
    state MASTER
    interface eth0
    virtual_router_id 51
    priority 100   #100為從服務(wù)器，主服務(wù)器為：101    
    advert_int 1       

    authentication {
        auth_type PASS
        auth_pass 1111
    }

    virtual_ipaddress {
        192.85.1.10
    }
}

virtual_server 192.85.1.10 3306{
    delay_loop 1        # 每隔 1 秒查詢 RealServer 狀態(tài)
    lb_algo wrr         # LVS 算法
    lb_kind DR          # Direct Route
    #persistence_timeout 60 # 同一 IP 在 60 秒內(nèi)分配到同一臺 RealServer
    protocol TCP        # 使用 TCP 協(xié)議檢查 RealServer 狀態(tài)

    real_server 192.85.1.4 3306{
        weight 3    # 權(quán)重
        TCP_CHECK {
            connect_timeout 10 # 10 秒無響應(yīng)超時(shí)
            nb_get_retry 3
            delay_before_retry 3
            connect_port 3306
        }
    }

    real_server 192.85.1.9 3306 {
        weight 3   
        TCP_CHECK {
            connect_timeout 10
            nb_get_retry 3
            delay_before_retry 3
            connect_port 3306
        }
    }
}}
啟動(dòng) keepalived 服務(wù)。$ sudo service keepalived start #應(yīng)該先啟動(dòng)mysql集群
 
檢查 ipvsadm 設(shè)置。
$ sudo ipvsadm -ln

IP Virtual Server version 1.2.1 (size=4096)
Prot LocalAddress:Port Scheduler Flags
  -> RemoteAddress:Port           Forward Weight ActiveConn InActConn
TCP  192.85.1.10:3306 wrr
  -> 192.85.1.4:3306           Route   3      0          0        
  -> 192.85.1.9:3306           Route   3      0          0
 
在所有 RealServer /etc/rc.local 中添加配置信息后重啟
$ sudo nano /etc/rc.local

#!/bin/sh -e
#
# rc.local
#
# This script is executed at the end of each multiuser runlevel.
# Make sure that the script will "exit 0" on success or any other
# value on error.
#
# In order to enable or disable this script just change the execution
# bits.
#
# By default this script does nothing.

ifconfig lo:0 192.85.1.10 netmask 255.255.255.255 broadcast 192.85.1.10 up
route add -host 192.85.1.10 dev lo:0

echo "0" > /proc/sys/net/ipv4/ip_forward
echo "1" > /proc/sys/net/ipv4/conf/lo/arp_ignore
echo "2" > /proc/sys/net/ipv4/conf/lo/arp_announce
echo "1" > /proc/sys/net/ipv4/conf/all/arp_ignore
echo "2" > /proc/sys/net/ipv4/conf/all/arp_announce

exit 0
 
這時(shí)我們就可以進(jìn)行測試了。在Real Server1 上，創(chuàng)建數(shù)據(jù)庫：clustertest,
sudo /usr/local/mysql/bin/mysql -u root -p
密碼默認(rèn)為空
mysql> GRANT ALL ON clustertest.* TO 'zichen'@'$' IDENTIFIED BY '62672000';
mysql> FLUSH PRIVILEGES;
mysql> CREATE DATABASE clustertest;
mysql> USE clustertest;
mysql> CREATE TABLE test(id INT) ENGINE=NDBCLUSTER;
mysql> INSERT INTO test VALUES(1);
mysql> quit;
在 Real Server2上
sudo /usr/local/mysql/bin/mysql -u root -p
密碼默認(rèn)為空
mysql> GRANT ALL ON clustertest.* TO 'zichen'@'$' IDENTIFIED BY '62672000';
mysql> FLUSH PRIVILEGES;
mysql> quit;
 
在192.85.1.4上，在終端輸入：sudo /usr/local/mysql/bin/mysql -h 192.85.1.10 -u zichen -p
enter password:62672000
正常情況下，應(yīng)該能進(jìn)入如下界面：mysql >
mysql > use clustertest;
mysql > show tables;
mysql > select * from test;
mysql > insert into test values (2);
在兩個(gè)SQL節(jié)點(diǎn)上查看數(shù)據(jù)是否同步。

服務(wù)器租用/服務(wù)器托管中國五強(qiáng)！虛擬主機(jī)域名注冊頂級提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]