tedwhy 发表于 2018-9-27 10:32:00

部署mysql高可用、读写分离集群

Sep 29 10:58:12 localhost Keepalived: Starting Keepalived v1.2.15 (09/29,2015)  
Sep 29 10:58:12 localhost Keepalived: Starting Healthcheck child process, pid=3547
  
Sep 29 10:58:12 localhost Keepalived: Starting VRRP child process, pid=3548
  
Sep 29 10:58:12 localhost Keepalived_vrrp: Netlink reflector reports IP 192.168.247.132 added
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers: Initializing ipvs 2.6
  
Sep 29 10:58:12 localhost Keepalived_vrrp: Netlink reflector reports IP fe80::20c:29ff:fe5c:722c added
  
Sep 29 10:58:12 localhost Keepalived_vrrp: Registering Kernel netlink reflector
  
Sep 29 10:58:12 localhost Keepalived_vrrp: Registering Kernel netlink command channel
  
Sep 29 10:58:12 localhost Keepalived_vrrp: Registering gratuitous ARP shared channel
  
Sep 29 10:58:12 localhost Keepalived_vrrp: Opening file '/etc/keepalived/keepalived.conf'.
  
Sep 29 10:58:12 localhost Keepalived_vrrp: Configuration is using : 63286 Bytes
  
Sep 29 10:58:12 localhost Keepalived_vrrp: ------< Global definitions >------
  
Sep 29 10:58:12 localhost Keepalived_vrrp:Router ID = Atlas_ha
  
Sep 29 10:58:12 localhost Keepalived_vrrp:Smtp server = 127.0.0.1
  
Sep 29 10:58:12 localhost Keepalived_vrrp:Smtp server connection timeout = 30
  
Sep 29 10:58:12 localhost Keepalived_vrrp:Email notification from = root@localhost
  
Sep 29 10:58:12 localhost Keepalived_vrrp:Email notification = 732233048@qq.com
  
Sep 29 10:58:12 localhost Keepalived_vrrp:VRRP IPv4 mcast group = 224.0.0.18
  
Sep 29 10:58:12 localhost Keepalived_vrrp:VRRP IPv6 mcast group = 224.0.0.18
  
Sep 29 10:58:12 localhost Keepalived_vrrp: ------< VRRP Topology >------
  
Sep 29 10:58:12 localhost Keepalived_vrrp:VRRP Instance = VI_1
  
Sep 29 10:58:12 localhost Keepalived_vrrp:    Want State = BACKUP
  
Sep 29 10:58:12 localhost Keepalived_vrrp:    Runing on device = eth0
  
Sep 29 10:58:12 localhost Keepalived_vrrp:    Gratuitous ARP repeat = 5
  
Sep 29 10:58:12 localhost Keepalived_vrrp:    Gratuitous ARP refresh repeat = 1
  
Sep 29 10:58:12 localhost Keepalived_vrrp:    Virtual Router ID = 51
  
Sep 29 10:58:12 localhost Keepalived_vrrp:    Priority = 150
  
Sep 29 10:58:12 localhost Keepalived_vrrp:    Advert interval = 1sec
  
Sep 29 10:58:12 localhost Keepalived_vrrp:    Preempt disabled
  
Sep 29 10:58:12 localhost Keepalived_vrrp:    Authentication type = SIMPLE_PASSWORD
  
Sep 29 10:58:12 localhost Keepalived_vrrp:    Password = 1111
  
Sep 29 10:58:12 localhost Keepalived_vrrp:    Virtual IP = 1
  
Sep 29 10:58:12 localhost Keepalived_vrrp:      192.168.247.200/32 dev eth0 scope global
  
Sep 29 10:58:12 localhost Keepalived_vrrp: Using LinkWatch kernel netlink reflector...
  
Sep 29 10:58:12 localhost Keepalived_vrrp: VRRP_Instance(VI_1) Entering BACKUP STATE
  
Sep 29 10:58:12 localhost Keepalived_vrrp: VRRP sockpool:
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers: Netlink reflector reports IP 192.168.247.132 added
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers: Netlink reflector reports IP fe80::20c:29ff:fe5c:722c added
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers: Registering Kernel netlink reflector
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers: Registering Kernel netlink command channel
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers: Opening file '/etc/keepalived/keepalived.conf'.
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers: Configuration is using : 11723 Bytes
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers: IPVS: Scheduler or persistence engine not found
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers: IPVS: No such process
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers: ------< Global definitions >------
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers:Router ID = Atlas_ha
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers:Smtp server = 127.0.0.1
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers:Smtp server connection timeout = 30
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers:Email notification from = root@localhost
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers:Email notification = 732233048@qq.com
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers:VRRP IPv4 mcast group = 224.0.0.18
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers:VRRP IPv6 mcast group = 224.0.0.18
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers: ------< SSL definitions >------
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers:Using autogen SSL context
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers: ------< LVS Topology >------
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers:System is compiled with LVS v1.2.1
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers:VIP = 192.168.247.200, VPORT = 3306
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers:    delay_loop = 6, lb_algo =
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers:    protocol = TCP
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers:    alpha is OFF, omega is OFF
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers:    quorum = 1, hysteresis = 0
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers:    lb_kind = NAT
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers:    RIP = 192.168.247.132, RPORT = 3306, WEIGHT = 1
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers:      -> Notify script DOWN = /etc/keepalived/keepalived_monitor.sh
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers: ------< Health checkers >------
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers::3306
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers:    Keepalive method = TCP_CHECK
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers:    Connection dest = :3306
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers:    Connection timeout = 10
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers: Using LinkWatch kernel netlink reflector...
  
Sep 29 10:58:12 localhost Keepalived_healthcheckers: Activating healthchecker for service :3306
  
Sep 29 10:58:15 localhost Keepalived_vrrp: VRRP_Instance(VI_1) Transition to MASTER STATE
  
Sep 29 10:58:16 localhost Keepalived_vrrp: VRRP_Instance(VI_1) Entering MASTER STATE
  
Sep 29 10:58:16 localhost Keepalived_vrrp: VRRP_Instance(VI_1) setting protocol VIPs.
  
Sep 29 10:58:16 localhost Keepalived_vrrp: VRRP_Instance(VI_1) Sending gratuitous ARPs on eth0 for 192.168.247.200
  
Sep 29 10:58:16 localhost Keepalived_healthcheckers: Netlink reflector reports IP 192.168.247.200 added
  
Sep 29 10:58:21 localhost Keepalived_vrrp: VRRP_Instance(VI_1) Sending gratuitous ARPs on eth0 for 192.168.247.200
  

  
##进入master状态
  
##绑定vip 200
  
##检测ip 132
  

  
##设置开机自动启动
  
chkconfig keepalived on


页: [1]
查看完整版本: 部署mysql高可用、读写分离集群