MySQL 互主复制 设置
时间:2021-07-01 10:21:17
帮助过:22人阅读
授权 172.16.1.10 权限grant replication slave on *.* to ‘slave‘@‘172.16.1.11‘ identified by ‘king123‘;[mysqld]log-bin=aaa_10server-id=1master-host=172.16.1.11master-user=slavemaster-password=king123auto-increment-increment=2auto-increment-offset=1
主MySQL服务器 172.16.1.11授权172.16.1.10 权限grant replication slave on *.* to ‘slave‘@‘172.16.1.10‘ identified by ‘king123‘;[mysqld]log-bin=bb_11server-id=2master-host=172.16.1.10master-user=slavemaster-password=king123auto-increment-increment=2auto-increment-offset=2本文出自 “小郑技术博客” 博客,请务必保留此出处http://ko178.blog.51cto.com/220419/1765213
MySQL 互主复制 设置
标签:identified 服务器 mysql