mysql 双机热备 主主同步 (互为主从) 深碍√TFBOYSˉ_ 2022-06-08 10:36 486阅读 0赞 # [windows操作系统下mysql双向同步复制(互为主从)][windows_mysql] # 标签: [mysql][][mysql双向主从复制][mysql 1][mysql主从复制配置][mysql 2][服务器][Link 1] 2016-09-26 08:59 1140人阅读 [评论][Link 2](0) 收藏 [举报][Link 3] ![category_icon.jpg][] 分类: mysql(2) ![arrow_triangle_20_down.jpg][] 数据库(1) ![arrow_triangle_20_down.jpg][] 版权声明:本文为博主原创文章,未经博主允许不得转载。 开始之前请先阅读单项主从复制:[http://blog.csdn.net/qq\_26790735/article/details/52638110][http_blog.csdn.net_qq_26790735_article_details_52638110] 前期准备相同...... 1.在两台服务器上安装mysql(版本必须一致) 服务器一:192.168.2.135 端口号:3306 服务器二:192.168.2.35 端口号:3307 2.修改服务器一mysql的配置文件(my.ini) 1. \[mysqld\] 2. \# for repl 3. server-id = 135 4. log-bin = mysql-bin 3.修改服务器二mysql的配置文件(my.ini) 1. \[mysqld\] 2. \# for repl 3. server-id = 35 4. log-bin = mysql-bin 主库:192.168.2.35 从库:192.168.2.135 4.指定服务器二mysql为服务器一mysql的主库(在服务器二mysql中为服务器一mysql设置权限): 1. GRANT REPLICATION SLAVE,RELOAD,SUPER ON \*.\* TO root@'192.168.2.135' IDENTIFIED BY '\*\*\*\*\*\*'; 5.查询服务器二mysql当前状态,并记录file和position的值: 1. show MASTER STATUS 6.停止服务器一mysql的slave: 1. stop SLAVE 7.服务器一mysql连接服务器二mysql( master\_log\_file和master\_log\_pos 值为之前第5步记录的file和position的值): 1. CHANGE MASTER TO master\_host = '192.168.2.35', 2. master\_port=3307, \#这里是要连接主库(192.168.2.35)的端口号,默认是3306,如果你的主库端口不是3306则要加上这一行 3. master\_user = 'root', 4. master\_password = '\*\*\*\*\*\*', 5. master\_log\_file = 'mysql-bin.000001', 6. master\_log\_pos = 3870; 8.开启服务器一mysql的slave: 1. START SLAVE 9.查看是否连接成功(查看slave\_IO\_running和slave\_sql\_running是否为yes,若为yes则连接成功): 1. show SLAVE STATUS 主库:192.168.2.135 从库:192.168.2.35 10.指定服务器一mysql为服务器二mysql的主库(在服务器一mysql中为服务器二mysql设置权限): 1. GRANT REPLICATION SLAVE,RELOAD,SUPER ON \*.\* TO root@'192.168.2.35' IDENTIFIED BY '\*\*\*\*\*\*'; 2. RESET MASTER 11.查询服务器一mysql当前状态,并记录file和position的值: 1. show MASTER STATUS 12.停止服务器二mysql的slave: 1. stop SLAVE 13.服务器二mysql连接服务器一mysql( master\_log\_file和master\_log\_pos 值为之前第11步记录的file和position的值): 1. CHANGE MASTER TO master\_host = '192.168.2.135', 2. master\_user = 'root', 3. master\_password = '\*\*\*\*\*\*', 4. master\_log\_file = 'mysql-bin.000001', 5. master\_log\_pos = 1888; 14.开启服务器二mysql的slave: 1. START SLAVE 15.查看是否连接成功(查看slave\_IO\_running和slave\_sql\_running是否为yes,若为yes则连接成功): 1. show SLAVE STATUS [windows_mysql]: http://blog.csdn.net/qq_26790735/article/details/52667141 [mysql]: http://www.csdn.net/tag/mysql [mysql 1]: http://www.csdn.net/tag/mysql%e5%8f%8c%e5%90%91%e4%b8%bb%e4%bb%8e%e5%a4%8d%e5%88%b6 [mysql 2]: http://www.csdn.net/tag/mysql%e4%b8%bb%e4%bb%8e%e5%a4%8d%e5%88%b6%e9%85%8d%e7%bd%ae [Link 1]: http://www.csdn.net/tag/%e6%9c%8d%e5%8a%a1%e5%99%a8 [Link 2]: http://blog.csdn.net/qq_26790735/article/details/52667141#comments [Link 3]: http://blog.csdn.net/qq_26790735/article/details/52667141#report [category_icon.jpg]: /images/20220608/7d35abc1323545b185b7cece3e606c4a.png [arrow_triangle_20_down.jpg]: /images/20220608/9ae33e95b10047f7ad159f2f2e33a2b8.png [http_blog.csdn.net_qq_26790735_article_details_52638110]: http://blog.csdn.net/qq_26790735/article/details/52638110
还没有评论,来说两句吧...