Subject | Re: How to access Firebird DB on NAS storage device from client workstations |
---|---|
Author | mariofb123 |
Post date | 2010-11-08T06:26:03Z |
Thank you Lester.
Based on your reply, I assume that it is not possible to run the Firebird server on the NAS drive, to control the database files located on that drive ?
If this is the case, then I can see the problems with simultaneously accessing the same file on the NAS box by several FB servers run on networked client machines...
Any further comments on this issue would be greatly appreciated.
Kind regards
Mario
Based on your reply, I assume that it is not possible to run the Firebird server on the NAS drive, to control the database files located on that drive ?
If this is the case, then I can see the problems with simultaneously accessing the same file on the NAS box by several FB servers run on networked client machines...
Any further comments on this issue would be greatly appreciated.
Kind regards
Mario
--- In firebird-support@yahoogroups.com, Lester Caine <lester@...> wrote:
>
> mariofb123 wrote:
> > I would like to place the Firebird database files on the NAS device connected to network router and have them available to several client workstations on the same network. Is this possible ?
> > I have tried to access the database files stored on NAS box using the Firebird server installed on the client workstation and also tried to install the Firebird server on the NAS drive itself. None of these options appear to work.
> > Could you please help and advise how to resolve this NAS accessibility problem.
>
> Don't go there is the first comment!
>
> You do NOT want several machines accessing the one file especially not at the
> same time. That is not how a good database server works. For the best
> performance, the database needs to be on the fastest local hard disk on ONE
> machine, and the clients access the data from a copy of firebird running on that
> machine. This is NOT Access where you simply open a file!
>
> Having said that people still insist on using NAS type devices, and so some
> switches have been added to allow it ... with warnings about the fact that you
> MAY get corruption on the database, but certainly you do not want more than a
> single copy of Firebird Server accessing that file at a time.
>
> --
> Lester Caine - G8HFL
> -----------------------------
> Contact - http://lsces.co.uk/wiki/?page=contact
> L.S.Caine Electronic Services - http://lsces.co.uk
> EnquirySolve - http://enquirysolve.com/
> Model Engineers Digital Workshop - http://medw.co.uk//
> Firebird - http://www.firebirdsql.org/index.php
>