Difference between revisions of "SAC:Backups"

From OSGeo
Jump to: navigation, search
(Backup Folders / Files)
(please don't heavy-backup during European day)
Line 5: Line 5:
 
==== current cron jobs for backups ====
 
==== current cron jobs for backups ====
 
/etc/cron.d/backup.cron
 
/etc/cron.d/backup.cron
 +
 +
'''TODO''': add in which time zone cron is running? [http://www.timeanddate.com/worldclock/city.html?n=25 EST]?
 +
 +
WISH: please don't run heavy backups during European day, but preferably during Pacific Ocean day ([http://www.timeanddate.com/worldclock/meetingtime.html?month=12&day=30&year=2007&p1=770&p2=248&p3=-1&p4=-1 optimize backup time])
  
 
  #### Backup cron jobs  
 
  #### Backup cron jobs  

Revision as of 07:07, 30 December 2007

Backups

osgeo1 (primary peer1 host)

current cron jobs for backups

/etc/cron.d/backup.cron

TODO: add in which time zone cron is running? EST?

WISH: please don't run heavy backups during European day, but preferably during Pacific Ocean day (optimize backup time)

#### 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
  3. /root - 3MB
  4. /home/back/mailman - 1370MB

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.