D&C Lug - Home Page
Devon & Cornwall Linux Users' Group

[ Date Index ][ Thread Index ]
[ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] Backup servers



On Wednesday 08 Oct 2003 12:31 am, Mark Harvey wrote:
> Strange. I did send it from a webmail client whilst at work rather than
> from Kmail as normal at home. (Nural Storm webmail). I did wonder why I

You could always send from the members area rather than webmail, if you need 
to post again in the same situation. Various webmail clients have horrible 
ways of wrecking the email headers.

> Thanks for the suggestions. With the 10 - 20 minute cron job - would that
> copy open files? We have a large number of transactions every day (I work

Depends on what process has opened the file and how it has locked the file. 
cron is just the daemon that executes the script/program etc. Whether the 
file can be copied is up to the permissions/setup of the script/program 
called by cron. If it's a bash script, it would probably come down to whose 
crontab you use to install the cron task.

> mis-quote Murphy). It is almost certain that there would be open files at
> the time of the cron job.

But each individual file wouldn't be open all the time, so cron / your script 
might get a chance to copy when the file is closed whilst the main process 
moves on to another task. e.g. MySQL only locks the tables when an insert or 
update is in progress (and even that's configurable) - select queries can 
wait until other processes are done.

What size files are you thinking would be open?
What type?
How many?

Isn't this getting into areas where RAID would become a practical solution? I 
have little experience of RAID but I believe it could give you a mirror type 
copy on the first server (which would deal with the immediacy of the data) 
and the backup server could copy that freely. 

-- 

Neil Williams
=============
http://www.codehelp.co.uk/
http://www.dclug.org.uk/
http://www.isbn.org.uk/
http://sourceforge.net/projects/isbnsearch/

http://www.biglumber.com/x/web?qs=0x8801094A28BCB3E3

Attachment: pgp00036.pgp
Description: signature


Lynx friendly