mysql-multi source replication 配置

1、关键步骤

change master to    
    master_host='172.16.192.201',
    master_port=3306,
    master_user='repl',
    master_password='123456',
    master_auto_position=1
    for channel 'master201';

start slave IO_THREAD for channel 'master201';
start slave SQL_THREAD for channel 'master201';

change master to    
    master_host='172.16.192.202',
    master_port=3306,
    master_user='repl',
    master_password='123456',
    master_auto_position=1
    for channel 'master202';

start slave IO_THREAD for channel 'master202';
start slave SQL_THREAD for channel 'master202';

 

posted on 2017-03-11 22:07  蒋乐兴的技术随笔  阅读(333)  评论(0编辑  收藏  举报

导航