MySQL5.7双机---(主主热备)

我的两台主机分别为：

hadoop103 192.168.93.133

hadoop104 192.168.93.134

1.修改两台机器的配置文件

1. hadoop103 的配置文件为 （数据目录一致的话，改下 host 就能用）

[mysqld]

basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
log-error=/usr/local/mysql/log/mysql.log
user=mysql
port = 3306
socket= /tmp/mysql.sock
log-bin=/usr/local/mysql/log/binlog/mysql-bin
gtid-mode=on
enforce-gtid-consistency=true
master-info-repository=TABLE
relay-log-info-repository=TABLE
sync-master-info=1
slave-parallel-workers=2
binlog-checksum=CRC32
master-verify-checksum=1
slave-sql-verify-checksum=1
binlog-rows-query-log_events=1

report-port=3306
report-host=hadoop103  #(或者配置 192.168.93.133）

#replicate-same-server-id #主要用于同时写的情况
server_id = 1  #从写 server_id = 2
log-slave-updates
slave-skip-errors=all
auto_increment_increment=2
auto_increment_offset=1     #从写 auto_increment_offset = 2

[client]
port = 3306
socket = /tmp/mysql.sock

2. hadoop104 的配置文件

[mysqld]

basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
log-error=/usr/local/mysql/log/mysql.log
user=mysql
port = 3306
socket