1.修改配置文件
主服务器master:
[mysqld]
log-bin=mysql-bin
server-id=222
修改从服务器slave:
[mysqld]
log-bin=mysql-bin
server-id=226
重启两台服务器的mysql
2.在主服务器上建立帐户并授权slave:
GRANT REPLICATION SLAVE ON *.* to ‘son‘@‘%‘ identified by ‘a123456‘;
show master status;
记住, File,Position
3.配置从服务器Slave：
change master to master_host=‘192.168.0.113‘,master_user=‘son‘,master_password=‘a123456‘,master_log_file=‘mysql-bin.,000009‘,master_log_pos=240;
4.查看结果开启同步
Mysql>start slave;
mysql> show slave status\G