keepalived+双主架构部署

http://www.cnblogs.com/hmwh/p/9011377.HTML

https://www.cnblogs.com/hmwh/p/9011377.HTML

创建主从复制账号

create user 'rep'@'172.16.20.%' IDentifIEd by 'MysqL';

grant replication slave on *.* to 'rep'@'172.16.20.%';

show grants for 'rep'@'172.16.20.%';

flush privileges;

所有主机创建管理账号：

create user 'zs'@'172.16.20.%' IDentifIEd by '123456';

grant all privileges on *.* to 'zs'@'172.16.20.%';

flush privileges;

配置主从复制：

change master to master_host='172.16.20.32',master_port=3307,master_user='rep',master_password='MysqL',master_auto_position=1;

star slave;

show slave status\G;

无问题后再在主库配置复制关系：

change master to master_host='172.16.20.34',master_auto_position=1;

start salve;

show slave status\G;

由于我的没有keepalived包

yum install keepalived

 下载地址：

href="http://rpmfind.net/linux/rpm2HTML/search.PHP?query=keepalived&submit=%E6%90%9C%E7%B4%A2...+&system=&arch">http://rpmfind.net/linux/rpm2HTML/search.PHP?query=keepalived&submit=%E6%90%9C%E7%B4%A2...+&system=&arch=

rpm -ivh keepalived-1.2.13-5.el6_6.x86_64.rpm

两台服务器都配置检测脚本：内容根据情况自行修改

cd /etc/keepalived/

vim checkMysqL.sh

内容如下：

#!/bin/bash

MysqLstr=/usr/local/MysqL5.7/bin/MysqL

host=172.16.2.32

user=zs

password=123456

port=3307

#####MysqL service machine status health is 1,others 0

MysqL_status=1

#####check MysqL status#########

$MysqLstr -h $host -u $user -p$password -P $port -e "show status;" > /dev/null 2>&1

    if [ $? = 0 ];then

         echo "MysqL_status=1"

        exit 0

    else

/etc/init.d/keepalived stop

fi

chmod 775 checkMysqL.sh

主库的：

vim keepalived.conf

vrrp_script vs_MysqL_100 {

     script "/etc/keepalived/checkMysqL.sh"

     interval 10

}

vrrp_instance VI_100 {

    state BACKUP

    nopreempt

    interface eth0

    virtual_router_ID 100

    priority 100     --注意，30的为100,34的为90。

    advert_int 5

    authentication {

        auth_type PASS

        auth_pass 1314

    }

track_script {

    vs_MysqL_100

}

 virtual_ipaddress {

        172.16.20.30

    }

}

备库的：

vim keepalived.conf

vrrp_script vs_MysqL_101 {

     script "/etc/keepalived/checkMysqL.sh"

     interval 10

}

vrrp_instance VI_101 {

    state BACKUP

    nopreempt

    interface eth0

    virtual_router_ID 100

    priority 90

    advert_int 5

    authentication {

        auth_type PASS

        auth_pass 1314

    }

track_script {

    vs_MysqL_101

}

 virtual_ipaddress {

        172.16.20.30

    }

}

32服务器先启动。

/etc/init.d/keepalived start

/etc/init.d/keepalived status

ps -ef |grep keep

tail -100f /var/log/messages

172.16.20.32优先级高，keepalived的状态已经由backup升级为master。

ip addr

34服务器启动keepalived进程：

/etc/init.d/keepalived start

/etc/init.d/keepalived status

ps -ef |grep keep

tail -100f /var/log/messages

查看日志为backup 模式

管理用户测试登陆：

查看的UUID为主库32的。

备库keepalived 启动了，并没有VIP。

关闭32。

可以看到VIP飘到34服务器上。

且keepalived状态由backup升级为master。

以上是内存溢出为你收集整理的keepalived+双主架构部署全部内容，希望文章能够帮你解决keepalived+双主架构部署所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。

赞 (0)

打赏 微信扫一扫 支付宝扫一扫

搜狗哈哈 一级用户组

0 0

生成海报