先修改Master(10.1.123.197)的 my.cnf 配置
在[mysqld]中新增以下内容log-bin=mysql-binlog-bin-index=mysql-bin.indexserver-id = 1sync_binlog=1binlog_format=mixed
然后指定要做同步的数据库,并忽略掉不需要做同步的数据库
binlog-do-db =testdb
binlog-ignore-db =mysql
binlog-ignore-db =performance_schema
binlog-ignore-db =information_schema
在[mysqldump]中修改内容为
max_allowed_packet=32M
注意:确保 max_allowed_packet 有比较大的值,比如 max_allowed_packet=100M
重启 mysql
service mysql restart
在Master上创建一个复制用户CREATE USERfunsion;GRANT REPLICATION SLAVE ON *.* TO funsion IDENTIFIED BY 'ifunsion.com';
# 测试环境密码是 xyzzy+ ---------------------------------------------------------- + 再修改 Slave(10.1.123.160)的配置,修改 my.cnf
在[mysqld]中新增以下内容
server-id=2 log-bin = mysql-bin
relay-log-index = slave-rela