开始之前请先阅读单项主从复制: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 =