Keepalive实现mysql双主热备.docx

Keepalive实现mysql双主热备环境描述：OS: CentoOS6.6_X64Node1:Node2:VIP:0配置主机互信Node1:[root@node1 ~]# ifconfig eth0eth0 Link encap:Ethernet HWaddr 00:0C:29:11:21:56 inet addr: Bcast:55 Mask: inet6 addr: fe80::20c:29ff:fe11:2156/64 Scope:Link UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:144 errors:0 dropped:0 overruns:0 frame:0 TX packets:114 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:14467 (14.1 KiB) TX bytes:11961 (11.6 KiB)[root@node1 ~]# ntpdate 025 Jul 11:34:52 ntpdate[2123]: step time server 0 offset -28852.934223 sec[root@node1 ~]# crontab -e15 5 * * * /usr/bin/crontab 0 [root@node1 ~]# hostname node1.S[root@node1 ~]# hostname node1.S[root@node1 ~]# vim /etc/sysconfig/networkNETWORKING=yesHOSTNAME=node1.S[root@node1 ~]# uname -nnode1.S[root@node1 ~]# vim /etc/hosts localhost localhost.localdomain localhost4 localhost4.localdomain4::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 node1.S node1 node2.S node2[root@node1 ~]# ssh-keygen -t rsa -f ~/.ssh/id_rsa -P Generating public/private rsa key pair.Created directory /root/.ssh.Your identification has been saved in /root/.ssh/id_rsa.Your public key has been saved in /root/.ssh/id_rsa.pub.The key fingerprint is:4c:9e:47:8a:a1:ee:d3:64:d5:e0:ab:21:fd:e6:43:19 root@node1.SThe keys randomart image is:+--[ RSA 2048]----+| || . || ...o. || . *E+. ||....S+. || .. = +. || .= = || .. o + || .. o.. |+-----------------+[root@node1 ~]# ssh-copy-id -i .ssh/id_rsa.pub root@The authenticity of host () cant be established.RSA key fingerprint is cc:c3:c7:45:9e:40:60:dd:03:13:b3:37:9a:ff:0e:8a.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added (RSA) to the list of known hosts.root@s password: Now try logging into the machine, with ssh root@, and check in: .ssh/authorized_keysto make sure we havent added extra keys that you were