mysql加入新的从节点怎么配置_添加MySQL 5.6 从节点 Slave

mysql版本：5.6.36

xtraback版本：version 2.4.6

1、修改主节点MySQL配置文件，并重启MySQL

cat /usr/local/mysql/my.cnf

[mysqld]

datadir = /var/lib/mysql

socket = /tmp/mysql.sock

binlog-format=ROW

log-slave-updates=true

gtid-mode=on

enforce-gtid-consistency=true

log-bin=mysql-bin

expire_logs_days=2

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

port=3306

server_id = 1

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

2、使用xtrabackup全备MySQL，并将备份集拷贝到从节点

innobackupe