MySQL5.7多源复制的实验

MySQL5.7多源复制的实验

node1: 192.168.2.171     master1

node2: 192.168.2.172     slave

node3: 192.168.2.170     master2

node2上执行：

change master to

master_host='192.168.2.171',

master_user='rpl',

master_password='Abcd@1234',

master_port=3306,

master_log_file='mysql-bin.000001',

master_log_pos=4 for channel 'master-1';

change master to

master_host='192.168.2.170',

master_user='rpl',

master_password='Abcd@1234',

master_port=3306,

master_log_file='mysql-bin.000001',

master_log_pos=12 for channel 'master-2';

启动：

start slave for channel 'master-1';

start slave for channel 'master-2';

查看状态：

show slave status for channel 'master-1'\G

show slave status for channel 'master-2'\G

停止：

stop slave for channel 'master-1';

stop slave for channel 'master-2';

清空同步信息和日志：

reset slave for channel 'master-1';

reset slave for channel 'master-2';

刷下relaylog：

flush relay logs for channel 'master-1';

flush relay logs for channel 'master-2';

亿速云「云数据库 MySQL」免部署即开即用，比自行安装部署数据库高出1倍以上的性能，双节点冗余防止单节点故障，数据自动定期备份随时恢复。点击查看>>