MySQL双主+keepalived实现高可用

一、环境准备

操作系统：CentOS 7.6
数据库：MySQL 5.7.26社区版
keepalived：1.4.5
Service1：192.168.5.130 安装MySQL+keepalived
Service2：192.168.5.131 安装MySQL+keepalived
VIP：192.168.5.125

时钟同步

//1.下载安装时钟同步依赖包
# yum install ntp
//2.将ntp设置为默认启动
# systemctl enable ntpd
//3.修改启动参数，允许ntp在系统时间误差较大时仍能工作
# vi /etc/sysconfig/ntpd
	# Command line options for ntpd
	OPTIONS="-g"
	修改为:
	OPTIONS="-g -x"
//4.将系统时间设置为上海时区
# ln -sf /usr/share/zoneinfo/Asia/Shanghai /etc/localtime
//5.查看时间
# date

二、环境部署–MySQL

1.解压MySQL安装包

下载的MySQL 5.7.26社区版安装包是tar文件，解压

# tar vxf mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar

2.检查MariaDB

//在安装MySQL数据库之前先检查CentOS是否自带MariaDB
# rpm -qa|grep maria*
//存在即卸载
# yum -y remove maria*
//如果不是root权限用户登录，执行上面方法时会提示请使用root权限操作
//删除完成后再次查看，已经没有了
//如果yum命令卸载失败，可以直接使用rpm命令强制删除
# rpm -e -nodeps mariadb-libs-5.5.60-1.el7_5.x86_64	

3.安装MySQL

先安装MySQL需要的依赖

# yum install net-tools
# yum install -y gcc* make automake ncurses-devel cmake

安装完依赖后安装MySQL(之前解压的rpm文件)

# rpm -ivh mysql-community-common-5.7.26-1.el7.x86_64.rpm
# rpm -ivh mysql-community-libs-5.7.26-1.el7.x86_64.rpm
# rpm -ivh mysql-community-client-5.7.26-1.el7.x86_64.rpm
# rpm -ivh mysql-community-server-5.7.26-1.el7.x86_64.rpm

4.检查安装

启动MySQL，查看是否安装成功

// 启动service mysqld start 或 systemctl start mysqld
# service mysqld start
// 查看状态 service mysqld status 或 systemctl status mysqld
# service mysqld status
// 停止 service mysqld stop 或 systemctl stop mysqld

5.配置双主

先将MySQL进程停止 service mysqld stop ，并在130和131两个服务下修改/etc/my.cnf 文件 vi /etc/my.cnf
server1：

		server_id = 1
		binlog-ignore-db = mysql
		log-bin = mysql-bin
		binlog_cache_size = 1M
		binlog_format = mixed
		expire_logs_days = 7
		slave_skip_errors = 1062
		relay_log = edu.mysql-relay-bin
		log_slave_updates = 1
		auto_increment_increment	 = 2
		auto_increment_offset = 1

server2：

		server_id = 2
		binlog-ignore-db = mysql
		log-bin = mysql-bin
		binlog_cache_size = 1M
		binlog_format = mixed
		expire_logs_days = 7
		slave_skip_errors = 1062
		relay