[Koha-devel] incremental backup of the DB

[Mark Tompsett]

Greetings,

That's why when I was running Koha 3.6.x on a machine with only 512MB RAM 
with no swap and 20GB disk space, I would after hours:
- restart mysql
- shut off apache
- backup
- turn on apache
This would free up some much needed RAM so that the backup would work. :)

Now we've (both Koha and the library group) grown such that I would never 
dream of running with less than 1GB RAM and some swap.

GPML,
Mark Tompsett

-----Original Message----- 
From: David Cook
Sent: Wednesday, November 18, 2015 9:55 PM
To: 'Robin Sheat' ; koha-devel at lists.koha-community.org
Subject: Re: [Koha-devel] incremental backup of the DB

I agree with Robin. I've seen another system that does database dumps during 
the middle of the day while the database server is running, and the 
increased server load is quite significant. I'm also guessing that locking 
takes place as sometimes the load will skyrocket during this time. Besides 
the huge lowering of performance, your data might be inaccurate or even 
corrupt anyway since you might be doing a backup midway through a script 
action.