首页 > 技术文章 > mysql-multi source replication 配置

JiangLe 2017-03-11 22:07 原文

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';

 

推荐阅读