1、主库
设置my.cnf
server_id = 2 必须唯一
binlog-do-db = abo-assist 备份的数据库
log-bin=mysql-bin 开启binlog
创建同步账号并授权
grant replication slave on *.* to 'replication'@'%' identified by '123456';
2、从库
server_id = 10 必须唯一
3、开启主从同步(从库上操作)
mysql> stop slave;
mysql>change master to master_host='192.168.190.131',master_user='replication',master_password='123456',master_port=3336,master_log_file='mysql-bin.000002',master_log_pos=120;
mysql> start slave;
备注
清除从库日志
mysql>show slave status\G (查看从库备份状态)
mysql>reset master
mysql访问外部地址
myql -h -u -p
文章来源: www.oschina.net,作者:abowu,版权归原作者所有,如需转载,请联系作者。
原文链接:https://my.oschina.net/u/585210/blog/3105304