这是相关的配置
server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 7
max_binlog_size = 10G
binlog_do_db = db1,db2,db3,db4 ....
binlog_ignore_db = information_schema,mysql,dbA,dbB,dbC
server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 7
max_binlog_size = 10G
binlog_do_db = db1,db2,db3,db4 ....
binlog_ignore_db = information_schema,mysql,dbA,dbB,dbC
server-id = 1
log-bin=/usr/local/mysql/var/mysql-bin.000001
#binlog-do-db = zabbix
binlog-ignore-db = mysql
binlog-ignore-db = test
binlog-ignore-db = information_schema
mysql>grant replication slave on *.* to 'rep'@'%' identified by 'password'; #授权用户
mysql> show master status\G; #binlog-id,pos号码
File: mysql-bin.000011
Position: 490
2 slave 端
my.conf #编辑my.cnf
server-id = 2
mysql>change master to master_host='192.168.56.10',master_user='rep',master_password='password',master_log_file='mysql-bin.000011',master_log_pos=490;
mysql> start slave;
mysql> show slave status\G;
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
replicate-wild-do-table=dbname.%
replicate-wild-ignore-table=dbname.%
这样可以解决跨库更新时,不同步复制的问题。