on 2-18-2009 1:45 PM Scott Silva spake the following: > on 2-18-2009 1:36 PM Ian Forde spake the following: >> On Wed, 2009-02-18 at 15:35 -0500, Toby Bluhm wrote: >>> For a speedy backup, could put the db on LVM. Then your procedure would >>> be shutdown/freeze db, make lv snapshot, startup/unfreeze db, >>> rsync/backup data, remove snapshot. >> That's what I'd suggest too, but be warned that performance on that >> database (if gets to be of any size to be useful) would completely >> suck... not unlike driving at 90mph and with the ebrake on and >> constantly up-and-down-shifting... >> >> -I > > Would a decent alternative be a master/slave, with the dumps being done > from the slave. That way if the slave bogs down during the dump, it can catch > up afterwards. The master shouldn't slow down at all, or very minimally as it > is caching the slave transactions. > One too many "would's"... -- MailScanner is like deodorant... You hope everybody uses it, and you notice quickly if they don't!!!! -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 258 bytes Desc: OpenPGP digital signature URL: <http://lists.centos.org/pipermail/centos/attachments/20090218/1157dd30/attachment-0005.sig>