使用keepalived实现mysql的高可用

睡不醒的双眼皮

于 2024-07-16 09:10:57 发布

阅读量110

点赞数

文章标签： mysql 数据库

本文链接：https://blog.csdn.net/Merry_clown/article/details/140456105

版权

#1.主mysql的keepalive启动命令
docker run -d --name keepalived-master -v /qukan/keepalive/conf/keepalived.conf:/container/service/keepalived/assets/keepalived.conf --net=host --privileged=true osixia/keepalived --loglevel debug --copy-service


2.#主keepalived.conf配置文件
global_defs {
  default_interface enp2s0  #网卡名称
}

vrrp_instance VI_1 {
  interface enp2s0      #网卡名称

  state MASTER
  virtual_router_id 51    #主备id，需要一致
  priority 100            #权重，主高从低
  nopreempt

  unicast_peer {
    192.168.100.134           #两台mysql节点ip
    192.168.100.132
  }

  virtual_ipaddress {
     192.168.100.188        #同网段自定义虚拟ip
  }

  authentication {
    auth_type PASS
    auth_pass d0cker
  }

  notify "/container/service/keepalived/assets/notify.sh"
}



#3.从mysql的keepalive启动命令
docker run -d --name keepalived-slave -v /qukan/keepalive/conf/keepalived.conf:/container/service/keepalived/assets/keepalived.conf --net=host --privileged=true osixia/keepalived --loglevel debug --copy-service


#4.从keepalived.conf配置文件
global_defs {
  default_interface enp2s0
}

vrrp_instance VI_1 {
  interface enp2s0

  state BACKUP
  virtual_router_id 51
  priority 90        #权重值
  nopreempt

  unicast_peer {
    192.168.100.134
    192.168.100.132
  }

  virtual_ipaddress {
     192.168.100.188
  }

  authentication {
    auth_type PASS
    auth_pass d0cker
  }

  notify "/container/service/keepalived/assets/notify.sh"
}



#5.验证两台节点的虚拟ip是否存在，停止keepalived服务，查看自定义的虚拟ip是否会故障转移
ip a | grep enp2s0


2: enp2s0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 1000
    inet 192.168.100.132/24 brd 192.168.100.255 scope global noprefixroute enp2s0
    inet 192.168.100.188/32 scope global enp2s0