当前位置：Gxlcms >
数据库问题 >
mysql-multi source replication 配置
mysql-multi source replication 配置
时间：2021-07-01 10:21:17
帮助过：18人阅读
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 配置
标签：use replicat blog log bsp thread class start mysq
