Tag Archives: slave

 5.1.24版本的配置请看：http://www.masalife.com/archives/173 一、先修改服务器的配置文件        1、Master服务器配置简单，修改my.cnf为:        server-id       = 1 log-bin set-variable=binlog-ignore-db=mysql 2、slave1的配置加入 server-id       = 2 master-host = 172.16.20.135 master-user = rep master-password = cnrep master-port = 3306 log-bin set-variable=replicate-ignore-db=mysql set-variable=replicate-do-db=AliSMS set-variable=replicate-do-db=lcd set-variable=replicate-do-db=loginmanager set-variable=replicate-do-db=samis set-variable=replicate-do-db=sareport set-variable=replicate-do-db=syslog set-variable=replicate-do-db=web_speed log-slave-updates 3、slave2服务器的配置 server-id       = 3 …

Continue reading →