Re: Informix OnLine on RAID drives
Posted in 1997
Topics: Performance & Tuning
Melody Fallah-Khair wrote: > > Hello, > > Has anybody experienced setting up Informix Online 7.x on > RAID (Redundant Array of Independent Disks) disk drives? Any performace > improvement or suggestion for how to set them up (RAID 0, 1, 2, ...6)? > > I'm wondering specially between using either Informix mirroring or > hardware mirroring provided by RAID 1. The I/O performance is an > important factor to us. > > Thanks > Please emailto :mkhair@crosskeys.com > > Melody > ******************************************** > * Melody F. Khair mkhair@crosskeys.com * > * Crosskeys Systems Corp www.crosskeys.com * > * 350 Terry Fox Drive * > * Kanata, ON, Canada K2K 2W5 * > ******************************************** RAID level 1 mirroring is done at the hardware level. This mean that the dbms writes the row(s) to the dbslice and the array controller will automatically write to the mirror. As a matter of fact UNIX does not even know about the mirror, it is all handled by the array controller. I suggest however that you consider RAID 5. Using a 5 disk drive group you only lose only 20% of the space as opposed to 50% with RAID 1. The performance hit is on the writes however reading the data has no consequences. Hope this helps.