Raid 0,1 and 5
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Raid 0,1 and 5

  1. #1
    Join Date
    Aug 2001
    Posts
    391
    Please help me understand about the the differences between raid 1 and 5 since I am not too clear about how this work. From what I understand, when you have raid 5 and you have 5 physical disks, it will stripe to 1 big disk so if you write to the disk it will write randomly to one or two out of these 5 disks right ??? Here is what we do in my company and I think it's not right ??? they have raid 5 and they only have one partition since they said no need to have many different partitions since i will write to different disks any way, it only cause overhead if we have more than one partition. Is that a true statement ??? So we have only one partition and they put datafiles and index files in one partition. Is that right ???

    the system (C drive) and (E drive) will be partitioned on pair of mirrowed and they put all of the log files and system, rollback in there.

    to me this configuration is not right but I like to prove it to them.

    Thanks

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Originally posted by mike73
    Please help me understand about the the differences between raid 1 and 5 since I am not too clear about how this work.
    There's lots of information at http://dbasupport.com/oracle/resourc...Hardware/RAID/ about RAID configurations. Basically, RAID 1 is mirroring. For every disk, you have another disk.

    RAID 5 uses what's called parity striping. With RAID 5, each write is spread out over all the physical disks along with parity information. If one of the disks is lost, you can continue at a diminished capacity. If you lose two disks, you're SOL.


    From what I understand, when you have raid 5 and you have 5 physical disks, it will stripe to 1 big disk so if you write to the disk it will write randomly to one or two out of these 5 disks right ???

    No, not quite. The writes go to all disks in the RAID volume.


    Here is what we do in my company and I think it's not right ??? they have raid 5 and they only have one partition since they said no need to have many different partitions since i will write to different disks any way, it only cause overhead if we have more than one partition. Is that a true statement ???

    You get no performance advantage by having multiple partitions on the same RAID volume.


    So we have only one partition and they put datafiles and index files in one partition. Is that right ???

    In the ideal world, I wouldn't do it like that. You are setting yourself up for I/O contention.


    the system (C drive) and (E drive) will be partitioned on pair of mirrowed and they put all of the log files and system, rollback in there.

    to me this configuration is not right but I like to prove it to them.

    Thanks
    Having redo, rollback, temp, and system on mirrored devices is fine.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jul 2001
    Posts
    45

    Raid 1 & 5


    Hi,
    The difference between raid 1 and raid 5 is simply that raid 5 comes with ECC that stripes your data in in 5 physical drives even though you are looking at it as 1 logical drive; and Raid 1 does stripe your data with only one parity.
    Files that are accessed sequentially as Temp tablespace and redo log should never be placed on raid 5.

    Check the documentation Jeff refers you to.

    Thanks
    Richard

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095

    Re: Raid 1 & 5

    Originally posted by richardana

    Files that are accessed sequentially as Temp tablespace and redo log should never be placed on raid 5.
    I'm ALWAYS careful with the words "ALWAYS" and "NEVER".

    Redo logs are better on RAID 5 devices than on unprotected devices even though your performance will be degraded.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Apr 2001
    Posts
    219
    I thought redo logs is one of those files types that can exist on non-redundant disks, as long as you mirror properly in Oracle. Am I wrong?

    and here is a great link on RAID types:
    http://www.acnc.com/04_01_0p1.html
    ______________________
    Applications come and go,
    but the data remains!

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448

    Re: Raid 1 & 5

    Originally posted by richardana

    Raid 1 does stripe your data

    Files that are accessed sequentially as Temp tablespace
    RAID 1 is not stripping, it is mirroring, RAID 0 is stripping

    Temp tablespace is not access sequentially, redo logs are but not tablespaces

  7. #7
    Join Date
    Jul 2001
    Posts
    45
    Jeff
    You 're right about the use of the word NEVER. What I meant to say was " Files that are sequentially accessed SHOULD NOT BE placed on raid 5.
    Thanks
    Richard


  8. #8
    Join Date
    Aug 2001
    Posts
    391
    Jeff,

    I am a little confused per your email. On your reply, one paragraph said it's ok to have one partion and the next paragraph said if I put data files and index files in the same partition, I will set myself in disk I/O. What do you mean by saying that ??? Can you give some more detail ?????

    Thanks

  9. #9
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    In your case, putting all of your disks in one RAID volume will probably not help performance. Ideally, you should have multiple volumes that contain multiple disks in order to maximzie throughput. For example, with your 5 disks, you could have a 3 disk RAID 5 volume and a 2 disk RAID 1 volume. This way, you could spread your I/O over multiple spindles but still limit your I/O contention by placing some files on the RAID 5 volume and some other files on the RAID 1 volume.

    IMHO, you need at least 12 disks over 2 controllers to have decent performance in an Oracle Database.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  10. #10
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Originally posted by Zaggy
    as long as you mirror properly in Oracle.
    Yes, this is the key. As long as you multiplex your files, you can use them on unprotected devices. If you don't multiplex, I would rather have them on a RAID 5 than an unprotected RAID 0.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width