[OpenAFS] Oracle Databases...

Jeffrey Hutzelman jhutz@cmu.edu
Mon, 21 Mar 2005 17:14:35 -0500


On Monday, March 21, 2005 09:53:07 AM -0700 Dexter 'Kim' Kimball 
<dhk@ccre.com> wrote:

>> Is OpenAFS a good filesystem to run an Oracle database on?
>
> Lousy, actually.  No byte range locking, to begin with.  Other performance
> overhead.

Byte-range locking is really not the core issue here.

The backend storage for an Oracle database is highly specialized, 
performance-critical, and cannot be shared among multiple servers.  Thus, 
it is not a good candidate for storage in _any_ remote or distributed 
filesystem, including AFS.

-- Jeffrey T. Hutzelman (N3NHS) <jhutz+@cmu.edu>
   Sr. Research Systems Programmer
   School of Computer Science - Research Computing Facility
   Carnegie Mellon University - Pittsburgh, PA