Subject | Re: [firebird-support] How to access Firebird DB on NAS storage device from client workstations |
---|---|
Author | Lester Caine |
Post date | 2010-11-06T08:22:12Z |
mariofb123 wrote:
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
> 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 ?Don't go there is the first comment!
> 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.
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