mysql keepalived安装配置步骤

//keepalived安装配置步骤

1. 安装keepalived步骤（server6 、 server7上都要安装）：

 

wget http://www.keepalived.org/software/keepalived-1.1.19.tar.gz

tar zxvf keepalived-1.1.19.tar.gz

 

cd keepalived-1.1.19

yum -y install openssl-devel

./configure --prefix=/usr/local/keepalived

make

make install

cp /usr/local/keepalived/sbin/keepalived /usr/sbin/

cp /usr/local/keepalived/etc/sysconfig/keepalived /etc/sysconfig/

cp /usr/local/keepalived/etc/rc.d/init.d/keepalived /etc/init.d/

mkdir /etc/keepalived

cd /etc/keepalived/

 

2. keepalived的配置

配置server6的keepalived配置文件/etc/keepalived/keepalived.conf（/etc/keepalived/里面没有文件，需要新编辑一个）

 

vi /etc/keepalived/keepalived.conf

bal_defs {

        notification_email {

              [email]wuweina@tonglukuaijian.com[/email]

        }

        notification_email_from[email]wuweina@tonglukuaijian.com[/email]

        smtp_server 127.0.0.1

        smtp_connect_timeout 30

        router_id test1

}

 

 

vrrp_instance VI_1 {

        state MASTER

        interface eth1

        virtual_router_id 51

        priority 100

        advert_int 1

        smtp_alert

        authentication {

                auth_type PASS

                auth_pass 123

        }

 

        virtual_ipaddress {

                192.168.10.170

        }

}

server7的配置：

keepalived配置文件/etc/keepalived/keepalived.conf，内容如下：

vi /etc/keepalived/keepalived.conf

bal_defs {

        notification_email {

              [email]wuweina@tonglukuaijian.com[/email]

        }

        notification_email_from[email]wuweina@tonglukuaijian.com[/email]

        smtp_server 127.0.0.1

        smtp_connect_timeout 30

        router_id test2

}

 

 

vrrp_instance VI_1 {

        state MASTER

        interface eth1

        virtual_router_id 51

        priority 80

        advert_int 1

        smtp_alert

        authentication {

                auth_type PASS

                auth_pass 123

        }

 

 

3. 启动keepalived:

在server6、server7上执行如下命令启动：

[root@server6 ~]# /etc/rc.d/init.d/keepalived start    ---OK

Starting keepalived: [  OK  ]

4. 测试

  //启动虚拟的10.170IP 通过8066端口连接成功，即表示整个环境搭建成功。

[root@server6 ~]# mysql -uroot -proot -h192.168.10.170 -P8066

Welcome to theMySQL monitor.  Commands end with ; or\g.

Your MySQLconnection id is 2719739

Server version:5.1.45-mysql-amoeba-proxy-2.1.0-RC5

 

Copyright (c)2000, 2011, Oracle and/or its affiliates. All rights reserved.

 

Oracle is aregistered trademark of Oracle Corporation and/or its

affiliates. Othernames may be trademarks of their respective

owners.

 

Type 'help;' or'\h' for help. Type '\c' to clear the current input statement.

 

mysql>

 

备注：最后记得将所有的启动命令都写到/etc/rc.local文件中去，实现开机启动！