atlas+keepalive mysql的读写分离和高可用

07098

安装atlas
Rpm   -ivh  Atlas-2.2.el6.x86_64.rpm
安装目录：/usr/local/mysql_proxy/bin  启动文件Atlas管理接口使用:  
                               # mysql -u管理用户 -p管理密码 -h127.0.0.1 -P管理端口
                               # mysql -uuser -ppwd -h127.0.0.1 -P2345   
                               #查看DB状态：mysql> select * from backends;
/usr/;local/mysql_proxy/conf    test.conf   配置文件   
#admin-sername = aaa 注意：管理端口登录那个户名而非通过atlas进入mysql的账号面膜
#admin-password = 123456  管理端口密码
#proxy-backend-addresses = 192.168.20.197:3306  主库ip端口
#proxy-read-only-backend-addresses = 192.168.20.198:3306@1 从库IP端口
#pwds = manyushuai:/iZxz+0GRoA= 注意：这个是通过atlas进入数据库的账号密码用户名：manyushuai 密码：/iZxz+0GRoA=  密码为加密密码
加密过程：cd /usr/local/mysql-proxy/bin
./encrypt  123456   123456为要加密的密码
执行后会生成加密密码，把加密密码拷贝到配置文件

Mysql方面：注意添加用户可以远程登录，两个数据库账户密码保持


Keepalive安装
tar -zvxf keepalived-1\[1\].1.17.tar.gz
yum -y install  kernel-devel
ln -s /usr/src/kernels/2.6.18-164.el5-i686/ /usr/src/linux
cd keepalived-1.1.17/
yum install openssl-* -y
./configure --prefix=/usr/local/keepalived
make
make install
cp /usr/local/keepalived/etc/rc.d/init.d/keepalived /etc/init.d/
cp /usr/local/keepalived/etc/sysconfig/keepalived /etc/sysconfig/
mkdir -pv /etc/keepalived
cp /usr/local/keepalived/etc/keepalived/keepalived.conf /etc/keepalived/
ln -s /usr/local/keepalived/sbin/keepalived /sbin/
service keepalived restart

Keepalived配置文件
# vim /etc/keepalived/keepalived.conf
! Configuration File for keepalived
global_defs {
   router_id LVS_DEVEL
}
vrrp_instance VI_1 {
    state BACKUP
    interface eth0
    virtual_router_id 60  #注意默认51改掉
    priority 90          #优先级越高数值越大，主的优先级高
    advert_int 1
    authentication {
        auth_type PASS
        auth_pass 1111
    }
    virtual_ipaddress {
        192.168.20.197
    }
}