MySQL Data Replication

Question

MySQL

There is a master and slave DBMS.
Master is located in the internal network, behind the Internet modem, i.e. without external IP (and I don’t consider port forwarding from the modem).
Slave, in turn, is located on a dedicated server with a permanent IP and Internet domain.
Question how to make replication?
Now done through an internal application that actually POSTs data through a Web service on the slave's
server

Answer 1

The tailless option is an OpenVPN tunnel from the computer where the master is running to the computer where the second server is running. Then they will be in the same private network and see each other directly by IP address

Answer 2

Transfer master from under the table to foreign hosting - it will be safer and much easier.

Answer 3

It doesn't depend on the version of MySQL, that's the technology. You need a static ip and port for stable data replication.
Crutches:
1. Forward the sql port from the master to the localhost slave via ssh (do not shine the port through the modem, but tunnel it directly to the server)
2. Configure ipv6 ipv4 encapsulation

Answer 4

For a start it would be desirable to hear the purpose of replication.
Backup, load balancing?

Answer 5

It's just that the rsnik will not merge online, that is, it will be marks once every 5 minutes, for example. But in principle, if there is not much data - a normal option