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