mysql-multi source replication 配置
标签：use replicat blog log bsp thread class start mysq
mysql-multi source replication 配置
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‘;