keepalived+MySQL 5.7编译安装及双活配置

1.keepalived地址规划

192.168.217.33  xtgsadmin/nx!H01142
192.168.217.34  xtgsadmin/nx!H01141

vip
192.168.217.64
掩码255.255.255.0
网关192.168.217.254

2.keepalived配置信息

节点一：
[root@H01089 keepalived]# cat keepalived.conf
! Configuration File for keepalived

vrrp_instance VI_1 {
    state MASTER
    interface eth5
    virtual_router_id 51
    priority 100
    advert_int 1
    authentication {
        auth_type PASS
        auth_pass 1111
    }
    virtual_ipaddress {
        192.168.217.64
    }
}

节点二：
vrrp_instance VI_1 {
    state MASTER
    interface enP1p24s0f0
    virtual_router_id 51
    priority 50 
    advert_int 1
    authentication {
        auth_type PASS
        auth_pass 1111
    }
    virtual_ipaddress {
        192.168.217.64
    }
}

3.keepalived编译安装

yum install -y gcc gcc-c++ ncurses* 

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

cp /usr/local/keepalived/etc/rc.d/init.d/keepalived /etc/init.d/
cp /usr/local/keepalived/etc/sysconfig/keepalived /etc/sysconfig/
ln -s /usr/local/keepalived/sbin/keepalived /usr/sbin/
chmod +x /etc/init.d/keepalived
chkconfig --add keepalived
chkconfig keepalived on

3.MySQL安装前的准备工作

需要的软件：

boost_1_59_0.tar.gz，cmake-3.6.1.tar.gz，mysql-5.7.22.tar.gz

4.开始安装MySQL

4.1 安装cmake
[root@oracle cmake-3.6.1]# ./bootstrap && make && make install

4.2 开始编译安装MySQL

创建用户和组

[root@oracle cmake-3.6.1]#groupadd mysql

[root@oracle cmake-3.6.1]#useradd -g mysql -s /sbin/nologin -M mysql

创建安装数据库的目录和数据存放目录

[root@oracle src]# mkdir mysql5
[root@oracle src]# mkdir mysql

解压数据库软件

[root@oracle src]# tar -xvf mysql-5.7.22.tar.gz 

[root@oracle mysql-5.7.22]# 
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DWITH_INNOBASE_STORAGE_ENGINE=1 -DMYSQL_TCP_PORT=13306 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_DEBUG=0 -DWITH_BOOST=/usr/local/boost 

出现报错，这个的解决方法是：

在/usr/local下创建一个名为boost的文件夹

mkdir -p /usr/local/boost
把上面的名为boost_1_59_0.tar.gz的压缩包解压就可以了
tar -xvf boost_1_59_0.tar.gz
继续CMAKE 这里要注意红色的部分

[root@oracle src]# 
cmake . -DCMAKE_INSTALL_PREFIX=/data/src/mysql -DMYSQL_DATADIR=/data/src/mysql5 -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DWITH_INNOBAS