mysql5.7主从复制遇到的坑

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
replicate-do-db=shopping
binlog-do-db=shopping #复制的库
server-id = 3
#skip-grant-tables = 1
symbolic-links=0
replicate-do-db=shop #需要复制的库
binlog-do-db=shop 
tmpdir = /tmp #这个最好给个目录 否则会报错 ，今天遇到了
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
max_connections = 1000
binlog-ignore-db=mysql 
binlog-ignore-db=test
binlog-ignore-db=information_schema
binlog-ignore-db=performance_schema #不复制的库

replicate-ignore-db=test
replicate-ignore-db=mysql
replicate-ignore-db=information_schema
replicate-ignore-db=performance_schema#不复制的库

validate_password=off #禁用密码策略，否则会很麻烦

本文转自 小小三郎1 51CTO博客，原文链接：http://blog.51cto.com/wsxxsl/2047409，如需转载请自行联系原作者