0

I want to set up an Master Slave Replication between 2 different servers. The specialty is, that the Master is not allowed to talk to the slave, but the slave can talk with the master. I can not change slave to master, because the data inserted has to be on the master which can not talk (ping) with the slave. Can anyone tell me if I have to look at something when setting it up or can provide a guide which works good? Thanks in advance

  • to make sure I understand your question correctly, please correct me if I am wrong: you have two machine master and slave, master can not ping the slave, but slave can. and you want to sync the data from master to slave without changing network option. – Ahmad Abuhasna Mar 8 '17 at 15:49
  • @AhmadAbuhasna you are right, only that i can't change the network option because of security reasons – XtremeBaumer Mar 9 '17 at 7:08
  • Not that you need it at the moment, but I think "ssh forwarding" can provide the connection the other way. – Rick James Mar 12 '17 at 4:47
  • @RickJames thanks for the tip, ill have a look at it once i need it – XtremeBaumer Mar 14 '17 at 12:41
2

All that is required is for the slave to be able to establish and maintain a connection on the master's MySQL TCP port (3306 by default). There is no need for the master to be able to establish a connection to the slave. If you can telnet from the slave to port 3306 (or whatever port mysqld is running on) on the master, that should be all the networking you need.

There are a lot of guides, but the best one is the MySQL manual, see Chapter 17 Replication.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.