mysql-multi source replication 配置

最新推荐文章于 2022-12-28 10:58:57 发布

weixin_34001430

最新推荐文章于 2022-12-28 10:58:57 发布

阅读量85

点赞数

文章标签：数据库

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