MySQL高可用性之Keepalived+Mysql

比眉伴天荒 2022-07-12 11:45 245阅读 0赞

环境描述：

OS：CentOS6.5\_X64

MASTER：192.168.0.202

BACKUP：192.168.0.203

VIP：192.168.0.204

1、配置两台Mysql主主同步

<table style="margin-bottom:10px; border-collapse:collapse; color:rgb(0,0,0); font-family:sans-serif; font-size:16px"> 
 <tbody style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em; background:none"> 
  <tr style="padding:0px; margin:0px; font-size:1em; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; background:none"> 
   <td style="padding:0px; border:0px; margin:0px; font-size:1em; float:none; line-height:1.1em; vertical-align:baseline; color:rgb(175,175,175); background:none"> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      1 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      2 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      3 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      4 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      5 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      6 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      7 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      8 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      9 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      10 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      11 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      12 
    </div> </td> 
   <td style="padding:0px; border:0px; margin:0px; font-size:1em; line-height:1.1em; float:none; vertical-align:baseline; background:none"> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">[root@master&nbsp;~]</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; color:rgb(0,130,0); background:none">#&nbsp;yum&nbsp;install&nbsp;mysql-server&nbsp;mysql&nbsp;-y</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">[root@master&nbsp;~]</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; color:rgb(0,130,0); background:none">#&nbsp;service&nbsp;mysqld&nbsp;start</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">[root@master&nbsp;~]</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; color:rgb(0,130,0); background:none">#&nbsp;mysqladmin&nbsp;-u&nbsp;root&nbsp;password&nbsp;123.com</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">[root@master&nbsp;~]</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; color:rgb(0,130,0); background:none">#&nbsp;vi&nbsp;/etc/my.cnf&nbsp;&nbsp;#开启二进制日志，设置id</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">[mysqld]</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">server-</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; color:rgb(255,20,147); background:none">id</code>&nbsp; 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">=&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; color:rgb(0,130,0); background:none">#backup这台设置2</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">log-bin&nbsp;=&nbsp;mysql-bin</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">binlog-ignore-db&nbsp;=&nbsp;mysql,information_schema&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; color:rgb(0,130,0); background:none">#忽略写入binlog日志的库</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">auto-increment-increment&nbsp;=&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; color:rgb(0,130,0); background:none">#字段变化增量值</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">auto-increment-offset&nbsp;=&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; color:rgb(0,130,0); background:none">#初始字段ID为1</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">slave-skip-errors&nbsp;=&nbsp;all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; color:rgb(0,130,0); background:none">#忽略所有复制产生的错误&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">[root@master&nbsp;~]</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; color:rgb(0,130,0); background:none">#&nbsp;service&nbsp;mysqld&nbsp;restart</code> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

\#先查看下log bin日志和pos值位置

[![wKiom1MJYSngwysqAADkFn9zcK8686.jpg][]][wKiom1MJYSngwysqAADkFn9zcK8686.jpg]

master配置如下：

backup配置如下：

\#主主同步配置完毕，查看同步状态Slave\_IO和Slave\_SQL是YES说明主主同步成功。

[![wKioL1MJYQ7QfZfXAAGQt0H1o1c742.jpg][]][wKioL1MJYQ7QfZfXAAGQt0H1o1c742.jpg]

在master插入数据测试下：

[![wKiom1MJYUCC0nlQAAEk4ruZ3ys652.jpg][]][wKiom1MJYUCC0nlQAAEk4ruZ3ys652.jpg]

在backup查看是否同步成功：

[![wKioL1MJYXyyChXUAADPZraUk3Y684.jpg][]][wKioL1MJYXyyChXUAADPZraUk3Y684.jpg]

可以看到已经成功同步过去，同样在backup插入到user表数据，一样同步过去，双主就做成功了。

**2、配置keepalived实现热备**

\[root@backup ~\]\# yum install -y pcre-devel openssl-devel popt-devel \#安装依赖包

\#将keepalived配置成系统服务

