mysql5.7主从复制遇到的坑

yyert

                                                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  #禁用密码策略，否则会很麻烦

                                       

yyfq521

yyfq521

ignore-db 要分开写吗？ 多个库不能分隔一起写吗？

还有你的binlog 模式是哪种的呢？