我的两台主机分别为:
hadoop103 192.168.93.133
hadoop104 192.168.93.134
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
- hadoop104 的配置文件
[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
log-error=/usr/local/mysql/log/mysql.log
user=mysql
port = 3306
socket