mysql笔记二：MYSQL主从复制（GTID）

一、主服务器配置（172.16.1.61）

1、配置mysql配置文件

[mysqld]
binlog-format=row
log-bin=master-bin
log-slave-updates=true
gtid-mode=on
enforce-gtid-consistency=true
master-into-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
server-id=1
report-port=3306

2、登录mysql，创建复制用户

<mysql>grant replcate slave on *.* to 'repluse'@'172.16.1.62' identified by '123456';

二、从服务器配置（172.16.1.62）

1、配置mysql配置文件

[mysqld]
binlog-format=row
log-slave-updates=true
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
server-id=11
report-port=3306

2、启动从节点复制线程

<mysql>change master to master_host='172.16.1.61',
master_user='repluse',
master_password='123456',
master_auto_position=1;