日期:2014-05-16 浏览次数:20980 次
一、先修改服务器的配置文件 ?????? 1、Master服务器配置简单,修改my.cnf为: server-id?????? = 1 log-bin=n01-bin relay-log=ns01-relay-bin set-variable=binlog-ignore-db=mysql 2、slave1的配置加入 master-host = 172.16.20.135 master-user = rep master-password = cnrep master-port = 3306 server-id?????? = 2 log-bin=n01-bin log-slave-updates
replicate-ignore-db=mysql