Re: What is the most widely used RAID type for Oracle databases?

On Nov 15, 3:54 am, Bill <edi...@xxxxxxxxxxxx> wrote:
Maybe too broad a question.
Is RAID 10 pretty much now the rule of thumb?

Hope things are going well,
Bill

I think RAID5 is the most widely used these days. It works ok, except
when it doesn't. "Doesn't" usually includes situations such as write
buffer saturation and degraded hardware situations (ie, bad disk). Of
course, if one more disk than the number you have set for redundancy
goes bad (like if another disk is pulled out while a new one is being
rebuilt) the effects are similar to the old "ripper" virus on DOS.

For heavily loaded systems, much of the saturation problem can be
avoided by moving things that are heavily serially written to RAID10
(or whatever) - like redo.

Is http://www.baarf.com/ out of date? Perhaps, more modern 5's have
pretty big buffer hardware. But http://storagemojo.com/?p=383

Since it probably isn't clear, I think RAID10 is far superior for what
Oracle does. But that isn't the subject. What is most widely used is
what is most widely sold, and that isn't necessarily based on
technical superiority or proper requirements analysis. It's based on
money and somewhat on hype. RAID5 is, simply, cheaper - and isn't
that what the I in RAID is?

jg
--
@home.com is bogus.
http://www.foxnews.com/story/0,2933,311727,00.html
.

Relevant Pages

  • Re: SATA RAID 5 Performance
    ... RAID5 certainly isn't designed to perform write operations as fast as ... but then again writes aren't written transactionally to disk on ... but RAID5 often cuts the mustard for many small to mid range transaction ... Are there any RAID vendors I should look ...
    (microsoft.public.sqlserver.server)
  • Re: RAID 0+1 sofware or dedicated adapter for 7025 F50?
    ... Raid 5 is fastest for reads. ... from a RAID5 device for the obvious reason that the RAID5 has a disk worth ... of distributed parity information compared to the RAID10. ... disk space from a given set of disks. ...
    (comp.unix.aix)
  • Re: Software RAID partitions not detected at boot time with linux 2.6.25.1.
    ... md: Autodetecting RAID arrays. ... raid5: device sdc2 operational as raid disk 2 ... Subject: block: do_mounts - accept root=<non-existant partition> ...
    (Linux-Kernel)
  • Re: Suggestion for PCI IDE controller?
    ... > any significantly better write performance out of RAID 1 than I did from ... I'm also surprised that your RAID5 writing is as fast ... be extra reads/writes in there for the parity information in RAID5. ... > full-duplex, switched connection, it doesn't take much disk at all... ...
    (comp.os.linux.hardware)
  • Re: [PATCH][AGPGART] intel_agp: dont load if no IGD and AGP port
    ... ACPI: ... pnp: PnP ACPI init ... VFS: Disk quotas dquot_6.5.1 ... raid5: automatically using best checksumming function: generic_sse ...
    (Linux-Kernel)
Loading