mysql5.7主从复制遇到的坑
datadir=/var/lib/mysqlsocket=/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]