Re: Stripe + Mirror vs. RAID 5

In article <6bqjf4$bca_at_suriname.earthlink.net>, "Kristian" <nospam-kvl_at_earthlink.net> wrote:
>We are running a large-scale (130+ million rows) OLTP application using
>Oracle 7.3.3 on a Sun Enterprise 4000 running Solaris 2.5.1.
>
>Currently, we have our data and index partitions (They're raw partitions)
>hardware RAID 5'ed on two separate storage arrays using fiberchannel
>controllers.
>
>To increase performance, we're considering getting two more arrays and
>striping and mirroring these partitions instead.
>
>Does anyone out there have experience with this sort of setup. What
>performance gain can I expect? Is it a good idea? As a side note, we have on
>average 15 client threads accessing the DB at any given time.
>
>-- Kristian

Yes. Most of the databases I have installed in the last few years were on raw using RAID 0+1. The performance for OLTP is much better than RAID 5! (RAID 5 has a serious write penalty.) Received on Wed Feb 11 1998 - 00:00:00 CST