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

tedwhy

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

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

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