BackupPC-users

Re: [BackupPC-users] Problems with hardlink-based backups...

2009-09-01 13:19:40
Subject: Re: [BackupPC-users] Problems with hardlink-based backups...
From: Les Mikesell <lesmikesell AT gmail DOT com>
To: "General list for user discussion, questions and support" <backuppc-users AT lists.sourceforge DOT net>
Date: Tue, 01 Sep 2009 12:15:34 -0500
Jeffrey J. Kosowsky wrote:
> 
>  > > Name the top 10 that worry you most so that I can get a feeling for
>  > > how hard they are to solve. Again, I can't address a generic fear.
>  > 
>  > 1) you've run out of disk space, corrupting the database
> Would cause similar problem with current implementation - such that
> either attrib files not created or links not created between pc and
> pool trees or only partial files transferred.

But it doesn't break/disassociate your view of what you have or don't have.

> Similar solution would
> be to have a variable like current DfMaxUsagePct to make sure that
> backup doesn't run (or stops gracefully) if filesystem close to
> full.

But now you also need to know what filesystem(s)hold the database tables 
- if they are on the same machine where you can even check.

  Also, all databases need to deal with such issues so it is
> hardly a new problem without reasonable solution.

It's not a new issue for experienced DBA's.  Some of them might even 
know how to recover a corrupted database.  But it's a new problem for 
backuppc users.

>  > 2) you lose power/crash while expiring
> This would just mean that expiry not completed meaning that some
> expired files not deleted. Same problem occurs if power/crash during
> BackupPC_Nightly. The actual deletion is atomic. Just run expiry again.

The actual deletion can't be atomic - you have to one thing in the 
database and one thing in the filesystem.

> Interestingly, though you don't list the one issue that could be more
> of a fundamental problem which is that a major database corruption
> could lose your entire backup database.

That was the point of #1.  Anything that lets the db become different 
than the filesystem means it won't work or won't be able to restore what 
you think you have.

-- 
   Les Mikesell
    lesmikesell AT gmail DOT com



------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
BackupPC-users mailing list
BackupPC-users AT lists.sourceforge DOT net
List:    https://lists.sourceforge.net/lists/listinfo/backuppc-users
Wiki:    http://backuppc.wiki.sourceforge.net
Project: http://backuppc.sourceforge.net/