[CentOS] realtime backup
CentOS List
centoslist at gmail.com
Thu Feb 19 01:40:51 UTC 2009
>> >>> 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?
More information about the CentOS
mailing list