mysql+keepalived+haproxy配置（负载均衡）

实验系统：CentOS 6.5_x86_64

实验前提：防火墙和selinux都关闭

实验软件：keepalived-1.2.13　　haproxy-1.8.13　　mysql—5.7.21

主1 ip：192.168.226.134

主2 ip：192.168.226.135

vip     192.168.226.150

一、安装mysql

获取mysql安装包：wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz

安装mysql过程省略

二、配置mysql复制

命令  service iptables stop 

检查：service iptables status

关闭vi /etc/selinux/config 

SELINUX=disabled

两台服务器上都要执行：

创建复制用户

grant replication slave on *.* to 'repl'@'%' identified by '123';

进入从服务器mysql

命令： # mysql -uroot -p

关闭slave

命令：stop slave;

开始配置：

输入下面代码即可：

CHANGE MASTER TO MASTER_HOST='192.168.226.135', MASTER_USER='repl', MASTER_PASSWORD='123', MASTER_LOG_FILE='mysql-bin.000002', MASTER_LOG_POS=681;

先在从服务器配置完成，启动从服务器：

命令： start slave;

反向再配置一次

三、安装haproxy（两台节点都要安装）

tar -zxvxf haproxy-1.8.13.tar.gz 

cd haproxy-1.8.13

make TARGET=linux2628       //根据自己主机设定

make install 

提供启动脚本

vi /etc/init.d/haproxy

#!/bin/sh

#

# haproxy

#

# chkconfig:   - 85 15

# description:  HAProxy is a free, very fast and reliable solution \

#               offering high availability, load balancing, and \

#               proxying for TCP and  HTTP-based applications

# processname: haproxy

# config:      /etc/haproxy/haproxy.cfg

# pidfile:     /var/run/haproxy.pid

# Source function library.

. /etc/rc.d/init.d/functions

# Source networking configuration.

. /etc/sysconfig/network

# Check that networking is up.

[ "$NETWORKING" = "no" ] && exit 0

exec="/usr/local/sbin/haproxy"

prog=$(basename $exec)

[ -e /etc/sysconfig/$prog ] && . /etc/sysconfig/$prog

cfgfile=/etc/haproxy/haproxy.cfg

pidfile=/var/run/haproxy.pid

lockfile=/var/lock/subsys/haproxy

check() {

    $exec -c -V -f $cfgfile $OPTIONS

}

start() {

    $exec -c -q -f $cfgfile $OPTIONS

    if [ $? -ne 0 ]; then

        echo "Errors in configuration file, check with $prog check."

        return 1

    fi

    echo -n $"Starting $prog: "

    # start it up here, usually something like "daemon $exec"

    daemon $exec -D -f $cfgfile -p $pidfile $OPTIONS

    retval=$?

    echo

    [ $retval -eq 0 ] && touch $lockfile

    return $retval

}

stop() {

    echo -n $"Stopping $prog: "

    # stop it here, often "killproc $prog"

    killproc $prog

    retval=$?

    echo

    [ $retval -eq 0 ] && rm -f $lockfile

    return $retval

}

restart() {

    $exec -c -q -f $cfgfile $OPTIONS

    if [ $? -ne 0 ]; then

        echo "Errors in configuration file, check with $prog check."

        return 1

    fi

    stop

    start

}

reload() {

    $exec -c -q -f $cfgfile $OPTIONS

    if [ $? -ne 0 ]; then

        echo "Errors in configuration file, check with $prog check."

        return 1

    fi

    echo -n $"Reloading $prog: "

    $exec -D -f $cfgfile -p $pidfile $OPTIONS -sf $(cat $pidfile)

    retval=$?

    echo

    return $retval

}

force_reload() {

    restart

}

fdr_status() {

    status $prog

}

case "$1" in

    start|stop|restart|reload)

        $1

        ;;

    force-reload)

        force_reload

        ;;

    check)

        check

        ;;

    status)

        fdr_status

        ;;

    condrestart|try-restart)

        [ ! -f $lockfile ] || restart

        ;;

    *)

        echo $"Usage: $0 {start|stop|status|restart|try-restart|reload|force-reload}"

        exit 2

esac

chkconfig --add haproxy

chkconfig haproxy on

chmod +x /etc/init.d/haproxy

提供配置文件

mkdir /etc/haproxy

mkdir /var/lib/haproxy

useradd -r haproxy

vi /etc/haproxy/haproxy.cfg

global

    log         127.0.0.1 local2

    chroot      /var/lib/haproxy

    pidfile     /var/run/haproxy.pid

    maxconn     4000

    user        haproxy

    group       haproxy

    daemon

    stats socket /var/lib/haproxy/stats

defaults

    mode                    tcp            

    log                     global

    option                  dontlognull

    option                  redispatch

    retries                 3

    timeout http-request    10s

    timeout queue           1m

    timeout connect         10s

    timeout client          1m

    timeout server          1m

    timeout http-keep-alive 10s

    timeout check           10s

    maxconn                 600           

listen stats                              

    mode http

    bind :6677                            

    stats enable

    stats hide-version                    

    stats uri     /haproxyadmin?stats     

    stats realm   Haproxy\ Statistics     

    stats auth    admin:admin             

    stats admin if TRUE                  

frontend  main 

    bind *:80                     

    default_backend             mysql       

backend mysql

    balance     leastconn                 

    server m1 192.168.226.134:80 check port 80 maxconn 300

    server m2 192.168.226.135:80 check port 80 maxconn 300

启动日志：

vi /etc/rsyslog.conf 

# Provides UDP syslog reception                

$ModLoad imudp

$UDPServerRun 514

local2.*             /var/log/haproxy.log      

service rsyslog restart

启动测试haproxy：

service haproxy start

netstat -tnlp

四、安装keepalived （两台服务器都要执行）

yum install -y keepalived

chkconfig --add keepalived

chkconfig keepalived on

mv /etc/keepalived/keepalived.conf /etc/keepalived/keepalived.conf.bak

vi /etc/keepalived/keepalived.conf

! Configuration File for keepalived

global_defs {

   router_id Mysql_ha

}

vrrp_script chk_mysql {

   script "/etc/keepalived/check_mysql.sh"

   interval 2

   weight 5

}

vrrp_script chk_haproxy {

   script "/etc/keepalived/chk.sh"

   interval 2

   weight 5

}

vrrp_instance mysql-instance {

   state MASTER   #另一台为BACKUP

   interface enp4s0  #与网卡名称对应

   virtual_router_id 11 #每一个IP唯一，另一台绑定相同IP要与整个ID一致

   priority 10   #另一台为9

   advert_int 1

   authentication {

        auth_type PASS

        auth_pass password321

   }

   track_script {

       chk_mysql

   }

   virtual_ipaddress {

   192.168.226.150/24

   }

}

vrrp_instance mysql-ha {

   state MASTER

   interface enp4s0

   virtual_router_id 13

   priority 10

advert_int 1

   # nopreempt

   authentication {

        auth_type PASS

        auth_pass password321

   }

   track_script {

       chk_haproxy

   }

   virtual_ipaddress {

   192.168.226.14/24

   }

    notify_backup "/etc/init.d/haproxy restart"

    notify_fault "/etc/init.d/haproxy stop"

}

五、在两台机器上测试

在浏览器打开http://192.168.226.150:6677/haproxyadmin?stats，打开haproxy状态页：