[CentOS] realtime backup

Thu Feb 19 09:01:28 UTC 2009
Rainer Duffner <rainer at ultra-secure.de>

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