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 have a wordpress blog that is currently residing on a server (VPS) in UK and I would like to set up an identical server (same specs, same OS - Ubuntu) for some sort of redundancy as well as fail-safe.

I know it is possible to set up rSync + Cron for content replication and MySQL Master-Master replication for DB, however honestly after spending the whole night trying to configure the MySQL replication, I am really reluctant to continue any further.

Therefore, is there any solution that is sort of pre-pacakged that I can just run to achieve the kind of set up I need? I have root access to both VPS.

Thanks in advance!

share|improve this question
    
Why do you need master-master schema? –  zerkms May 14 '11 at 0:58
    
because I was hoping that someone visiting my website in US would be going to US server and visiting in EU would be using UK server... –  zhuanyi May 14 '11 at 1:06
add comment

3 Answers 3

up vote 0 down vote accepted

First, I think you are starting at the wrong level. Are there any tools at the application (wordpress) level? Maybe something like http://wordpress.org/extend/plugins/copy-post/ would work. Otherwise there seem to be some OK hits when I searched for "sync wordpress blog" or "replicate wordpress blog."

Second, I wouldn't do multi-master replication. I'd create a slave mysql installation. Point both wordpress installations at the master. If the master fails then promote the slave to master. The wordpress installation that doesn't use the local DB would be slower, maybe unacceptably slow.

Third, though these techniques provide redundancy (availability) they do not provide fail-safe (backup). E.g., if you accidentally deleted a post on one installation the post would be deleted on the other.

share|improve this answer
    
That looks more like a master-slave replication set up though rather than a master-master replication...but I will give that a shot and will keep everyone posted, thanks! –  zhuanyi May 15 '11 at 4:16
add comment

you can replicate your Wordpress files and DB and then handle traffic with a smart DNS system such as http://www.gslb.me

share|improve this answer
add comment

Just do master/slave replication plus rsync and point all traffic to your master side.

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.