Best practice for setting MySQL replication over WAN

Question

I want to use MySQL replication over WAN for backup purpose.

What are the Best practice for ensuring data consistency, and without too much manual interruption?

Solution

This is how I would do it

I would set up simple MySQL replication over a VPN.

The replication process is quite simple, and you could use a utility like OpenVPN.

This is the simplest and easy way I can think of.

This is a tutorial to set up replication in Fedora 10 (the process is going to be pretty much the same) http://www.howtoforge.com/how-to-set-up-mysql-database-replication-on-fedora-10

Here's how to set up an OpenVPN http://openmaniak.com/openvpn.php

You can use a MySQL Replication Monitor to ensure the process is running as it should.