首页 > 代码库 > mysql-multi source replication 配置

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;

 

mysql-multi source replication 配置