Re: Optimal Disk Layout for IDS?
From: Richard Spitz <Richard.Spitz@ana.med.uni-muenchen.de> > >I'm planning a replacement for our old Informix server and am thinking >about what to put on my wish list regarding hard disks. Server will >be IDS 7.31 for the time being (at present UC4, may update to UC7). >Hardware RAID is probably not possible in our budget, and I am >confused anyway about how to optimally partition the disks and spread >my chunks and dbspaces across them. > >AFAIK, I have to take these facts for granted: >- There is a 2GB limit on chunk size for Informix >- It is best to utilize as many "spindles" as possible. > >Does that mean the best solution would be to have as many 2GB disks >as I can get, preferably distributed among several controllers? > >Since 2GB disks are hardly available any more, I'll get disks of at >least 4GB, probably even 10 or more GB. Since the overall size of >my databases is much less than 3GB, I can hardly justify getting more >than 4 disks, even taking into account separate dbspaces for logical >logs, physical log and temp dbspaces. > >I'll probably have two disk controllers; disk mirroring and/or striping >is software-provided by the OS (Siemens Reliant UNIX). I am unsure if a >combination of these two to get the much recommended RAID 10 is feasible, >since it is not done in hardware. > >So what disk layout would the experts recommend for 4 x 4GB harddisks >on two controllers? Well, I'm no expert, but I'll answer anyway: 1. I'll be impressed if you can find a drive smaller than 9 GB. 2. If you do have 4 drives, I would put 2 on each controller, and do a Informix mirror (stuff on disk 1 on controller 1 to disk 1 on controller 2, stuff on disk 2 on controller 1 to disk 2 on controller 2) 3. Put rootdbs and plogdbs on disk1/controller1, llogdbs on disk2/controller1, mirror all these to controller 2. 4. Put one tempdbs on each disk. (4 tempdbs's) 5. Make 2 dbspaces on each disk on controller 1. Mirror these to controller 2. My best guess anyway. _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.
Obnoxio The Clown <obnoxio@hotmail.com> wrote in message news:8tua87$8k2$1@news.xmission.com... > > Well, I'm no expert, but I'll answer anyway Oh! Oh! I tell the ladies that I'm no Adonis. But I don't mean it!