主主模式:
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
character-set-server=utf8
max_connections=10000
lower_case_table_names=0
max_allowed_packet = 32M
skip-name-resolve
wait_timeout=31536000
interactive_timeout=31536000
server-id=100
log-bin=mysql-bin
auto-increment-increment= 2
auto-increment-offset = 1
log-slave-updates = true
read-only=0
binlog-ignore-db=mysql
binlog-ignore-db=information_schema
binlog-ignore-db=performance_schema
另外一台不一样的地方
server-id=101
auto-increment-offset = 2
2、授权
grant replication slave on *.* to 'root'@'192.168.198.110' identified by '123456';
flush privileges;
grant replication slave on *.* to 'root'@'192.168.198.112' identified by '123456';
flush privileges;
3、添加主库
对方先执行:show master status;
己方执行:change master to master_host='192.168.198.110',master_port=3306,master_user='root',master_password='123456',master_log_file='mysql-bin.000001',master_log_pos=613;
start slave;
show slave status;\G