<table style="margin-bottom:10px; border-collapse:collapse; color:rgb(0,0,0); font-family:sans-serif; font-size:16px; width:718px"> 
 <tbody style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em; background:none"> 
  <tr style="padding:0px; margin:0px; font-size:1em; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; background:none"> 
   <td style="padding:0px; border:0px; margin:0px; font-size:1em; float:none; line-height:1.1em; vertical-align:baseline; color:rgb(175,175,175); background:none"> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      1 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      2 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      3 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      4 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      5 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      6 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      7 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      8 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      9 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      10 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      11 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      12 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      13 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      14 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      15 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      16 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      17 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      18 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      19 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      20 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      21 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      22 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      23 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      24 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      25 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      26 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      27 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      28 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      29 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      30 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      31 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      32 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      33 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      34 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      35 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      36 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      37 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      38 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      39 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      40 
    </div> 
    <div style="padding:0px 0.5em 0px 1em; margin:0px; border-width:0px 3px 0px 0px; border-right-style:solid; border-right-color:rgb(108,226,108); float:none; line-height:1.1em; text-align:right; vertical-align:baseline; width:auto; font-size:1em; white-space:pre">
      41 
    </div> </td> 
   <td style="padding:0px; border:0px; margin:0px; font-size:1em; line-height:1.1em; float:none; vertical-align:baseline; word-break:break-all; background:none"> <p style="margin-top:0px; margin-bottom:0px; padding:0px 1em; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">[root@master&nbsp;~]</code><code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; color:rgb(0,130,0); background:none">#&nbsp;<strong><span style="background-color:rgb(255,255,0)">vi&nbsp;/etc/keepalived/keepalived.conf</span></strong></code></p> <p style="margin-top:0px; margin-bottom:0px; padding:0px 1em; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; color:rgb(0,130,0); background:none"><strong><span style="background-color:rgb(255,255,0)"><br> </span></strong></code></p> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">!&nbsp;Configuration&nbsp;File&nbsp;forkeepalived</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">global_defs&nbsp;{ </code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">notification_email&nbsp;{ </code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; color:rgb(255,20,147); background:none">test</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">@sina.com</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">}</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">notification_email_from&nbsp;&nbsp;admin@</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; color:rgb(255,20,147); background:none">test</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">.com</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">smtp_server&nbsp;127.0.0.1</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">smtp_connect_timeout&nbsp;30</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">router_id&nbsp;MYSQL_HA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; color:rgb(0,130,0); background:none"><span style="background-color:rgb(255,255,0)">#标识，双主相同</span></code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">}</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none"><span style="background-color:rgb(255,255,0)">vrrp_instance&nbsp;VI_1</span>&nbsp;{ </code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">state&nbsp;BACKUP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; color:rgb(0,130,0); background:none">#两台都设置BACKUP</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">interface&nbsp;eth0</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">virtual_router_id&nbsp;51&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; color:rgb(0,130,0); background:none">#主备相同</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">priority&nbsp;100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; color:rgb(0,130,0); background:none"><span style="background-color:rgb(255,255,0)">#优先级，backup设置90</span></code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">advert_int&nbsp;1</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">nopreempt&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; color:rgb(0,130,0); background:none"><span style="background-color:rgb(255,255,0)">#不主动抢占资源，只在master这台优先级高的设置，backup不设置</span></code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none"><span style="background-color:rgb(255,255,0)">authentication</span>&nbsp;{ </code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">auth_type&nbsp;PASS</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">auth_pass&nbsp;1111</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">}</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none"><span style="background-color:rgb(255,255,0)">virtual_ipaddress</span>&nbsp;{ </code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">192.168.0.204</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">}</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">}</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">virtual_server&nbsp;192.168.0.204&nbsp;3306&nbsp;{ </code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">delay_loop&nbsp;2</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; color:rgb(0,130,0); background:none">#lb_algo&nbsp;rr&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#LVS算法，用不到，我们就关闭了</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; color:rgb(0,130,0); background:none">#lb_kind&nbsp;DR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#LVS模式，如果不关闭，备用服务器不能通过VIP连接主MySQL</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">persistence_timeout&nbsp;50&nbsp;&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; color:rgb(0,130,0); background:none"><span style="background-color:rgb(255,255,0)">#同一IP的连接60秒内被分配到同一台真实服务器</span></code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">protocol&nbsp;TCP</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">real_server&nbsp;192.168.0.202&nbsp;3306&nbsp;{&nbsp;&nbsp;&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; color:rgb(0,130,0); background:none">#检测本地mysql，backup也要写检测本地mysql</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">weight&nbsp;3</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">notify_down&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">/usr/local/keepalived/mysql</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">.sh&nbsp;&nbsp;&nbsp;&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; color:rgb(0,130,0); background:none">#当mysq服down时，执行此脚本，杀死keepalived实现切换</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">TCP_CHECK&nbsp;{ </code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">connect_timeout&nbsp;3&nbsp;&nbsp;&nbsp;&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; color:rgb(0,130,0); background:none">#连接超时</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">nb_get_retry&nbsp;3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; color:rgb(0,130,0); background:none">#重试次数</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">delay_before_retry&nbsp;3&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; color:rgb(0,130,0); background:none">#重试间隔时间</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">&nbsp;&nbsp;</code> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">}</code> 
    </div> 
    <div style="padding:0px 1em; margin:0px; white-space:nowrap; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-size:1em"> 
     <code style="padding:0px; margin:0px; border:0px; float:none; line-height:1.1em; vertical-align:baseline; width:auto; font-family:Consolas,&quot;Bitstream Vera Sans Mono&quot;,&quot;Courier New&quot;,Courier,monospace; font-size:1em; background:none">}</code> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

\#backup服务器只修改priority为90、nopreempt不设置、real\_server设置本地IP。

\#授权两台Mysql服务器允许root远程登录，用于在其他服务器登陆测试！

