MySQL5.7.25双机热备搭建

环境

IP	主机名	作用
10.1.24.128	bd128	MySQL 节点1
10.1.24.131	bd131	MySQL 节点2
10.1.24.9	VIP	虚拟地址

下载安装包：
链接：https://pan.baidu.com/s/1fXandH31xPp3Xxna5kFKlg
提取码：ygiu

准备

关闭防火墙

systemctl  stop  firewalld

systemctl  disable  firewalld

配置NTP同步时间

yum -y install ntp
vim /etc/ntp.conf

driftfile /var/lib/ntp/drift
restrict 127.0.0.1
restrict -6 ::1
restrict 10.1.24.0 mask 255.255.255.0 nomodify notrap
server bd134 prefer
restrict bd134 nomodify notrap noquery
server 127.127.1.0 # local clock
fudge 127.127.1.0 stratum 8
includefile /etc/ntp/crypto/pw
keys /etc/ntp/keys
tinker panic 0
disable monitor

然后启动并设置开启自启。

systemctl start ntpd
systemctl enable ntpd

MySQL安装

groupadd mysql
useradd -r -g mysql mysql
cp mysql-5.7.25-linux-glibc2.12-x86_64.fast.tar.gz /usr/local/
tar -xzvf mysql-5.7.25-linux-glibc2.12-x86_64.fast.tar.gz
cp -rf mysql/my.cnf /etc/my.cnf
ln -s /usr/local/mysql/data/mysql.sock /tmp/mysql.sock
cp mysql/support-files/mysql.server /etc/init.d/mysql
service mysql start
chkconfig mysql on

# 测试是否安装成功
bin/mysql -uroot -pbicon@123456 mysql

# 如果成功，退出添加以下内容
mkdir /usr/local/mysql/log
chown mysql:mysql /usr/local/mysql/log

主从复制

打开bd128的/etc/my.cnf文件，并添加如下内容：

character-set-server=utf8
group_concat_max_len = 200000  # 改变数据长度
lower_case_table_names=1     # 数据库不区分大小
server_id=1
log_bin = /usr/local/mysql/log/mysql-bin.log
log_bin_index = /usr/local/mysql/log/mysql-bin.log.index
relay_log = /usr/local/mysql/log/mysql-relay-bin
relay_log_index = /usr/local/mysql/log/mysql-relay-bin.index
expire_logs_days = 10
max_binlog_size = 1024M
log_slave_updates = 1
#binlog-do-db = test   #用来限制同步的库，注释掉就是所有库都可同步
#binlog-ignore-db = mysql
sync_binlog = 1
auto_increment_offset = 1
auto_increment_increment