【文件属性】:
文件名称:windows下mysql双向同步
文件大小:340KB
文件格式:DOCX
更新时间:2017-01-16 08:03:29
mysql
windows下mysql双向同步
现在给出A 的双向同步的完整配置
[mysqld]
server-id=1
log-bin=C:\log-bin.log
binlog-do-db=dn2
master-host=192.168.1.181
master-user=backup
master-password=1234
master-port=3306
master-connect-retry=60
replicate-do-db=dn2
现在给出B的,完整配置,不做解释了,根据具体情况改相应的值就可以了
[mysqld]
server-id=2
master-host=192.168.1.178
master-user=slave
master-password=1234
master-port=3306
master-connect-retry=60
replicate-do-db=dn2
log-bin=C:\log-bin.log
binlog-do-db=dn2