Re: Raid 1+0 vs Raid 0+1

From: Walter <walterl@genasys.com.au> > >I am more of a system administrator than a DBA and I am a newbie to >Informix, so >excuse my naive question. > >My main question is: > >Does Informix have any problems with striping, mirroring etc under any >version or on >any flavour of Unix/NT? Nope. They're all supported by Informix, but I for one don't like RAID5, because I've seen it let go, and it wasn't pretty. Art Kagel posted some useful comments, I'm sure you;ll find more at http://www.deja.com We're all pretty big fans of mirroring and striping. I think. >The reason I ask this is because I've been told by some source that: > >1. Informix does not like striping/mirroring etc because not only it does >not improve >the performance/integrity, it degrades performance. > >2. Informix tables HAVE to be Raw, otherwise the filesystem overhead would >result in >severe performance penalties. > >I'd like to know if there is any substance to the above statements, or if >any of them >was ever true under some particular version of Informix etc. > >I come from a System Admin background with some Oracle knowledge, and my >understanding was: > >1. Striping and Mirroring can be applied to just about anything to gain >performance/redundancy > >2. Raw tables do increase performance by a little, but this should be done >as the >very last resourt to get performance, because in most cases the >administrational >overheads outweight the performance benefits. > >3. The operating system performs the RAID function, so the RAID details are >hidden >away from the application that uses it (Informix in this case), so why >should >Informix even care? > >Reading through this thread, it seems like Informix does not have any >problems with >RAID whatsoever. >Can someone verify this for me please, or point me to a formal statement >that >acknowledges/denies the above, or gives a rough indication of how much >performance >gain a raw table gives as opposed to a filesystem table. > >I really appreciate any information/comments, >Thanks in advance, >-- >Walter Lolham - walterl@genasys.com.au > ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com