Re: Oracle 10gR2 / RAID-5 / SAN

On Dec 20, 10:06 pm, joel garry <joel-ga...@xxxxxxxx> wrote:
On Dec 20, 8:02 am, jeremy <jeremy0...@xxxxxxxxx> wrote:

Hi folks

Any pointers to any papers on the pros and cons of this kind of
configuration?

thanks

--
jeremy

In addition to baarf,http://kevinclosson.wordpress.com/?s=raidhttp://www.freelists.org/archives/oracle-l/10-2006/msg01134.htmlhttp://www.thestorageforum.com/blog/index.php/2007/02/24/everything-y...http://www.oaktable.net/getFile/34

I've spent a lot of time on small RAID-5, and it does work. However,
it is amazing how often things that are not supposed to happen do:
loss of more than one disk, saturation of I/O, controller
configuration issues, etc. There used to be a bunch of papers about
vendors supporting small raid-5 hardware on oracle.com, when there was
some initiative to push it. I had the sense that initiative was
marketing-driven, something having to do withhttp://www.oracle.com/partners/home/why_allusers/en/benefits.html.

You should at least get a commitment to allow some other configuration
for critical files that do better in other RAID configurations, should
they prove to be a problem. From what I've seen, these would be
serial write intensive files like redo, archived redo and backups.
Also undo, simply because it is the most hit tablespace on the OLTP
types of db's that I tend to work on. Since the backups and other
batch type jobs tend to happen after hours, no one much cares about
the I/O saturation as long as things complete in some reasonable time.

When it comes down to it, I take space over speed, if the speed isn't
enough, someone else will drive the political push for it. I just
make sure I'm doing the best with what I have.


I have been looking around for more info on this and came across:

http://spiralbound.net/2006/09/08/why-modern-raid-5-is-ideal-for-oracle-databases

Here is an excerpt:

"There is a convention of thought amongst Oracle DBA's that databases
should never be installed on disks that are configured into a RAID 5
array. The argument goes, that since Oracle accesses and writes to
random points within relatively large files, the overhead of
constantly calculating block-level parity on these files is
substantial, resulting in serious performance degradation. They
suggest that RAID 1 (mirroring) is the ideal disk configuration since
no parity needs to be calculated, and Oracle is more than happy to
divide up its database over many smaller mount points.

This way of thinking has largely been correct over the years because
most systems have traditionally used software RAID. This means that
the CPU of the server itself had the job of doing all those parity
calculations, and it really did slow down both the server and the disk
when RAID 5 configurations were used. Oracle, in particular, had a
hard time with these configurations for the exact reasons the DBA's
point to.

In many cases, software RAID is still used, and to be sure, it is
wholly inappropriate to deploy RAID 5 in these environments. However,
it is increasingly common to find IT departments using a SAN-type
architecture where the RAID type and configuration are invisible to
the host operating system. In these environments, the the disk array
has a dedicated controller that is singly tasked with handling all
read, write, and parity operations. The RAID controller is no longer
software running on a generic CPU, but rather firmware that is
optimized to handle parity calculations. This results in a system
where parity is calculated so quickly by the dedicated controller that
differences in speed between RAID 1 and Raid 5 should be virtually
nonexistent."

So.... does this alter the views of folk here? Reading this it would
suggest that the issues of writer performance may be mitigated by the
SAN managing everything.

Appreciate more views on this

cheers

--
jeremy
.

Relevant Pages

  • Re: Oracle 10gR2 / RAID-5 / SAN
    ... configuration issues, etc.  There used to be a bunch of papers about ... for critical files that do better in other RAID configurations, ... suggest that RAID 1 is the ideal disk configuration since ... has a dedicated controller that is singly tasked with handling all ...
    (comp.databases.oracle.server)
  • Installer fails for software RAID
    ... I've been unable to produce a working software RAID ... installer using a pretty standard configuration. ... Waiting for root file system... ... machine install. ...
    (Ubuntu)
  • Re: Need help installing OS6 on Dell PowerEdge 2600 with PERC4/Di RAID
    ... The above recommends setting both channels to RAID. ... been with channel 1 set to RAID and channel 2 set to SCSI. ... SCO on the "proper" configuration. ... in the driver package description. ...
    (comp.unix.sco.misc)
  • Re: new dell, dumb operator needs help!
    ... hard disks that are not in a raid configuration. ... listed under 'hard disk'. ... drives in 'my computer' then it is pretty clear that you do not have raid ...
    (alt.sys.pc-clone.dell)
  • Re: Grav and Inertial Mass
    ... The parity Eotvos ... > experiment is relevant to static massed configuration only. ... > get around to view the other side you don't have chirality. ... > atoms at room temp intensely drives CHI fluctuations in macroscopic ...
    (sci.physics.research)