mysql> grant all on \*.\* to'root'@'192.168.0.%' identified by '123.com';

mysql> flush privileges;

3、测试高可用性

1、通过Mysql客户端通过VIP连接，看是否连接成功。

2、停止master这台mysql服务，是否能正常切换过去，**可通过ip addr命令**来查看VIP在哪台服务器上。

[![wKiom1MJYbCBORSGAAHChWpI93k009.jpg][]][wKiom1MJYbCBORSGAAHChWpI93k009.jpg]

3、**可通过查看/var/log/messges日志，看出主备切换过程**

4、master服务器故障恢复后，是否主动抢占资源，成为活动服务器。

Keepalived+mysql双主来实现MySQL-HA，我们必须保证两台MySQL数据库的数据完全一样，

基本思路是两台 MySQL 互为主从关系(双主)，通过 Keepalived 配置虚拟 IP，实现当其中的一

台 MySQL 数据库宕机后，应用能够自动切换到另外一台 MySQL数据库，保证系统的高可用。

拓扑环境

OS：centos6.5 x86\_64

Mysql 版本：mysql 5.5.38

Keepalived: keepalived-1.2.20

Mysql-vip:192.168.12.1

Mysql-master1:192.168.12.128

Mysql-master2:192.168.12.129

一、配置两台 mysql 主主同步

主主同步就是两台机器互为主从的关系，在任何一台机器上写入都会同步。

若 mysql 主机开启了防火墙，需要关闭防火墙或创建规则。

1、修改 MySQL 配置文件

两台 MySQL 均要开启 binlog 日志功能，

开启方法：

在 MySQL 配置文件\[MySQLd\]段中加上**log-bin=MySQL-bin 选项，两台 MySQL 的 server-ID 不能一样**，默认情况下两台 MySQL 的serverID 都是 1，需将其中一台修改为 2 即可。

master1 中有关复制的配置如下：

log-bin = mysql-bin

binlog\_format = mixed

server-id = 1

relay-log = relay-bin

relay-log-index = slave-relay-bin.index

auto-increment-increment = 2

auto-increment-offset = 1

重启 mysqld 服务

\#service mysqld restart

master2 中有关复制的配置如下：

log-bin = mysql-bin

binlog\_format = mixed

server-id = 2

relay-log = relay-bin

relay-log-index = slave-relay-bin.index

auto-increment-increment = 2

auto-increment-offset = 2

重启 mysqld 服务

\#service mysqld restart

注：master1 和 master2 只有 **server-id 不同和 auto-increment-offset 不同。**

mysql 中有自增长字段，在做数据库的主主同步时需要设置自增长的两个相关配置：

auto\_increment\_offset 和 auto\_increment\_increment。

auto-increment-increment 表示自增长字段每次递增的量，其默认值是 1。

它的值应设为整个结构中服务器的总数，本案例用到两台服务器，所以值设为 2。

auto-increment-offset 是用来设定**数据库中自动增长的起点(即初始值)**，因为这两能服务器都

设定了一次自动增长值 2，所以它们的**起点必须得不同，这样才能避免两台服务器数据同步时出现主键冲突，**

注：可以在 my.cnf 文件中添加

“**binlog\_do\_db=数据库名**”配置项（可以添加多个）来指定要同步的数据库

\[client\]

port            = 3306

socket          = /db/mysql/mysql.sock

\[mysqld\]

datadir         = /db/mysql

port            = 3306

socket          = /db/mysql/mysql.sock

skip-locking

skip-name-resolv

key\_buffer = 4096M

max\_allowed\_packet = 1M

table\_cache = 4096

sort\_buffer\_size = 2M

read\_buffer\_size = 2M

read\_rnd\_buffer\_size = 8M

myisam\_sort\_buffer\_size = 64M

thread\_cache\_size = 8

query\_cache\_size = 32M

thread\_concurrency = 8

log-error = /db/mysql/mysql.log

long\_query\_time = 1

slow\_query\_log = log-queries-not-using-indexes

log-bin = /db/mysql/mysql-bin

expire\_logs\_day = 1

server-id       = 1

binlog-do-db = IMDB

binlog-do-db = CHANNELDB

binlog-ignore-db = mysql

innodb\_data\_home\_dir = /db/mysql

innodb\_data\_file\_path = ibdata1:2000M;ibdata2:10M:autoextend

innodb\_log\_group\_home\_dir = /db/mysql

innodb\_buffer\_pool\_size = 4G

innodb\_additional\_mem\_pool\_size = 20M

innodb\_log\_file\_size = 32M

innodb\_log\_buffer\_size = 48M

innodb\_flush\_log\_at\_trx\_commit = 2

innodb\_lock\_wait\_timeout = 50

innodb\_force\_recovery = 0

innodb\_file\_per\_table = 1

innodb\_log\_files\_in\_group = 3

\[mysqldump\]

quick

max\_allowed\_packet = 16M

\[mysql\]

no-auto-rehash

