手把手教你在Mysql5.7中搭建主从复制

#/usr/local/mysql/bin 关闭实例

./mysqladmin -uroot -p -P3307 -h127.0.0.1 shutdown

./mysqladmin -uroot -p -P3306 -h127.0.0.1 shutdown

#新加的配置

log-bin=mysql-bin       #表示启用二进制日志

server-id=3307      #表示server编号，编号要唯一 建议和端口保持一致

./mysqld_safe --defaults-file=/usr/local/mysql/data/3306/my.cnf &

./mysqld_safe --defaults-file=/usr/local/mysql/data/3307/my.cnf &

#在/usr/local/mysql/bin目录下执行

 ./mysql -uroot -p -P3306 -h127.0.0.1

 grant replication slave on *.* to 'copy'@'%' identified by 'root';

# mysql主服务器默认初始值：

#           File：mysql-bin.000001

#           Position：154

show master status;

reset master;

#在/usr/local/mysql/bin目录下执行  多台从机‘|’分隔

./mysql -uroot -p -P3308|3309|3310 -h127.0.0.1

stop slave;     #停止复制，相当于终止从服务器上的IO和SQL线程

reset slave;

change master to

master_host='主机ip',master_user='copy',

master_port=主机端口,master_password='连接主机密码',

master_log_file='mysql-bin.000001',master_log_pos=154;

start slave;

show slave status \G;

stop slave;

set global sql_slave_skip_counter =1;

start slave;

show slave status\G;

slave-parallel-type=LOGICAL_CLOCK

slave-parallel-workers=16

master_info_repository=TABLE

relay_log_info_repository=TABLE

relay_log_recovery=ON