设为首页 收藏本站
查看: 617|回复: 0

[经验分享] keepalived+双主

[复制链接]

尚未签到

发表于 2018-12-29 10:36:20 | 显示全部楼层 |阅读模式
  [root@mini1 ~]# setenforce 0
  [root@mini1 ~]# systemctl stop firewalld.service
  [root@mini1 ~]# vim /etc/my.cnf
  server_id=1
  log-bin=mysql-bin
  gtid-mode=on
  enforce-gtid-consistency=1
  log_slave_updates = 1
  binlog-format=mixed
  auto-increment-increment=2          #自动增长步长,三台mysql这设置为3
  auto-increment-offset=1              #自增长初始值
  [root@mini1 ~]# service mysqld start
  [root@mini2 ~]# setenforce 0
  [root@mini2 ~]# systemctl stop firewalld.service
  [root@mini2 ~]# vim /etc/my.cnf
  server_id=2
  log-bin=mysql-bin
  gtid-mode=on
  enforce-gtid-consistency=1
  log_slave_updates = 1
  binlog-format=mixed
  auto-increment-increment=2
  auto-increment-offset=2
  [root@mini2 ~]# service mysqld start
  #设置双主同步
  [root@mini1 ~]# mysql -uroot -p123456
  mysql> grant replication slave on *.* to rep@'192.168.1.%' identified by '123456';
  [root@mini2 ~]# mysql -uroot -p123456
  mysql> change master to master_host='192.168.1.128',master_user='rep',master_password='123456',master_port=3306,master_auto_position=1;
  mysql> start slave;
  mysql> show slave status\G;
  mysql>  grant replication slave on *.* to rep@'192.168.1.%' identified by '123456';
  [root@mini1 ~]# mysql -uroot -p123456
  mysql> change master to master_host='192.168.1.128',master_user='rep',master_password='123456',master_port=3306,master_auto_position=1;
  mysql> start slave;
  mysql> show slave status\G;
  #测试是否同步
  mysql> create database test;
  mysql> create table test.t1(id int primary key auto_increment,name varchar(10));
  mysql> insert into test.t1(name) values('tom1');
  #登录master2查看
  mysql> select * from test.t1;
  +----+------+
  | id | name |
  +----+------+
  |  2 | tom1 |
  |  4 | tom1 |
  +----+------+
  #在master1与master2上安装keepalived
  #keepalived依赖包
  [root@mini1 ~]# yum -y install kernel-devel openssl-devel popt-devel
  [root@mini1 ~]# tar zxf keepalived-2.0.6.tar.gz
  [root@mini1 ~]# cd keepalived-2.0.6/
  [root@mini1 keepalived-2.0.6]# ./configure --prefix=/ --with-kernel-dir= /usr/src/kernels/3.10.0-862.9.1.el7.x86_64/ &&make &&make install
  [root@mini1 ~]# vim /etc/keepalived/keepalived.conf
  [root@mini1 ~]# vim /etc/keepalived/keepalived.conf
  ! Configuration File for keepalived
  global_defs {
  router_id mysql_1
  }
  state BACKUP
  interface eno16777728
  virtual_router_id 51
  auth_type PASS
  auth_pass 1111
  ! Configuration File for keepalived
  global_defs {
  router_id mysql_1
  }
  vrrp_instance VI_1 {
  state BACKUP
  interface eno16777728
  virtual_router_id 51
  priority 100
  advert_int 1
  nopreempt
  authentication {
  auth_type PASS
  auth_pass 1111
  }
  virtual_ipaddress {
  192.168.1.100
  }
  }
  virtual_server 192.168.1.100 3306 {
  delay_loop 6
  lb_algo rr
  lb_kind DR
  persistence_timeout 50
  protocol TCP
  real_server 192.168.1.128 3306 {
  weight 1
  notify_down /etc/keepalived/bin/mysql.sh
  TCP_CHECK {
  connect_timeout 3
  retry 3
  delay_before_retry 3
  connect_port 3306
  }
  }
  }
  [root@mini1 ~]# mkdir /etc/keepalived/bin
  [root@mini1 ~]# vim /etc/keepalived/bin/mysql.sh
  #!/bin/bash
  pkill keepalived
  /sbin/ifdown eno16777728 && /sbin/ifup eno16777728
  [root@mini1 ~]# chmod +x /etc/keepalived/bin/mysql.sh
  [root@mini1 ~]# systemctl start keepalived.service
  [root@mini1 ~]# ss -lanp |grep keepa
  p_raw  UNCONN     0      0      rarp:*                      *                    users:(("keepalived",pid=17863,fd=7))
  u_dgr  UNCONN     0      0         * 25852                 * 8724                users:(("keepalived",pid=17863,fd=3),("keepalived",pid=17862,fd=3),("keepalived",pid=17861,fd=3))
  raw    UNCONN     0      0         *:112                   *:*                   users:(("keepalived",pid=17863,fd=9))
  raw    UNCONN     0      0         *:112                   *:*                   users:(("keepalived",pid=17863,fd=8))
  raw    UNCONN     0      0         *:255                   *:*                   users:(("keepalived",pid=17862,fd=5))
  #master2给以上一样,只需修改配置文件几个地方和mysql.sh
  [root@mini2 ~]# vim /etc/keepalived/keepalived.conf
  ! Configuration File for keepalived
  global_defs {
  router_id mysql_2
  }
  state BACKUP
  interface eno16777736
  virtual_router_id 51
  priority 50
  auth_type PASS
  auth_pass 1111
  }
  virtual_ipaddress {
  192.168.1.100
  }
  }
  virtual_server 192.168.1.100 3306 {
  delay_loop 6
  lb_algo rr
  lb_kind DR
  persistence_timeout 50
  protocol TCP
  real_server 192.168.1.129 3306 {
  weight 1
  notify_down /etc/keepalived/bin/mysql.sh
  TCP_CHECK {
  connect_timeout 3
  retry 3
  delay_before_retry 3
  connect_port 3306
  }
  }
  }
  [root@mini2 ~]# vim /etc/keepalived/bin/mysql.sh
  #!/bin/bash
  pkill keepalived
  /sbin/ifdown eno16777736 && /sbin/ifup eno16777736
  [root@mini1 ~]# chmod +x /etc/keepalived/bin/mysql.sh
  [root@mini1 ~]# ip addr
  2: eno16777728:  mtu 1500 qdisc pfifo_fast state UP group default qlen 1000
  link/ether 00:0c:29:d8:de:a3 brd ff:ff:ff:ff:ff:ff
  inet 192.168.1.128/24 brd 192.168.1.255 scope global noprefixroute dynamic eno16777728
  valid_lft 5353953sec preferred_lft 5353953sec
  inet 192.168.1.100/32 scope global eno16777728
  valid_lft forever preferred_lft forever
  [root@mini1 ~]# service mysqld stop
  Shutting down MySQL............ SUCCESS!
  [root@mini1 ~]# ip addr
  2: eno16777728:  mtu 1500 qdisc pfifo_fast state UP group default qlen 1000
  link/ether 00:0c:29:d8:de:a3 brd ff:ff:ff:ff:ff:ff
  inet 192.168.1.128/24 brd 192.168.1.255 scope global noprefixroute dynamic eno16777728
  valid_lft 5353814sec preferred_lft 5353814sec
  inet6 fe80::20c:29ff:fed8:dea3/64 scope link noprefixroute
  valid_lft forever preferred_lft forever
  [root@mini2 ~]# ip addr
  2: eno16777736:  mtu 1500 qdisc pfifo_fast state UP group default qlen 1000
  link/ether 00:0c:29:da:f7:a1 brd ff:ff:ff:ff:ff:ff
  inet 192.168.1.129/24 brd 192.168.1.255 scope global noprefixroute dynamic eno16777736
  valid_lft 5353785sec preferred_lft 5353785sec
  inet 192.168.1.100/32 scope global eno16777736
  valid_lft forever preferred_lft forever
  inet6 fe80::20c:29ff:feda:f7a1/64 scope link noprefixroute
  valid_lft forever preferred_lft forever




