By the full octave on

Hi guys,

I'm new to Drupal and I have looked through the forums/handbook for this and couldn't find anything relevent.

What I'm trying to do is;

(a) Setup a mirror of a Drupal site on a second host so if something goes wrong with the first (primary) host, I can simply switch servers (change the Name Servers to point to the secondary/backup host)

As a test, I've installed Drupal 4.6.6 and the dba.module to do automatic backups of the database and I'm manually doing daily backups of the files/folders. That's okay and it works but I would love to automate the process if possible.

For example, when I'm injecting the database on the secondary host, I have to manually split the database into chunks less than 1mb.

I've googled and found a thing called big dump which looks promising, but, I was just wondering if any other drupal users have come up with a way to automatically update a mirror site, let's say twice a day.

Thanks in advance for any links or guidance.

Paul

⋅ Categories: Drupal 4.5.x or older, Drupal 4.6.x, Drupal 4.7.x

Comments

Dublin Drupaller’s picture

Dublin Drupaller commented

hi.

Crackerjm has posted a 4.6 replication patch at the following link which might help.

http://cvs.drupal.org/viewcvs/drupal/contributions/sandbox/crackerjm/rep...

Have a look at the readme.txt for more info.

Dub

Currently in Switzerland working as an Application Developer with UBS Investment Bank...using Drupal 7 and lots of swiss chocolate

the full octave’s picture

the full octave commented

thanks Dub.

"replication" is the search string I should have been looking for.

Thanks

Paul

-----------------------------------------------
Graphic Designer.
New to Drupal and loving it large.

hammerFar’s picture

hammerFar commented

I haven't tried with Drupal yet, but with other MySQL based sites (WordPress, vBulletin) I use SQLyog Job Agent (SJA) 5.02 for Linux which can be downloaded from here:

http://www.webyog.com/sqlyog/download_sja.html

This Linux version is free to use - please notice, this is not advanced replication, but even so, simple "two-face" mirroring can be used.

For simple flat-file mirroring, wget suits my needs.

grcm’s picture

grcm commented

You can keep the files synchronised quite easily- a bit of scripting and version control/rsync/cpio.

However, you will have more difficulty keeping your DBs replicated and up to date. The easiest thing to do is bite the bullet and either have a static mirror site for emergencies or be prepared for your mirror to be slightly out of data.

Make sure you know why/when you need a mirror. For emergencies? Do you REALLY need full replication? How fast does the mirroring need to be? NB DNS lifetimes. Active/active or active/passive?

-- Version Control your Drupal web site with The File High Club. Free Trial!