文章目录
一、环境准备
操作系统: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