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/
>
>

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