2016-03-28 07:22:06 |
OrNix |
description |
Server version: 5.7.11-4 Percona Server (GPL), Release 4, Revision 5c940e1
Centos 6.7 x64.
CHANGE MASTER TO
MASTER_LOG_FILE='binlog.023161',
MASTER_LOG_POS=259419561,
MASTER_HOST='10.1.0.40',
MASTER_PORT=3306,
MASTER_USER='repl',
MASTER_PASSWORD='XXXXXX'
FOR CHANNEL 'wm2';
CHANGE MASTER TO
MASTER_LOG_FILE='bin.000012',
MASTER_LOG_POS=210950653,
MASTER_HOST='10.1.0.37',
MASTER_PORT=3306,
MASTER_USER='repl',
MASTER_PASSWORD='XXXXXX'
FOR CHANNEL 'yml';
In SHOW SLAVE STATUS both channels have Channel_Name: wm2. All the reset rows like Master_Host, positions are valid and different for both channels. |
Server version: 5.7.11-4 Percona Server (GPL), Release 4, Revision 5c940e1
Centos 6.7 x64.
CHANGE MASTER TO
MASTER_LOG_FILE='binlog.023161',
MASTER_LOG_POS=259419561,
MASTER_HOST='10.1.0.40',
MASTER_PORT=3306,
MASTER_USER='repl',
MASTER_PASSWORD='XXXXXX'
FOR CHANNEL 'wm2';
CHANGE MASTER TO
MASTER_LOG_FILE='bin.000012',
MASTER_LOG_POS=210950653,
MASTER_HOST='10.1.0.37',
MASTER_PORT=3306,
MASTER_USER='repl',
MASTER_PASSWORD='XXXXXX'
FOR CHANNEL 'yml';
In SHOW SLAVE STATUS both channels have Channel_Name: wm2. All the rest rows like Master_Host, positions are valid and different for both channels. |
|