- Community Home
- >
- Storage
- >
- Entry Storage Systems
- >
- Disk Enclosures
- >
- Re: extend based striping or kilobyte striping
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-13-2006 02:39 AM
тАО01-13-2006 02:39 AM
simple question. What is better to employ for heavy loaded oracle server - distributed allocation policy (extend based striping) or to stripe on a kilobyte level (-i -I).
unfortunately, it is not possible to stripe on array level
thanks
Michal
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-13-2006 03:05 AM
тАО01-13-2006 03:05 AM
Re: extend based striping or kilobyte striping
If so, then I would do normal striping (-i and -I to lvcreate).
If these disks are NOT RAID protected then I would try distributed striping so you can mirror them.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-14-2006 01:14 PM
тАО01-14-2006 01:14 PM
Re: extend based striping or kilobyte striping
actually the underlying disk array uses several RAID5 groups to allocate space for luns. Bad thing is that it doesn't know how to strippe luns across these groups (IBM DS8300).
However I do not have to worry about mirroring.
I ask only from the performance point of view.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-15-2006 08:44 PM
тАО01-15-2006 08:44 PM
Re: extend based striping or kilobyte striping
It will also depend upon the type of I/O your application performs at the LUNs. If it is sequential read majority, you should consider using extent based stripping. Anadditional advantage here is that you can load balance the controllers. This should be designed in such a way that half of the disks in a VG are accesses through one controller and other half through the other one. Also the allocation is done is such a way that first extent is on the disk accessed through first controller and the second is through the second controller and so on.
If the I/O size is too small you should consider KB level stripping. This also will depend across how much LUNs you are going to strip it across.
If the LUNs presented are RAID-5, these are allready stripped upto some extent and doing either on the desired stripping at OS level will help almost equal.
HTH,
Devender
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-15-2006 10:01 PM
тАО01-15-2006 10:01 PM
Re: extend based striping or kilobyte striping
I know, that the application+oracle generates outstanding amount of i/o and it seems to be more random than sequential, because the system they use currently has low buffer cache hit ratio. I think that oracle block size is set to 8KB.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-16-2006 04:47 AM
тАО01-16-2006 04:47 AM
SolutionStriping on the host/volume manager (LVM or VxVM layer) will work best if you are sure that the LUNS were carved from different RAID groups inside your Disk Array and presented accross different disk chanels (Fibre or SCSI). I stripe no less than 4 ways but no more than 8 depending on the number of disk channels. As far as stripe size - I use 64KB for mixed use RDBMS storage (whetehr filesystem or raw). 32KB for OLTP and 128KB or more for DSS/WArehouse and other specialty applications:
LVM:
lvcreate -L 1024000 -i 8 -I 64 -n ora01 /dev/sapvg01
VxVM:
vxassist -g sapdg01 make ora01 100g layout=stripe ncols=8 stwidth=64
HTH.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-16-2006 08:28 AM
тАО01-16-2006 08:28 AM
Re: extend based striping or kilobyte striping
thanks for your lore, that's exactly something I was expecting to get. Anyway, the oracle uses 8KB db_block_size, vxfs reads in 32KB chunks, wouldn't it be better for stripe size to match one of these values?
thanks for insights
cheers
Mike
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-16-2006 08:32 AM
тАО01-16-2006 08:32 AM
Re: extend based striping or kilobyte striping
Generally I will say yes but you may get expert guidance out of that document.
Again - that is IF you are using cooked storage (meaning filesystem storage) for your Oracle storage.