mysql启用keepalive_Mysql + keepalive高可用搭建

Mysql + keepalive高可用搭建

系统环境：centos6.8

Ip：192.168.137.36 主库

192.168.137.38 从库

VIP(虚拟ip/浮动ip):192.168.137.100

软件版本：mysql 5.7.20

Keepalived 1.2.13

主从搭建略

Mysql1

vim /etc/my.cnf

binlog-do-db=test

log-bin=mysql-bin

server-id=1

gtid-mode=ON

enforce-gtid-consistency

Mysql2

Vim /etc/my.cnf

gtid-mode=ON

enforce-gtid-consistency

log-bin=mysql-bin

log-slave-updates=ON

server-id=3

binlog-do-db=test

安装keepalived

yum install keepalived

在192.168.137.36主库修改keepalived的配置文件

注意：加颜色部分为修改部分

[root@zabbix ~]# cat /etc/keepalived/keepalived.conf

! Configuration File for keepalived

global_defs{

notification_email {

r