RE: To use SAME or NOT for High End Storage Setup ?

  • From: "VIVEK_SHARMA" <VIVEK_SHARMA@xxxxxxxxxxx>
  • To: <kevinc@xxxxxxxxxxxxx>, "Oracle-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 11 May 2006 06:57:43 +0530

Kevin, Folks



For a DS8300 High End Storage:-



Which one of the following 2 is advisable:-

Qs. 1 Should ALL of the 47 (Hardware RAID 1+0) LUNs be Added into a
Single Volume using Volume Manager (RAID 1 - Striping)  - SAME concept?



Qs. 2 Optionally should some "Optimal Num / sets" of these (RAID 1+0)
LUNs be added / assimilated into different (multiple) Volumes (of RAID 1
- Striping)? If so, What should be this Optimal Num of LUNs per Volume
(4,6 or 8 LUNs) ?



NOTE - Database will be Laid out across all the 47 underlying LUNs



Qs. 3 Being an OLTP type Banking application 64 KB Stripe Unit Size is
being considered for Both of the following 2:-

i) The underlying Hardware RAID1+0 for LUN creation

ii) Also for the Volume Creation using Volume Manager (RAID 1 -
Striping)

Would folks advise using different Stripe Unit Size for the above (i) &
ii)?



Thanks indeed





________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Kevin Closson
Sent: Wednesday, May 10, 2006 11:44 PM
To: Oracle-L
Subject: RE: To use SAME or NOT for High End Storage Setup ?



hmmm...is that much different than Shark?  :-)



Anyway, while I don't fully understand the "2nd level of striping"
question,

I can say from a lot of high end DS4X00 array testing that it

works fine. I routinely take sets of RAID1+0 LUNS and create

a volume in the volume manager as RAID1 (striped). Otherwise

you will have a bunch "chunks" (47 of them) and you'll have to

play some balance games to load up the spindles evenly. If

you put a filesystem on a striped volume of RAID1+0 LUNS you

are indeed SAME. Then you create tablespaces with datafiles

in the filesystem, use direct I/O, async I/O  and you have the optimal

setup using decades old proven deployment methodology.



Or you could use ASM if you like RAW partitions.



PS. The DS4X00 arrays top their stripe width out at 256KB. I

generally go with that.



        


________________________________


        From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of VIVEK_SHARMA
        Sent: Wednesday, May 10, 2006 10:46 AM
        To: Oracle-L
        Subject: To use SAME or NOT for High End Storage Setup ?

        Folks

        

        For a Big Benchmark should SAME (Stripe Across ALL Disks) setup
of a "DS8300" storage box be considered or NOT?

        

        Storage has 47 LUNs

        Each LUN has 8 Disks (Hardware RAID 1+0)

        

        Qs. Should the 2nd Level of Striping be Done across ALL of the
47 LUNs (SAME) or some Optimal Num of LUNs?

        Database will be spread out across these underlying 47 LUNs.

        



**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely 
for the use of the addressee(s). If you are not the intended recipient, please 
notify the sender by e-mail and delete the original message. Further, you are 
not to copy, disclose, or distribute this e-mail or its contents to any other 
person and any such actions are unlawful. This e-mail may contain viruses. 
Infosys has taken every reasonable precaution to minimize this risk, but is not 
liable for any damage you may sustain as a result of any virus in this e-mail. 
You should carry out your own virus checks before opening the e-mail or 
attachment. Infosys reserves the right to monitor and review the content of all 
messages sent to or from this e-mail address. Messages sent to or from this 
e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***

Other related posts: