[SAC] Backups - Especially osgeo1 Mysql for Drupal

Tyler Mitchell (OSGeo) tmitchell at osgeo.org
Wed Dec 12 12:23:18 EST 2007

Please note also that we have a few databases to remove from our  
mysql instance, since things were rearranged during the drupal  
upgrade.  Wolf and I will be working on this - that should help  
reduce some of the size of the mysql backups too.


On 12-Dec-07, at 7:25 AM, Frank Warmerdam wrote:

> Folks,
> I did a bit of a skim of our backups on osgeo1, and I'm not seeing any
> current backups being done for the mysql databases.  These are most  
> obviously
> used for the Drupal instances (osgeo, grass, fdo and mapguide).  It  
> seems there
> was some sort of zrm (Zmanda) backups being done for mysql at one  
> point, but
> it seems it was commented out of /etc/cron.d/backup.cron at some  
> point.
> It is a bit hard to figure out what is what with regard to backups,  
> so I have
> taken the liberty of extracting the backup portion out of the  
> Migration
> Documentation wiki page Shawn wrote, and setting it up as SAC:Backups:
>   http://wiki.osgeo.org/index.php/SAC:Backups
> I also updated it slightly, and referenced it from the SAC Service  
> Status
> page.
> I have taken the liberty of filing a ticket on the mysql backup issue.
> Shawn - perhaps you would be willing to get the zrm stuff going again
> and confirm the backups are solid?
> In general I think our backup handling is lax/confused/unmonitored and
> a review would be good.  The wiki is an example of an important  
> service
> that is not being backed up as far as I know.
> Best regards,
> -- 
> --------------------------------------- 
> +--------------------------------------
> I set the clouds in motion - turn up   | Frank Warmerdam,  
> warmerdam at pobox.com
> light and sound - activate the windows | http://pobox.com/~warmerdam
> and watch the world go round - Rush    | President OSGeo, http:// 
> osgeo.org
> _______________________________________________
> Sac mailing list
> Sac at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/sac

Tyler Mitchell
Executive Director
Open Source Geospatial Foundation
tmitchell at osgeo.org
P: +1-250-277-1621
M: +1-250-303-1831

More information about the Sac mailing list