[CentOS] realtime backup
Rainer Duffner
rainer at ultra-secure.de
Thu Feb 19 09:01:28 UTC 2009
CentOS List schrieb:
>>>>>> 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"...
>>>
>
>
>> ;) That would work, and I've done that (though not at the 5-minute
>> interval) in production environments. But since the OP hasn't responded
>> to this thread with any type of follow-up detail (like the size of the
>> db), I'm wondering how much time I want to spend putting out possible
>> solutions...
>>
>
> Thanks everyone. At the present I am looking at 150mb worth of database. I
> stumbled across Zmanda. Has anything tried it? Is it suitable for my case?
>
I'm still not sure what you want to achieve by backing up every 5 minutes.
I *think* you are looking for something like PostgreSQL's Point-in-Time
recovery feature.
Maybe it's time to change databases...
Rainer
More information about the CentOS
mailing list