[CentOS] realtime backup

Scott Silva ssilva at sgvwater.com
Wed Feb 18 21:57:08 UTC 2009


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.sig>


More information about the CentOS mailing list