Subject Re: [ib-support] Firebird and Network Attached Storage?
Author Jason Frey
At one point, we got this to work, with no recompilations.
We found that on a 2000Pro->NT4Server (2000 was the "client" machine, NT4
was hosting the network share that contained the GDB file), if you mapped a
drive to the share that is on the NT4 machine (IE g:\ maps to \\nt4\share),
we got it to open up using just a straight path (g:\directory\db.gdb). The
NT machine was also hosting an Interbase server (Not FB, straight Interbase
Open Edition). The client machine had a version of interbase on it, I
believe the Interbase Open Edition, not FB (Don't quote me on the client
machine, though).
We found, after a bit of testing, that this "trick" would not work on a
95/98 machine, just on the 2000Pro machine (We didn't have any NT4
Workstation machines to play with, to see if it was a 2000 specific issue...
Don't even ask about XP :)).
That being said, don't do what we did. We mainly tried it when we found out
one of our developers said they had done it (In our very early stages of
working with IB/FB). It's a Bad Thing (tm), as most people would say.

- Jason

----- Original Message -----
From: Wilson, Fred
To: 'ib-support@yahoogroups.com'
Sent: Tuesday, January 15, 2002 1:13 PM
Subject: RE: [ib-support] Firebird and Network Attached Storage?


I would say that probably no one is using networked drives as FB (nor will
IB) open a database file on a networked drive. One would have to re-compile
the source to remove that check.

Best regards,
Fred Wilson
SE, Bell & Howell
fred.wilson@... <mailto:fred.wilson@...>


-----Original Message-----
From: David Montgomery [mailto:montgomery_list@...]
Sent: Tuesday, January 15, 2002 1:14 PM
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] Firebird and Network Attached Storage?


John,

Thanks for the response. So you're saying very few active IB/FB
installations are using networked drives (via NFS, Samba, whatever) because
of this potential corruption?

We do use forced writes at present (I don't have any desire to change
this...I don't think).

For some metrics on how much disk activity we're currently pushing, I just
set up the Win2000 performance monitor for "Disk Read Bytes/sec", "Disk
Write Bytes/sec", and "Disc Bytes/sec". These seem like the best metrics
available for this purpose. Once I have some idea of how much data we're
talking about, I'll let you know.

Best Regards,

David Montgomery
montgomery@...

> -----Original Message-----
> From: John Bellardo [mailto:bellardo@...]
> Sent: Tuesday, January 15, 2002 10:40 AM
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] Firebird and Network Attached Storage?
>
>
> David,
>
> On Tuesday, January 15, 2002, at 09:57 AM, David Montgomery wrote:
>
> > Hi,
> >
> > [...]
> > Does anyone care to comment on this potential network design? I'm a bit
> > leary of sucking all that data through even a large ethernet pipe. Will
> > having the disks in a different box really kill performance?
>
> To answer your question, it depends on the activity level of your
> database. Do you have any numbers that tell you how much data you are
> currently pushing through your existing SCSI controller? Are you
> planning on using forces writes? If not there is a higher change of
> database corruption when one of the servers crashes.
>
> The other problem is FB/IB does a check to see if the database file is
> on a network drive, and if it is it won't allow you to open it. This
> protects the database from corruption, because if different servers on
> different machines open the same database file at the same time it will
> get corrupted. If you really want to do this (maybe just for testing
> purposes) I can tell you what you need to change in the source to
> disable the check. But disabling it will give you more than enough rope
> to hang yourself.
>
> -John
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
>
>


_________________________________________________________
Do You Yahoo!?
Get your free @... address at http://mail.yahoo.com
<http://mail.yahoo.com>



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=216105.1806326.3318126.1261774/D=egroupweb/S=17050077
09:HM/A=915128/R=0/O=1/I=brandr-lrec/postholidaygroup/*http://shopping.yahoo
.com/domain?d=holiday&cf=posthol01>

<http://us.adserver.yahoo.com/l?M=216105.1806326.3318126.1261774/D=egroupmai
l/S=1705007709:HM/A=915128/rand=984759815>

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .



Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.