Hi Rowan,
I think you are on the right track. However as you pointed out the last
step (i.e. getting database dumps to a different location) is quite a
challenge. In my opinion I think this depends on the whole setup and
policies you have. As far as I know it can be very difficult to automate
this kind of a think because this will require a reliable network
connection which you might not have. So the best option I guess is to
rely on IT personnel at the sites to copy the dumps manually using USB
drives.
Encryption or no encryption, depends on your data policy. Nonetheless if
by encryption you are talking about transferring the dumps over the
network, I guess you can use GPG encryption <http://www.gnupg.org/>.
Regards,
Mhawila A.
On 02/24/2012 11:23 AM, Rowan Seymour wrote:
At the Rwandan MOH we have 70 remote sites to deploy to soon and we
need a backup strategy that doesn't require great internet or IT
capacity at the sites. People have obviously tackled this problem
before so am looking for ideas. I think the general idea should be:
1. Nightly database dumps
2. Delete dumps past a certain age to avoid filling up the hard drive
3. Regular transport of latest dump to another location
I've attached a bash script that I've written which will read database
connection details from the OpenMRS runtime properties file, dump the
database and delete dumps older than a configurable number of days.
Easy to hook this up to a nightly cron job.
Not sure though about getting the database dumps to a different
location. Should we try to make it all automated via rsync? Should we
rely on site IT staff to copy dumps onto a USB device? Should those
dumps be encypted? How could we encrypt them?
Ideas anyone?
--
*Dr Rowan Seymour*/
Partners In Health, Rwanda/
Tel: +250783835665
------------------------------------------------------------------------
Click here to unsubscribe
<mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l> from
OpenMRS Implementers' mailing list
--
Mhawila A.
_________________________________________
To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to
[email protected] with "SIGNOFF openmrs-implement-l" in the body
(not the subject) of your e-mail.
[mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l]