\[isamchk\]

key\_buffer = 256M

sort\_buffer\_size = 256M

read\_buffer = 2M

write\_buffer = 2M

\[myisamchk\]

key\_buffer = 256M

sort\_buffer\_size = 256M

read\_buffer = 2M

write\_buffer = 2M

\[mysqlhotcopy\]

interactive-timeout

2、将 master1 设为 master2 的主服务器

在 master1 主机上创建授权账户，允许在 master2(192.168.1.102)主机上连接

[![wKioL1ioKUzyMw9YAAAh5HEnjiU353.png-wh\_50][wKioL1ioKUzyMw9YAAAh5HEnjiU353.png-wh_50]][wKioL1ioKUzyMw9YAAAh5HEnjiU353.png-wh_50]

查看 master1 的当前 binlog 状态信息

[![wKiom1ioKWOjXfrfAAAjUBD7DK8130.png-wh\_50][wKiom1ioKWOjXfrfAAAjUBD7DK8130.png-wh_50]][wKiom1ioKWOjXfrfAAAjUBD7DK8130.png-wh_50]

在 master2 上将 master1 设为自已的主服务器并开启 slave 功能。

[![wKiom1ioKXChZlyKAAAqIiTOtuI140.png-wh\_50][wKiom1ioKXChZlyKAAAqIiTOtuI140.png-wh_50]][wKiom1ioKXChZlyKAAAqIiTOtuI140.png-wh_50]

查看从的状态，以下两个值必须为 yes,代表从服务器能正常连接主服务器

Slave\_IO\_Running:Yes

Slave\_SQL\_Running:Yes

[![wKioL1ioKX\_DS0TkAAA\_d--CbhE245.png-wh\_50][wKioL1ioKX_DS0TkAAA_d--CbhE245.png-wh_50]][wKioL1ioKX_DS0TkAAA_d--CbhE245.png-wh_50]

3、将 master2 设为 master1 的主服务器

在 master2 主机上创建授权账户，允许在 master1(192.168.12.128)主机上连接

[![wKiom1ioKZvRYbnTAAAf61e1Los309.png-wh\_50][wKiom1ioKZvRYbnTAAAf61e1Los309.png-wh_50]][wKiom1ioKZvRYbnTAAAf61e1Los309.png-wh_50]

查看 master2 的当前 binlog 状态信息

在 master1 上将 master2 设为自已的主服务器并开启 slave 功能。

查看从的状态，以下两个值必须为 yes,代表从服务器能正常连接主服务器

Slave\_IO\_Running:Yes

Slave\_SQL\_Running:Yes

[![wKioL1ioKgHy11K2AAD5qVG11vg877.jpg-wh\_50][wKioL1ioKgHy11K2AAD5qVG11vg877.jpg-wh_50]][wKioL1ioKgHy11K2AAD5qVG11vg877.jpg-wh_50]

4、测试主主同步

在 master1 上创建要同步的数据库如 test\_db，并在 test\_db 中创建一张测试表如 tab1

[![wKiom1ioKgvz9w46AAAmtvhXR4I238.png-wh\_50][wKiom1ioKgvz9w46AAAmtvhXR4I238.png-wh_50]][wKiom1ioKgvz9w46AAAmtvhXR4I238.png-wh_50]

查看 master2 主机是否同步了 master1 上的数据变化

[![wKiom1ioKh6iG1KHAAAhWmP9WVc972.png-wh\_50][wKiom1ioKh6iG1KHAAAhWmP9WVc972.png-wh_50]][wKiom1ioKh6iG1KHAAAhWmP9WVc972.png-wh_50]

[![wKiom1ioKjKjFsOJAAAeq\_keHMs217.png-wh\_50][wKiom1ioKjKjFsOJAAAeq_keHMs217.png-wh_50]][wKiom1ioKjKjFsOJAAAeq_keHMs217.png-wh_50]

从上图可以看出 master2 同步了 master 的数据变化

在 master2 主机上向 tab1 表中插入数据

[![wKioL1ioKj\_DgM3\_AAAhmEzt\_7E913.png-wh\_50][wKioL1ioKj_DgM3_AAAhmEzt_7E913.png-wh_50]][wKioL1ioKj_DgM3_AAAhmEzt_7E913.png-wh_50]

查看 master1 主机是否同步了 master2 上的数据变化

[![wKioL1ioKknTBQapAAAbTzQa90I788.png-wh\_50][wKioL1ioKknTBQapAAAbTzQa90I788.png-wh_50]][wKioL1ioKknTBQapAAAbTzQa90I788.png-wh_50]

现在任何一台 MySQL 上更新数据都会同步到另一台 MySQL，MySQL 同步完成。

注：若主 MYSQL 服务器已经存在，只是后期才搭建从 MYSQL 服务器，在置配数据同步前应先将主 MYSQL 服务器的要同步的数据库拷贝到从 MYSQL 服务器上（如先在主 MYSQL 上备份数据库，再用备份在从 MYSQL 服务器上恢复）

下面我们就完成 keepalived 的高可用性。

keepalived 是集群管理中保证集群高可用的一个软件解决方案，其功能类似于 heartbeat，用来防止单点故障 .

keepalived 是以** VRRP 协议**为实现基础的，VRRP 全称 Virtual Router Redundancy Protocol，即虚拟路由冗余协议 。

虚拟路由冗余协议，可以认为是实现路由器高可用的协议，即将 N 台提供相同功能的路由器组成一个路

由器组，这个组里面有一个 master 和多个 backup，master 上面有一个对外提供服务的 vip，master

会发组播（组播地址为 224.0.0.18），当 backup 收不到 vrrp 包时就认为 master 宕掉了，这时就需要根据 VRRP 的优先级 来 选举一个 backup 当 master。这样的话就可以保证路由器的高可用了。

keepalived 主要有三个模块，分别是 core、check 和 vrrp。core 模块为 keepalived 的核心，负

责主进程的启动、维护以及全局配置文件的加载和解析。check 负责健康检查，包括常见的

各种检查方式(

方式 1：tcp\_check,工作第四层。

方式 2：http\_get,工作在第五层，向指定的

URL 执行 http 请求，将得到的结果用 md5 加密并与指定的 md5 值比较看是否匹配，不匹配

则从服务器池中移除。

方式 3：ssl\_get:与 http\_get 相似。

方式 4：misc\_check:用脚本来检测。

方式 5：smtp\_check:用来检测邮件服务的 smtp)。vrrp 模块是来实现 VRRP 协议的。

二、keepalived 的安装配置

1、在 master1 和 master2 上安装软件包 keepalived

安装 keepalived 软件包与服务控制

**在编译安装 Keepalived 之前，必须先安装内核开发包 kernel-devel 以及 openssl-devel、**

**popt-devel 等支持库**。

![wKiom1ioKmfQj5LtAAAfJ4dIAQI583.png-wh\_50][wKiom1ioKmfQj5LtAAAfJ4dIAQI583.png-wh_50]

若没有安装则通过 rpm 或 yum 工具进行安装

编译安装 Keepalived

使用指定的 linux 内核位置对 keepalived 进行配置，并将安装路径指定为根目录，这样就无

需额外创建链接文件了，配置完成后，依次执行 make、make install 进行安装。

![wKiom1ioKo6Q8O2FAAAlPrQOnwY152.png-wh\_50][wKiom1ioKo6Q8O2FAAAlPrQOnwY152.png-wh_50]

注意：如不知道 keepalived 需要哪些依赖包，可到下载后的源码解压目录下查看 INSTALL 文

件内容，安装需要的依赖包，源码安装任何一个软件都要养成查看源码包文档的习惯，比如

INSTALL，README,doc 等文档，可以获得很多有用的信息

注意：在 centos7.2 上安装 keepalived 不需要添加--with-kernel-dir

\[root@localhost keepalived-1.2.20\]\#** ./configure --prefix=/ && make && make install**

使用 keepalived 服务

执行 make install 操作之后，**会自动生成/etc/init.d/keepalived 脚本文件**，但还需要手动添加

为系统服务，这样就可以使用 service、chkconfig 工具来对 keepalived 服务程序进行管理了。

![wKiom1ioKqWQSIeiAAAegz0vcio455.png-wh\_50][wKiom1ioKqWQSIeiAAAegz0vcio455.png-wh_50]

Master2 主机也完成 keepalived 安装，与 master1 一样，安装过程略

注：若开启了防火墙，需要关闭防火墙或创建规则。

注：如果在 centos7.2 上安装 keepalived 防火墙的规则配置如下：

\[root@localhost ~\]\# firewall-cmd --permanent --add-rich-rule="rule family=ipv4 destination address=224.0.0.18 protocol value=ip accept"

success

\[root@localhost ~\]\# firewall-cmd --reload

![wKiom1ioKrXwmhz\_AAAjwv\_YnOU138.png-wh\_50][wKiom1ioKrXwmhz_AAAjwv_YnOU138.png-wh_50]

2、修改 Keepalived 的配置文件

keepalived 只有一个配置文件 keepalived.conf，里面主要包括以下几个配置区域，分别是

global\_defs、vrrp\_instance 和 virtual\_server。

global\_defs：主要是配置故障发生时的通知对象以及机器标识。

vrrp\_instance：用来定义对外提供服务的 VIP 区域及其相关属性。

virtual\_server：虚拟服务器定义

master1 主机上的 keepalived.conf 文件的修改：

**vi /etc/keepalived/keepalived.conf:**

! Configuration File for keepalived //!表示注释

global\_defs \{

router\_id MYSQL-1 //表示运行 keepalived 服务器的一个标识

vrrp\_instance VI\_1 \{

state BACKUP //指定keepalived的角色,两台配置此处均是BACKUP,设为BACKUP将根据优先级决定主或从

interface eth0 //指定 HA 监测网络的接口

virtual\_router\_id 51 //虚拟路由标识，这个标识是一个数字(取值在 0-255 之间,用来区分多个

instance 的 VRRP 组播)，同一个 vrrp 实例使用唯一的标识,确保和 master2 相同，同网内不同集群此项必须不同,否则发生冲突。

priority 100 //用来选举 master 的，要成为 master，该项取值范围是 1-255（在此范围

之外会被识别成默认值 100）,此处 master2 上设置为 50

advert\_int 1 //发 VRRP 包的时间间隔，即多久进行一次 master 选举（可以认为是健康查

检时间间隔）

nopreempt //不抢占，即允许一个 priority 比较低的节点作为 master，即使有 priority 更高

的节点启动

authentication \{ //认证区域，认证类型有 PASS 和 HA（IPSEC），推荐使用 PASS（密码

只识别前 8 位）

auth\_type PASS

auth\_pass 1111

virtual\_ipaddress \{ //VIP 区域，指定 vip 地址

192.168.12.1

virtual\_server 192.168.1.100 3306 \{ //设置虚拟服务器，需要指定虚拟 IP 地址和服务端口，

IP 与端口之间用空格隔开

delay\_loop 2 //设置运行情况检查时间，单位是秒

lb\_algo rr //设置后端调度算法，这里设置为 rr，即轮询算法

lb\_kind DR //设置 LVS 实现负载均衡的机制，有 NAT、TUN、DR 三个模式可选

persistence\_timeout 60 //会话保持时间，单位是秒。这个选项对动态网页是非常有用的，

为集群系统中的 session 共享提供了一个很好的解决方案。

有了这个会话保持功能，用户的请求会被一直分发到某个服务节点，直到超过这个会话的保持时间。

protocol TCP //指定转发协议类型，有 TCP 和 UDP 两种

real\_server 192.168.1.101 3306 \{ //配置服务节点 1，需要指定 real server 的真实 IP 地址和

端口，IP 与端口之间用空格隔开

注：master2 上此处改为 192.168.12.128(即 master2 本机 ip)

weight 3 //配置服务节点的权值，权值大小用数字表示，数字越大，权值越高，设置权

值大小为了区分不同性能的服务器

notify\_down /etc/keepalived/bin/mysql.sh //检测到 realserver 的 mysql 服务 down 后执行的

脚本

TCP\_CHECK \{

connect\_timeout 3 //连接超时时间

nb\_get\_retry 3 //重连次数

delay\_before\_retry 3 //重连间隔时间

connect\_port 3306 //健康检查端口

master1 主机上有关 keepalived.conf 文件的具体配置如下：

![wKioL1ioKuTSJBKQAAA2-75wZOU522.png-wh\_50][wKioL1ioKuTSJBKQAAA2-75wZOU522.png-wh_50]

![wKiom1ioK4vQoSW\_AAAo\_qvuqxU761.png-wh\_50][wKiom1ioK4vQoSW_AAAo_qvuqxU761.png-wh_50]

启动 keepalived 服务

\#/etc/init.d/keepalived start

[![wKiom1ioK5vRN85YAAAagsPdsew855.png-wh\_50][wKiom1ioK5vRN85YAAAagsPdsew855.png-wh_50]][wKiom1ioK5vRN85YAAAagsPdsew855.png-wh_50]

Master2 主机上的 keepalived.conf 文件的修改：

**Master2 主机的 keepalived.conf 文件配置与 master1 基本相同，只是 router\_id，priority，real\_server 三处不同，其他配置都相同**

[![wKiom1ioK6mxef9GAAA0jNr-\_a4802.png-wh\_50][wKiom1ioK6mxef9GAAA0jNr-_a4802.png-wh_50]][wKiom1ioK6mxef9GAAA0jNr-_a4802.png-wh_50]

可以使用 scp 命令把 server1 主机上配置好的 keepalived.conf 文件拷贝到 server2 主机，只要。

启动 keepalived 服务

\#/etc/init.d/keepalived start

3、master1 和 master2 上都添加此检测脚本，作用是当 mysql 停止工作时自动关闭本机的

keepalived，从而实现将故障机器踢出（因每台机器上 keepalived 只添加了本机为 realserver）.

当 mysqld 正常启动起来后，要手动启动 keepalived 服务。

\#mkdir /etc/keepalived/bin

vi /etc/keepalived/bin/mysql.sh，内容如下：

[![wKioL1ioK87TQXvUAABZV3EvtSI961.jpg-wh\_50][wKioL1ioK87TQXvUAABZV3EvtSI961.jpg-wh_50]][wKioL1ioK87TQXvUAABZV3EvtSI961.jpg-wh_50]

[![wKiom1ioK96De3tPAAAV1LCgP5E896.png-wh\_50][wKiom1ioK96De3tPAAAV1LCgP5E896.png-wh_50]][wKiom1ioK96De3tPAAAV1LCgP5E896.png-wh_50]

Master2 主机完成相同的操作

4、测试

在 master1 和 master2 分别执行 ipaddr show dev eth0 命令查看 master1 和 master2 对 VIP

（群集虚拟 IP）的控制权。

Master1 主的查看结果：

[![wKioL1ioK\_DAH-e-AAA9tC4paWA741.png-wh\_50][wKioL1ioK_DAH-e-AAA9tC4paWA741.png-wh_50]][wKioL1ioK_DAH-e-AAA9tC4paWA741.png-wh_50]

Master2 主的查看结果：

[![wKiom1ioLAHQ2DnoAACxPQl7zR0716.jpg-wh\_50][wKiom1ioLAHQ2DnoAACxPQl7zR0716.jpg-wh_50]][wKiom1ioLAHQ2DnoAACxPQl7zR0716.jpg-wh_50]

从上图可以看出 master1 是主服务器，master2 为备用服务器。

停止 MySQL 服务，看 keepalived 健康检查程序是否会触发我们编写的脚本

停止 master1 主机的 mysql 服务

[![wKioL1ioLBaRPN3bAABO12TssaI692.jpg-wh\_50][wKioL1ioLBaRPN3bAABO12TssaI692.jpg-wh_50]][wKioL1ioLBaRPN3bAABO12TssaI692.jpg-wh_50]

Master2 主的查看结果：

[![wKioL1ioLDDxtK2HAAA9dowTBXI854.png-wh\_50][wKioL1ioLDDxtK2HAAA9dowTBXI854.png-wh_50]][wKioL1ioLDDxtK2HAAA9dowTBXI854.png-wh_50]

这说明在主服务上停止 MySQL 服务，触发了我们编写的脚本，进行自动故障切换。

MySQL 远程登录测试

我们找一台安装有 MySQL 客户端，然后登录 VIP，看是否能登录，在登录之两台 MySQL 服

务器都要授权允许从远程登录。例如：

[![wKiom1ioLESRQVJ5AAAbuUwr8P4451.png-wh\_50][wKiom1ioLESRQVJ5AAAbuUwr8P4451.png-wh_50]][wKiom1ioLESRQVJ5AAAbuUwr8P4451.png-wh_50]

在客户端上测试登录

[![wKioL1ioLFDhWVZiAABC8qlNDp8855.png-wh\_50][wKioL1ioLFDhWVZiAABC8qlNDp8855.png-wh_50]][wKioL1ioLFDhWVZiAABC8qlNDp8855.png-wh_50]

上图显示说明在客户端访问 VIP 地址，由 master1 主机提供响应的，因为 master1 当前是主

服务器，将 master1 的 mysql 服务停止，在客户端执行 show variables like‘server\_id’;

[![wKiom1ioLHKiHA1-AABAgu739s8652.png-wh\_50][wKiom1ioLHKiHA1-AABAgu739s8652.png-wh_50]][wKiom1ioLHKiHA1-AABAgu739s8652.png-wh_50]

上图显示说明在客户端的查询请求是由 master2 主机响应的。故障切换成功

总结：

Keepalived+mysql 双主一般来说，中小型规模的时候，采用这种架构是最省事的。

在 master 节点发生故障后，利用 keepalived 的高可用机制实现快速切换到备用节点。

在这个方案里，有几个需要注意的地方：

1.**采用 keepalived 作为高可用方案时，两个节点最好都设置成 BACKUP模式**，避免因为意外

情况下（比如 脑裂）相互抢占导致往两个节点写入相同数据而引发冲突；

2.把两个节点的 auto\_increment\_increment（自增步长）和 auto\_increment\_offset（自增起

始值）**设成不同值**。其目的是为了避免 master 节点意外宕机时，可能会有部分 binlog 未能

及时复制到slave上被应用，从而会导致slave新写入数据的自增值和原先master上冲突了，

因此一开始就使其错开；当然了，如果有合适的容错机制能解决主从自增 ID 冲突的话，也

可以不这么做；

3.slave 节点服务器配置不要太差，否则更容易导致复制延迟。作为热备节点的 slave 服务器，

硬件配置不能低于 master 节点；

4.如果对延迟问题很敏感的话，可考虑使用 MariaDB 分支版本，或者直接上线 MySQL 5.7 最

新版本，利用多线程复制的方式可以很大程度降低复制延迟；

[wKiom1MJYSngwysqAADkFn9zcK8686.jpg]: /images/20220710/dfcc95c3cf3e4b1294710d5f1ec0bb87.png
[wKioL1MJYQ7QfZfXAAGQt0H1o1c742.jpg]: /images/20220710/74075a1f3c4c45e78822318ca0f3671b.png
[wKiom1MJYUCC0nlQAAEk4ruZ3ys652.jpg]: /images/20220710/af7eda0ad91f4807a204904253e4fa17.png
[wKioL1MJYXyyChXUAADPZraUk3Y684.jpg]: /images/20220710/9a561775dcb84d02a3f8da151f91b413.png
[wKiom1MJYbCBORSGAAHChWpI93k009.jpg]: /images/20220710/fb94d420e1d145a38a577baed1f7f999.png
[wKioL1ioKUzyMw9YAAAh5HEnjiU353.png-wh_50]: /images/20220710/da439fd9547d4a7092460193599fb287.png
[wKiom1ioKWOjXfrfAAAjUBD7DK8130.png-wh_50]: /images/20220710/ed16981686ec4ba5848a4ec5561300e0.png
[wKiom1ioKXChZlyKAAAqIiTOtuI140.png-wh_50]: /images/20220710/905be8de803f4907a382a50f3d92503f.png
[wKioL1ioKX_DS0TkAAA_d--CbhE245.png-wh_50]: /images/20220710/b6692a6584ae4c8dadeb9527e95156ba.png
[wKiom1ioKZvRYbnTAAAf61e1Los309.png-wh_50]: /images/20220710/584b813303674e7a9739da958338176d.png
[wKioL1ioKgHy11K2AAD5qVG11vg877.jpg-wh_50]: /images/20220710/9f0c76a69ffc4495becd000410ad3bb2.png
[wKiom1ioKgvz9w46AAAmtvhXR4I238.png-wh_50]: /images/20220710/e3c15309486140409ee7d4af2568f91a.png
[wKiom1ioKh6iG1KHAAAhWmP9WVc972.png-wh_50]: /images/20220710/586d0a9ce6b848d79e99ab05e0fb8de3.png
[wKiom1ioKjKjFsOJAAAeq_keHMs217.png-wh_50]: /images/20220710/c0bc9176df0a48619cf3e3b3bc504765.png
[wKioL1ioKj_DgM3_AAAhmEzt_7E913.png-wh_50]: /images/20220710/06c7f12a25d446e5889c71a405b756d2.png
[wKioL1ioKknTBQapAAAbTzQa90I788.png-wh_50]: /images/20220710/3bb694dd883846a3a32ff4f106c47041.png
[wKiom1ioKmfQj5LtAAAfJ4dIAQI583.png-wh_50]: /images/20220710/0d169ae58d734b92be0cb463eff67c66.png
[wKiom1ioKo6Q8O2FAAAlPrQOnwY152.png-wh_50]: /images/20220710/27ba903b0dbc4c27aff76121fb6d3eba.png
[wKiom1ioKqWQSIeiAAAegz0vcio455.png-wh_50]: /images/20220710/33ff8e47edff45f4b90a689543c6bad9.png
[wKiom1ioKrXwmhz_AAAjwv_YnOU138.png-wh_50]: /images/20220710/11efca1f7a8749b0880948bdc4ead948.png
[wKioL1ioKuTSJBKQAAA2-75wZOU522.png-wh_50]: /images/20220710/3f6879a013224ca9adec68b085d3cc93.png
[wKiom1ioK4vQoSW_AAAo_qvuqxU761.png-wh_50]: /images/20220710/10c93d75de6e4873bac5c889a795efb8.png
[wKiom1ioK5vRN85YAAAagsPdsew855.png-wh_50]: /images/20220710/75110697e91142e585101a1ab1245302.png
[wKiom1ioK6mxef9GAAA0jNr-_a4802.png-wh_50]: /images/20220710/96b6cb6e3919460ca145d08b746a7593.png
[wKioL1ioK87TQXvUAABZV3EvtSI961.jpg-wh_50]: /images/20220710/eabe8b1e14d64e0aa42513ae699a50a7.png
[wKiom1ioK96De3tPAAAV1LCgP5E896.png-wh_50]: /images/20220710/e26ecaad4aa0491ab4cc1899f015311c.png
[wKioL1ioK_DAH-e-AAA9tC4paWA741.png-wh_50]: /images/20220710/15228c64cf2745778c7778c01524c1e6.png
[wKiom1ioLAHQ2DnoAACxPQl7zR0716.jpg-wh_50]: /images/20220710/b41bf27c628f48d7842d15d9c5c109c3.png
[wKioL1ioLBaRPN3bAABO12TssaI692.jpg-wh_50]: /images/20220710/b0f690a6015f4473bbac571f2aa1ee15.png
[wKioL1ioLDDxtK2HAAA9dowTBXI854.png-wh_50]: /images/20220710/abd1bfb260544e0593e0c6e3383a20a6.png
[wKiom1ioLESRQVJ5AAAbuUwr8P4451.png-wh_50]: /images/20220710/027fb7b5220d49fd8e2fcb8bfaf53cb4.png
[wKioL1ioLFDhWVZiAABC8qlNDp8855.png-wh_50]: /images/20220710/ced1a259666f4a0ba1aae96573b0b467.png
[wKiom1ioLHKiHA1-AABAgu739s8652.png-wh_50]: /images/20220710/0d9645aa02eb4c8ca9ea7717045b9c01.png