运维网声明 1、欢迎大家加入本站运维交流群:群②:261659950 群⑤:202807635 群⑦870801961 群⑧679858003
2、本站所有主题由该帖子作者发表,该帖子作者与运维网享有帖子相关版权
3、所有作品的著作权均归原作者享有,请您和我们一样尊重他人的著作权等合法权益。如果您对作品感到满意,请购买正版
4、禁止制作、复制、发布和传播具有反动、淫秽、色情、暴力、凶杀等内容的信息,一经发现立即删除。若您因此触犯法律,一切后果自负,我们对此不承担任何责任
5、所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其内容的准确性、可靠性、正当性、安全性、合法性等负责,亦不承担任何法律责任
6、所有作品仅供您个人学习、研究或欣赏,不得用于商业或者其他用途,否则,一切后果均由您自己承担,我们对此不承担任何法律责任
7、如涉及侵犯版权等问题,请您及时通知我们,我们将立即采取措施予以解决
8、联系人Email:admin@iyunv.com 网址:www.yunweiku.com

所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其承担任何法律责任,如涉及侵犯版权等问题,请您及时通知我们,我们将立即处理,联系人Email:kefu@iyunv.com,QQ:1061981298 本贴地址:https://www.yunweiku.com/thread-657156-1-1.html 上篇帖子: Keepalived主主模型 下篇帖子: keepalived实现haproxy高可用详解
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

扫码加入运维网微信交流群X

扫码加入运维网微信交流群

扫描二维码加入运维网微信交流群,最新一手资源尽在官方微信交流群!快快加入我们吧...

扫描微信二维码查看详情

客服E-mail:kefu@iyunv.com 客服QQ:1061981298


QQ群⑦:运维网交流群⑦ QQ群⑧:运维网交流群⑧ k8s群:运维网kubernetes交流群


提醒:禁止发布任何违反国家法律、法规的言论与图片等内容;本站内容均来自个人观点与网络等信息,非本站认同之观点.


本站大部分资源是网友从网上搜集分享而来,其版权均归原作者及其网站所有,我们尊重他人的合法权益,如有内容侵犯您的合法权益,请及时与我们联系进行核实删除!



合作伙伴: 青云cloud

快速回复 返回顶部 返回列表