Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

2 Answers 2

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) 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.

share|improve this answer
add comment

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

http://sourceforge.net/projects/automysqlbackup/ A great script from wipe_out@lycos.co.uk 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
add comment

Your Answer

 
discard

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.