mysql-multi source replication 配置

1、关键步骤

change master to

    master_host='172.16.192.201',

    master_port=3306,

    master_user='repl',

    master_password='',

    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='',

    master_auto_position=1

    for channel 'master202';

start slave IO_THREAD for channel 'master202';

start slave SQL_THREAD for channel 'master202';