mysql内网数据库主从配置

一：内网数据库

grant all privileges on *.* to hk@"%" identified by "hk@test";

flush privileges;

GRANT REPLICATION SLAVE ON *.* to 'repl'@'%' identified by 'repl123';

flush privileges;

stop slave;

change master to master_host='192.168.0.35',master_user='repl',master_password='repl123',master_log_file='binlog.000004',master_log_pos=669;

start slave;

show slave status\G;

#skip err

slave-skip-errors=1062,1053,1146,1590

stop slave;

change master to master_host='10.0.0.64',master_user='repl',master_password='repl123',master_log_file='binlog.000175',master_log_pos=225250971;225992403

start slave;

stop slave;

change master to master_host='10.0.0.51',master_user='repl',master_password='repl123',master_log_file='binlog.000228',master_log_pos=28149251;

start slave;

change master to master_host='192.168.0.227',master_user='repl',master_password='repl123',master_log_file='binlog.000036',master_log_pos=0;

二：假期访问

linux : ping -s 100 11.74.180.98

windows: ping -l 100 11.74.180.98

在家里想直接访问 发布机，连接阿里云服务，先进行上面的操作，就可以通过

11.74.180.98：9055 连上服务器。