keepalived+双主mysql 搭建过程-优快云博客

本文详细介绍如何在CentOS6.5环境下，利用MySQL 5.7.9和Keepalived 1.2.20搭建MySQL双主高可用集群，包括配置MySQL参数、设置GTID模式、创建复制用户、搭建主主复制环境及Keepalived的安装与配置。

一：环境介绍

master1：10.124.151.20 安装mysql和keepalived

master2：10.124.151.22 安装mysql和keepalived

VIP：10.124.151.23

mysql版本：5.7.9

OS版本：CentOS 6.5

keepalived版本：1.2.20

二：安装过程

1.安装mysql

配置文件：（两台服务器的server_id必须不同）

注意以下参数是简化过后的：

[mysqld]

datadir=/usr/local/mysql/data

socket=/tmp/mysql.sock

user=mysql

symbolic-links=0

server_id=3

gtid_mode=ON

enforce_gtid_consistency=ON

master_info_repository=TABLE

relay_log_info_repository=TABLE

binlog_checksum=NONE

log_slave_updates=ON

log_bin=binlog

binlog_format=ROW

#relay-log = /tmp/mysql-relay

#relay-log-index = /tmp/relay-index

auto_increment_increment = 2   #这两个参数必须要有

auto_increment_offset = 1   #（两台机器一个1 一个2，避免出现主键冲突）

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/tmp/mysqld.pid

重启mysql服务器

2.搭建主主

1.创建复制用户（两台服务器都要创建）

grant replication slave,replication client on *.* to 'repl'@'10.124.151.%' identified by '123123';

flush privileges;

2.将master1设置为master2的主服务器

如果之前搭建过replication，执行：stop slave；reset slave；

如果没有：

因为设置了gtid，所以：

change master to MASTER_HOST='10.124.151.20',

MASTER_USER='repl',

MASTER_PASSWORD='123123',

MASTER_PORT=3306,

master_auto_position=1;

开启复制

start slave;

检查复制状态

show slave status; 都为yes，则复制成功。

3.将master2设置为master1的主服务器

如果之前搭建过replication，执行：stop slave；reset slave；

如果没有：

因为设置了gtid，所以：

change master to MASTER_HOST='10.124.151.22',

MASTER_USER='repl',

MASTER_PASSWORD='123123',

MASTER_PORT=3306,

master_auto_position=1;

开启复制

start slave;

检查复制状态

show slave status; 都为yes，则复制成功。

如果现在任何一台MySQL上更新数据都会同步到另一台MySQL，则MySQL双主搭建完成。

3.keepalived的安装配置

1.安装关联包

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

yum install -y kernel-devel openssl-devel popt-devel

也可以用rpm：

rpm -ivh kernel-devel openssl-devel popt-devel

2.步骤

使用指定的linux内核位置对keepalived进行配置，并将安装路径指定为根目录，这样就无需额外创建链接文件了，配置完成后，依次执行make、make install进行安装。

tar –xf keepalived-1.2.20.tar.gz

cd keepalived-1.2.20

两种方法：

./configure --prefix=/ --with-kernel-dir=/usr/src/kernels/2.6.32-431.el6.x86_64/ && make && make install

chkconfig --add keepalived

chkconfig keepalived on

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

则：

mkdir /etc/keepalived

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

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

    cp /usr/local/keepalived/etc/keepalived/keepalived.conf /etc/keepalived/

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

或：

mkdir /etc/keepalived;

ln -s /usr/local/keepalived/etc/keepalived/keepalived.conf /etc/keepalived/

ln -s /usr/local/keepalived/etc/rc.d/init.d/keepalived /etc/init.d/

ln -s /usr/local/keepalived/etc/sysconfig/keepalived /etc/sysconfig

ln -s /usr/local/keepalived/sbin/keepalived /sbin/

3.修改配置文件

vim /etc/keepalived/keepalived.conf

master1：

! Configuration File for keepalived

global_defs {

   router_id mysql-1

}

vrrp_script chk_mysql {

         script "/etc/keepalived/bin/mysql.sh"

         interval 1

         fall 1

         rise 1

         }

vrrp_instance VI_1 {

    state BACKUP

    interface bond0

    virtual_router_id 51

    priority 100

    advert_int 1

    nopreempt

    authentication {

        auth_type PASS

        auth_pass 1111

    }

   track_script {

         chk_mysql

    }

    virtual_ipaddress {

        10.124.151.23

    }

}

master2：

! Configuration File for keepalived

global_defs {

   router_id mysql-2

}

vrrp_script chk_mysql {

         script "/etc/keepalived/bin/mysql.sh"

         interval 1

         fall 1

         rise 1

         }

vrrp_instance VI_1 {

    state BACKUP

    interface bond0

    virtual_router_id 51

    priority 50

    advert_int 1

    authentication {

        auth_type PASS

        auth_pass 1111

    }

   track_script {

         chk_mysql

    }

    virtual_ipaddress {

        10.124.151.23

    }

}