Scheduled backup + files store
Scheduled backup + files store
- Subject: Scheduled backup + files store
- From: Stamenkovic Florijan <email@hidden>
- Date: Wed, 13 May 2009 15:42:32 -0400
Hi all,
In our database (FrontBase) we have a FileRecord table that defines
the db representation of a file. The actual files are however stored
on the file system.
Now, we need to do scheduled backups. The individual ops are not a
problem (run a script that backs the database up, and tars or zips the
files, store it somewhere, done). I am however worried about doing
this with a running app. As it's possible that a file upload operation
is happening at the same time as the backup process, which could
result in an inconsistent backup.
Thoughts on handling this:
1. Refuse or delay the transfers of files to the server at a
particular time of day when the backup is happening. This is sloppy, I
don't want to do it.
2. If I first perform the database backup, and afterwards backup the
files (delay it a bit), the only risk I run is that I have a file too
many in my file storage. This could be acceptable if I tweak my server-
side file writing to overwrite without asking.
Is there a better, standardized way of doing this?
Thanks,
F
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden