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 #禁用密碼策略，否則會很麻煩