Hello.

I have two mysql servers. One is master and the other one exact replica. I need to setup a VPN connection between the two. I looked at poptop VPN solution and it seems like something I could use.

My question is:
- when I'll get one of the machines set up as a VPN server what should I use to establish VPN connection between the two when replica connects to master to get the data?

Distro used is Fedora Core 6


Thank you for your time.

The concept of a VPN is that all machine connected to a VPN appear to have open connections to each other. Like they are connected to each other thru routers without any restrictions or protection. But the restrictions are only lifted from one machine to the other, from other machines not connected to the VPN or the VPN gateway there is a protection, there is no security breach.

So if you have your client and server set up as 192.168.0.10 and 192.168.20.10, you can freely communicate with the two.

You can happily dump the database from 192.168.0.10 to 192.168.20.10 as if the machine were on the same LAN.

Now I have this experience with OpenVPN, not with poptop. OpenVPN requires that the subnets on both sides are different, but routes to get from one to the other subnet are set up automatically.

jlinkels