KavehSadeghiGarmaroudi
4/27/2019 - 1:09 PM

replication

slave
server-id=910
log-bin=mysql-bin
skip-slave-start
gtid-mode=on
enforce-gtid-consistency
log-slave-updates
replicate-do-db = test
replicate-do-db = gensec
replicate-do-db = amadeus
replicate-do-db = mahan
replicate-do-db = transport
#replicate-do-db = gensec
slave-skip-errors = 1418,1305


master
server-id=900
log-bin=mysql-bin
#bind-address = 192.168.2.33
binlog-do-db = gensec
binlog-do-db = transport
binlog-do-db = amadeus
binlog-do-db = mahan
binlog-do-db = test
gtid-mode = on
enforce-gtid-consistency
log-slave-updates


change
change master to master_host='192.168.2.33',  master_user='root',  master_password='sys',  master_auto_position=1;
change master to master_host='192.168.2.231',  master_user='root',  master_password='sys',  master_auto_position=1;