Re: Raid 0+1 vs. mirrored pairs

From: <Jared.Still_at_radisys.com>
Date: Wed, 02 Jul 2003 14:56:20 -0700
Message-ID: <F001.005C26D5.20030702142428@fatcity.com>

Separating tables from indexes is one of those mythical things.

If you want to separate files to different filesystems/volumes/whatever, do
so based on the amount of IO per file.

disclaimer: I still tend to do that myself, partly by necessity. SAP demands it,
and it's a starting point on new systems.

Jared

Gudmundur Bjarni Josepsson <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]
07/02/2003 02:20 PM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc: 
        Subject:        Re: Raid 0+1 vs. mirrored pairs

RAID 0+1 and RAID 1+0 provide similar performance but RAID 1+0 has the advantage of offering more redundancy/availability. If you take your sys admin's advice and go with 2 x 3 disks in a 0+1 config and you lose one disk then you lose the other two spindles in that stripe as well. That's half of your I/O capacity gone. With RAID 1+0 the other two spindles will

still be available when one disk fails in a stripe.

I think it is useful to be able to split your data between different physical disks. Apart from the fact that redo and archive logs should never reside on the same volume then it can make a big difference being able to keep your data tablespaces from your indexes from your rollback from your redo.

And now I have stated the bleeding obvious. BAARF.

Gudmundur
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Gudmundur Bjarni Josepsson
INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------