RAID on my parade
Posted in 1999
Topics: Storage & Space Management, Stored Procedures & SPL, Logging & Checkpoints
Hi, I'm not new to Informix but this RAID vs spindle issue always provides room for judgment calls. I have 6 x 18gig disks at my disposal to set up the dbspaces for an OLTP environment. Currently they are set up as RAID 5 (I know, eeecchhh!). My dilemma is this. I do know I would prefer to have more that one virtual disk so that I can guarentee that I am placing my rootdbs, logdbs, plogdbs and datadbs on seperate spindles, albeit not controllable within each virtual disk. What I am wrestling with is that since I have 6 disks, and a RAID10 requires 4 min, I can't create two virtual disks of RAID10. But is the trade off negligble, should I go with all 6 disks in a RAID10 and forfeit the ability to ensure I am on seperate spindles, or should I set up three virtual disks with only RAID level 1? I know I've seen Art comment on this, suggesting that it may be a 'same diff' situation. Also let's say for a moment that I go with mirroring only and have 3 virtual disks, what spread should I use, rootdbs on 1, logdbs on 2 and heavy I/O datadbs on 3? Then should I bother to split the physical log onto another of the disks or leave it in the rootdbs? and where would it be best to create my tempdbses? To tell you the truth it may cause me less heartache to go with a single RAID10 virutal disk and just plonk everthing on it and settle for the striping effect. Any comments?