![](http://static.blog.csdn.net/images/category_icon.jpg)
版权声明:本文为博主原创文章,未经博主允许不得转载。
开始之前请先阅读单项主从复制: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)
- [mysqld]
- # for repl
- server-id = 135
- log-bin = mysql-bin
- [mysqld]
- # for repl
- server-id = 35
- log-bin = mysql-bin
主库:192.168.2.35 从库:192.168.2.135
4.指定服务器二mysql为服务器一mysql的主库(在服务器二mysql中为服务器一mysql设置权限):
- GRANT REPLICATION SLAVE,RELOAD,SUPER ON *.* TO root@'192.168.2.135' IDENTIFIED BY '******';
- show MASTER STATUS
- stop SLAVE
- CHANGE MASTER TO master_host = '192.168.2.35',
- master_port=3307, #这里是要连接主库(192.168.2.35)的端口号,默认是3306,如果你的主库端口不是3306则要加上这一行
- master_user = 'root',
- master_password = '******',
- master_log_file = 'mysql-bin.000001',
- master_log_pos = 3870;
- START SLAVE
- show SLAVE STATUS
主库:192.168.2.135 从库:192.168.2.35
- GRANT REPLICATION SLAVE,RELOAD,SUPER ON *.* TO root@'192.168.2.35' IDENTIFIED BY '******';
- RESET MASTER
- show MASTER STATUS
- stop SLAVE
- CHANGE MASTER TO master_host = '192.168.2.135',
- master_user = 'root',
- master_password = '******',
- master_log_file = 'mysql-bin.000001',
- master_log_pos = 1888;
14.开启服务器二mysql的slave:
- START SLAVE
- show SLAVE STATUS