windows下mysql双向同步

时间:2017-01-16 08:03:29
【文件属性】:
文件名称: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

网友评论