Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 2 down vote accepted

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)

Here's how to set up an OpenVPN

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

share|improve this answer

are you just looking for backups or an actual mysql server running elsewhere?

DKNuckles answer is right on the $money...

However -If it is just backups - a simple backup script (free) might work well for you A great script from which takes daily, weekly and monthly backups of your MySQL databases using mysqldump. Features - Backup mutiple databases - Single backup file or to a seperate file for each DB - Compress backup files - Backup remote servers - E-mail logs and much more...

keep in mind - RUNNING BACKUPS IS A GREAT IDEA :-) as issues such as mysql data loss from human error, programming error etc would replicate across the vpn / cluster as well

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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