MySQL数据同步一主多从和一主一从原理其实是一样。
环境:
Master centos6.5 mysql5.1.71 主服务器的ip:192.168.56.201
Slave1 centos6.5 mysql5.1.711 从服务器的ip:192.168.56.202
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
#默认字符
环境:
Master centos6.5 mysql5.1.71 主服务器的ip:192.168.56.201
Slave1 centos6.5 mysql5.1.711 从服务器的ip:192.168.56.202
一master主服务器上设置:
1、防火墙打开3306端口 vi /etc/sysconfig/iptables
拷贝
-A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT
插入修改为
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
结果为
2、建立log-bin文件存放路径 mkdir -p /var/log/mysql/logbin
3、修改log-bin的拥有者 chown -R mysql:mysql /var/log/mysql
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
#默认字符