Ingres with RAID

Jack Gartner  writes:

>
>I'm working with a customer who wants to put an Ingres database on a NFS
>mounted RAID (Redundant Array of Inexpensive Disks).  However, I'm told that
>Ingres does not support NFS mounted disks.  
>
>The system would look something like:
>
>
>   +-------------+        +-----------------+
>   | NFS mounted |        | HPUX system     |
>   | RAID with   |<------>|                 |
>   | (db file)   |        | running Ingres  |
>   +-------------+        +-----------------+
>
>
>Has anyone ever done this or something similar?

Jack,

  Not too many RDBMS systems CAN support NFS, because you can
never guarantee if the data has been written or not.

  The transaction system of a true DBMS cannot return a "transaction
complete" message to the caller until it is assured the transaction has
been committed completely.

  The NFS protocol provides no cache resolution status methods. I do
believe that AFS does, however.  Problem is, AFS is so rare that 
no RDBMS vendors support it, as far as I know.

  Most of our clients use RAID attached disk arrays.  These are NOT
NFS mounted, but instead attached via high speed SCSI fast/wide 
differential busses or fiber optics.  Both Sun and HP offer good
products that do this.

Cheers,

-- 
|---------------------------------------------------|
| Michael Leo              York & Associates, Inc.  |
| mal@winternet.com        (612) 921-8083 (voice)   |
|                          Minneapolis, MN, USA     |
|---------------------------------------------------| 
| NAIUA = North American Ingres Users Association   |
|            http://www.naiua.org                   |
|                                                   |
|   Ingres FAQ is at ftp.naiua.org in /pub/ingres   |
|---------------------------------------------------|
Ingres Q & A
To William's Home Page
Email William