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!!!!
Attachment:
signature.asc
Description: OpenPGP digital signature
_______________________________________________ CentOS mailing list CentOS@xxxxxxxxxx http://lists.centos.org/mailman/listinfo/centos
