[Gllug] Tape backups

[Bruce Richardson]

On Tue, Feb 17, 2009 at 11:29:53AM +0000, John wrote:
> 
> Yes, there is mysqldump. You can run it just before the backup
> is made.
> 
> I don't know what Gordo's problem with MySQL and backups is.
> I only guess I can make is that he thinks there is a problem
> with making the MySQL backup just before taking a snapshot
> of the filesystem using lvm.
> 
> Large or busy MySQL databases could take a long time to dump,

Then don't backup the live db, use replication and backup a replica.
Then you can afford to stop the replica entirely while you take a
snapshot/dump, if you want.

-- 
Bruce

It is impolite to tell a man who is carrying you on his shoulders that
his head smells.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 204 bytes
Desc: Digital signature
URL: <http://mailman.lug.org.uk/pipermail/gllug/attachments/20090217/d9f37107/attachment.pgp>
-------------- next part --------------
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug