Difference between revisions of "SAC:Backups"

From OSGeo
Jump to navigation Jump to search
Line 41: Line 41:
 
==== Backup Folders / Files ====
 
==== Backup Folders / Files ====
 
Please list locations to be backed up here, preferably the same on both servers.  Unless we feel we can drop the service on one of them.
 
Please list locations to be backed up here, preferably the same on both servers.  Unless we feel we can drop the service on one of them.
# ...
+
# /etc - 10MB
 +
# /var/www/trac - 550MB
 +
#
  
 
=== Mysql ===
 
=== Mysql ===

Revision as of 14:56, 29 December 2007

Backups

osgeo1 (primary peer1 host)

current cron jobs for backups

/etc/cron.d/backup.cron

#### Backup cron jobs 
# min hour day month dayofweek user command
#
# 2am: Daily rsync to /home/back
05 2 * * * root /root/scripts/daily.sh
# Every 3 hours 
# /etc/mysql-zrm
#33 */3 * * * root /usr/bin/rsync -a --delete /etc/mysql-zrm/ /home/back/etc/mysql-zrm/
# /var/lib/mysql-zrm
#34 */3 * * * root /usr/bin/rsync -a --delete /var/lib/mysql-zrm/ /home/back/mysql-zrm/
# call backup_trac_svn.sh to backup 
# subversion /var/www/svn/repos
# trac /var/www/trac
45 */3 * * * root /root/scripts/backup_svn_incremental.sh
#45 */3 * * * root /root/scripts/trac_backup.pl
#45 */3 * * * root /root/scripts/backup_trac_svn.sh
# Thisdoes some hourly drupal/mysql optimization
39 * * * * root /root/scripts/drupal_cron.sh

backup script are in /root/scripts

backup_svn_incremental.sh runs every 3 hours and only dumps what has changed in the repository in the last three hours to /home/back/svn_backup/project/incremental

backup-svn_full.sh runs once a day at 1 am and does a 'svnadmin hotcopy' of the repository in /home/back/svn_backup/project/full. 14 copies of the repository are kept.

When adding a new svn repository, make sure to edit both the _full and _incremental scripts to add backups for your projects. You will also have to create the /home/back/svn_backup/project/{full,incremental} directories or the scripts will not work. rsync_back rsyncs www.osgeo.org/home/back with test.osgeo.net/home/back (the second PEER1 server)

Daily PEER1 Backup

PEER1 hosting service is doing daily tape backup of entire system using their SANS infrastructure.

  • This is a service we pay for on both osgeo1 and osgeo2. Do we need it on both?
  • At present it is backing up the complete file systems on both servers. We must provide them some direction as to the folders to include or exclude, so we maintain a reasonable sized backup. We then send them the list through their support ticket system.

Backup Folders / Files

Please list locations to be backed up here, preferably the same on both servers. Unless we feel we can drop the service on one of them.

  1. /etc - 10MB
  2. /var/www/trac - 550MB

Mysql

MySQL is being backed up using MySQL-zrm

osgeo2 (test.osgeo.net)

  • Daily PEER1 Backup above also applies

download.osgeo.org

As noted in Download Server the contents of download.osgeo.org are rsync'ed to osgeo2.