使用gtid (也需要开启binlog日志)
CHANGE MASTER TO MASTER_HOST=’192.168.95.11’, MASTER_USER=’mysql12’, MASTER_PASSWORD=’mysql12’,MASTER_AUTO_POSITION = 1;
使用binlog
CHANGE MASTER TO MASTER_HOST=’192.168.95.12’, MASTER_USER=’mysql11’, MASTER_PASSWORD=’mysql11’, MASTER_LOG_FILE=’mysql-bin.000084’, MASTER_LOG_POS=107;