##主库1建立通道1
change master to
master_host='',
master_port=3306,
master_user='',
master_password='',
master_log_file='',
master_log_pos=
for channel 'master_1';##主库2建立通道2
change master to
master_host='',
master_port=3306,
master_user='',
master_password='',
master_log_file='',
master_log_pos=
for channel 'master_2';
启动主从
##启动两个主库###启动从库###启动全部start slave all;###按通道启动start slave for channel 'master_1';start slave for channel 'master_2';###停止
stop slave for channel 'master_1';
stop slave for channel 'master_2';##查看状态
show slave status for channel 'master_1';
show slave status for channel 'master_2';###重置
reset slave all;
reset slave for channel 'master_1';