[Gllug] Tape backups

[Jose Luis Martinez]

On Mon, Feb 16, 2009 at 11:28 PM, Gordon Joly <gordon.joly at pobox.com> wrote:
> At 22:20 +0000 16/2/09, James Hawtin wrote:
>>On Mon, Feb 16, 2009 at 09:10:21PM +0000, t.clarke wrote:
>>>  Our approach, on a relatively modest database, is to copy twice
>>>daily the whole
>>>  unmounted filesystem  (raw dd) to another disc partition, remount
>>>and carry on,
>>>  and then backup the disc copy to tape.  This keeps downtime to a matter of
>>>  seconds.  The tape-copies are re-read against the disc and
>>>compared to ensure
>>>  that the tape has been written OK.  On the few occasions when I have need of
>>>  some historic info the tapes have always been readable.
>>>  As the database is quite small, we also whizz the copy overnight
>>>to another box
>>>  with a DVD writer and write an ISO file as well.
>>
>>Do you make use the of lvm snapshot facility to minimise the ammount of time
>>your filesystem is unavailable?
>>
>>James
>
>
> And stop mysql?
>
> Gordo
>

Pardon my MySQL ignorance, is there no way to backup  the database
while it is live? (I have not done serious backup work for a while, I
have got the impression that Sybase and Oracle can be backed up on the
fly, am I mistaken?).
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug