日期:2014-05-16  浏览次数:20858 次

mysql mysql 主从配置

一、先修改服务器的配置文件

?????? 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

replicate-do-db =mydns
replicate-ignore-db=mysql

log-slave-updates