[Gllug] Tape backups

[Dagfinn Ilmari Mannsåker]

Gordon Joly <gordon.joly at pobox.com> writes:

> 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?

No need, just make sure the files are consistent on disk when you take
the snapshot using FLUSH TABLES WITH READ LOCK before taking the
snapshot, then UNLOCK TABLES immediately afterwards.

-- 
ilmari
"A disappointingly low fraction of the human race is,
 at any given time, on fire." - Stig Sandbeck Mathisen
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug