双A复制mysql_MySQL 双主复制 + keepalived

1.双主规划

架构：双主复制+keepalived

mysql01: 192.168.10.161 3306

mysql02: 192.168.10.162 3306

keepalived: 192.168.10.160

操作系统： CentOS 7 x64

数据库版本：mysql-5.7.28

备注：MySQL 安装过程省略。

2.修改参数

#mysql01

[mysqld]

user = mysql

basedir = /usr/local/mysql

datadir = /data/3306

pid-file = /data/3306/mysql_3306.pid

socket = /tmp/mysql3306.sock

port = 3306

server_id = 330601

log_error = /data/3306/mysql.log

log_timestamps = system

log_bin = /data/3306/mysql-bin

binlog_format = row

gtid-mode = on

enforce-gtid-consistency = true

log-slave-updates=1

#binlog-do-db=mydb01,mydb02

#binlog-ignore-db=mysql

#binlog-ignore-db=information_schema

auto-increment-increment= 2

auto-increment-offset = 1

expire_logs_days = 15

slow_query_log = 1

slow_query_log_file = /data/3306/slow.log

long_query_time = 2

log_queries_not_using_indexes

#mysql02

[mysqld]

user = mysql

basedir = /usr/local/mysql

datadir = /data/3306

pid-file = /data/3306/mysql_3306.pid

socket = /tmp/mysql3306.sock

port = 3306

server_id = 330602

log_error = /data/3306/mysql.log

log_timestamps = system

log_bin = /data/3306/mysql-bin

binlog_format = row

gtid-mode = on

enforce-gtid-consistency = true

log-slave-updates=1

#binlog-do-db=mydb01,mydb02

#binlog-ignore-db=mysql

#binlog-ignore-db=information_schema

auto-increment-increment= 2

auto-increment-offset = 2

expire_logs_days = 15

slow_query_log = 1

slow_query_log_file = /data/3306/slow.log

long_query_time = 2

log_queries_not_using_indexes

#重启mysql

#mysql01

systemctl stop mysqld3306

systemctl stop mysqld3306

#mysql02

systemctl start mysqld3306

systemctl start mysqld3306

3.主从1：mysql01 -> mysql02

#mysql01

GRANT REPLICATION SLAVE ON *.* TO'repl1'@'%' IDENTIFIED BY '123';

#mysql02

change master to

master_host='192.168.10.161',

master_port=3306,

master_user='repl1',

master_password='123',

master_auto_position=1;

start slave；

4.主从2：mysql02 -> mysql01

#mysql02

GRANT REPLICATION SLAVE ON *.* TO'repl2'@'%' IDENTIFIED BY '123';

#mysql01

change master to

master_host='192.168.10.162',

master_port=3306,

master_user='repl2',

master_password='123',

master_auto_position=1;

start slave;

5.安装keepa