Re: [Hampshire] [OT]Datebase questions

On Thu, April 1, 2010 18:48, Chris Dawe wrote:
> On 2010-03-24 20:55, Daniel Pope wrote:
>> On 24/03/10 19:40, Andy Smith wrote:
>> > Database heads with storage mounted remotely off a SAN or NAS is an
>> > extremely common setup in the real world.
>>
>> I find that quite surprising. My understanding was that the syscalls
> (locking
>> and mmap) are not supported well enough enough to offer consistency and
>> durability guarantees.
>> Dan
>
> Many database installations use SAN-based storage, but they do NOT use NFS
> since it have reliability problems (network glitches, etc).


Sorry, but yes they do.

AndyS and I both worked for the same company that served quite large and
quite busy databases off NetApp filers via NFS. In terms of protocol
reliability we had no problems that I can recall over a period of at least
20 months.