[linux-lvm] snapshot questions

[Kenny Gorman]

Kyle,

I have the opposite opinion as Jesus.  File system level backups are the
way to go.  Maybe not on Linux (because of the robustness of the
snapshot facility), but for sure using Veritas.  See, file system level
database backups are fast, scalable, and simple.  However, if you can
not count on the data consistency, then I would agree with Jesus.

My personal opinion (as a DBA), is that the simplest approach to backup
and recover is best.  If you cant do the restore at 3:00am with one eye
closed and make 0 mistakes, then it's not worth it (that why I dont use
Oracle RMAN).  I use snapshots (Veritas/Sun) for backups of my
production DB's.  It's really nice to not to ever worry about a backup
window, just backup whenever!

That said, I am _evaluating_ how good Linux/LVM backups are in this
regard.  So far, it's been fine.  Also, as always, make sure you are, or
have a good DBA around. 8-)

2.5 cents.

Kenny Gorman
DBA
Kenamea


-----Original Message-----
From:	Jesus Manuel NAVARRO LOPEZ
Sent:	Fri 11/2/2001 10:52 AM
To:	linux-lvm at sistina.com
Cc:	
Subject:	Re: [linux-lvm] snapshot questions

Hi, Kyle:

Kyle Hayes wrote:
> 
> We are considering using LVM to do database snapshots for backups.
> 

It's so rare the case where this approach really works that it doesn't
even deserve to be taken into consideration, so: DON'T EVER BACKUP A
DATABASE THROUGH FILESYSTEM UTILITIES.  The database has for sure
methods to achieve this goal: use them.
-- 
SALUD,
Jesús
***
jesus_navarro at promofinarsa.es
***

_______________________________________________
linux-lvm mailing list
linux-lvm at sistina.com
http://lists.sistina.com/mailman/listinfo/linux-lvm
read the LVM HOW-TO at http://www.sistina.com/lvm/Pages/howto.html



-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 3475 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/linux-lvm/attachments/20011102/25bd5b46/attachment.bin>