本帖最后由 royzs 于 2016-10-21 10:47 编辑
my.cnf主的是这样的
server-id=1
log-bin=mysql-bin
relay-log = relay-mysql
relay-log-index = relay-mysql.index
binlog-do-db=db
binlog-ignore-db=mysql
replicate-do-db=db
replicate-ignore-db=mysql
log-slave-updates
slave-skip-errors=all
auto_increment_increment=2
auto_increment_offset=1
从的内容是
server-id=2
log-bin=mysql-bin
relay-log = relay-mysql
relay-log-index = relay-mysql.index
binlog-do-db=db
binlog-ignore-db=mysql
replicate-do-db=db
replicate-ignore-db=mysql
log-slave-updates
slave-skip-errors=all
auto_increment_increment=2
auto_increment_offset=2
两边同步的账户使用的是
grant replication slave,file,select on *.* to 'db'@'10.0.0.%' identified by '111111';
但是我在主的和从的create database都不同步,两边查看show processlist; 查看master status和slave status都正常,
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
求助,急急急
|