[Gllug] Tape backups

[Bruce Richardson]

On Tue, Feb 17, 2009 at 01:45:27PM +0000, John wrote:
> On Tue, Feb 17, 2009 at 01:31:26PM +0000, Bruce Richardson wrote:
> <snip> 
> > 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.
> 
> So how much difference is there between backing up the raw database
> files from /var/lib/mysql and making a mysqldump ? 
> 
> I can see that the raw files would be faster to restore, but won't
> a dump be safer, more portable and easier to find/fix errors with?

So dump the replica.  The point is that you have removed the load from
the master.

That said, since you need a snapshot of the master db to create a
replica in the first place, you could just keep that snapshot and all
the replication binlogs, since replaying those against the snapshot
should bring you up to date.  In practice, I'd want an alternative.

-- 
Bruce

Remember you're a Womble.
-------------- 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/5db628ef/attachment.pgp>
-------------- next part --------------
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug