Re: rsync] Live DB backups with rsync?

2003-01-14 Thread R P Herrold
On Tue, 14 Jan 2003, Steve Mallett wrote:

 Is it possible to do live backups of a running DB with rsync???
 
 I was just talking to livevault.com  they (only on win boxes) say they 
 can grab changes from a client's live DB  sync them remotely.
 
 It sounded like BS to me, but I'm neither a DB guy or sync'ing expert.

I've done with unix DB, DB4, and MySQL backends [not of
choice, but sometimes, there's no other way, as when a hard
drive is dying, and you _know_ you will never be able to power
it on again ...] -- it works this way --

1.  Rsync the directory tree holding the database
2.  Re-run the command
3.  Keep re-running it, and eventually, you'll get an 
essentially immediate return with no content being moved.

... at this point stop.  You hit a time when the database was 
largely quiescent, and so was unchanged -- 

-- there will be some open locks and and open transactons will 
be lost -- but no worse than an unplanned reboot due to a 
power loss.

In a production environment, it seems to me that better ways 
usually exist.

-- Russ Herrold

-- 
To unsubscribe or change options: http://lists.samba.org/mailman/listinfo/rsync
Before posting, read: http://www.tuxedo.org/~esr/faqs/smart-questions.html



Re: rsync] Re: bug reporting.. bugzilla

2002-12-08 Thread R P Herrold
On Mon, 9 Dec 2002, Martin Pool wrote:

  - misunderstandings of how to use rsync (operator error)
  - massively incomplete reports (e.g. just it fails, without any
error message.)
  - architectural limitations (e.g. upfront scan)
  - other junk entries

 Too many people fail to realize that filing a useful bug is actuallly
 a lot of work and requires that the reporter actually put a bit of
 thought into the problem. /rant

 I think a better way go forward would be for volunteers to 
 help maintain an FAQ.

 Since new bug reports are relatively rare, but problems and
 misunderstandings seem to occur repeatedly I think this would be the
 most useful way to get all the information in one place.
 
 So who's interested in working on that? 

Really a better FAQ editor process seems more useful.  Isn't
this the purpose of a CVS and commit privileges -- set up one
or more trusted editors with rights, and delegate that aspect.  

For the last year, I have acted as editor on the RPM website;
there is also an open editorial mailing list, and provided
content (dreadfully little) gets slotted in.

I monitor all the mailing lists in the area (five primary
ones) and watch for common questions or misunderstandings
which are well answered end up summarized and on the site.  I
particularly look for the postings by the lead maintainer and
a few others for the 'nuggets' -- the answers float by and may
be picked out of the stream and tossed up on the riverbank of
a FAQ

-- Russ Herrold

-- 
To unsubscribe or change options: http://lists.samba.org/mailman/listinfo/rsync
Before posting, read: http://www.tuxedo.org/~esr/faqs/smart-questions.html