[CentOS] realtime backup

Thu Feb 19 01:40:51 UTC 2009
CentOS List <centoslist at gmail.com>

>> >>> 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?