Re: Must we use disk-striping

This is a multi-part message in MIME format. --------------F2EAF46EB8B227A3F6F661B9 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Rob, Today you can purchase disk controllers which can be configured for RAID 0/1 or RAID 5. All of the disk operations are controlled by the controller - so check out the specs for a few controllers that are compatible with your hardware and see which will perform best. By the way, if the controller handles the RAID, your system doesn't see how many actual reads or writes which occur in the disk subsystem. I personally like to mirror DB servers (letting the disk controller handle the mirroring function) and use RAID 5 for fileservers (again letting the disk controller handle the RAID). There's my 2 pennies. Allen Rob Prop wrote: > Hi, > > I have a serious question on which I've already got a lot of different > answers. > > When installing/ordering a new machine for IDS should you use the following > disk-architectures: > + Mirroring > Pos: HA + both disks can be used for reading > Neg: All the data should be written two times > + Striping > Pos: Data load is balanced over a set of disks > Neg: You don't know which data is on which disk so you can't use > fragmantation optimal > + RAID > Pos: Disk reads can be faster (Many READ boxes have caching) and you > have HA > Neg: Writes are slower > > Is anyone able to tell me more about this... > > Unitil now my opinion was: Use Mirrored disks without striping, and > fragment the tables yourself over the available drives. > > Greetings, > > Rob Prop > Database Consultant > Informa Automatisering bv --------------F2EAF46EB8B227A3F6F661B9 Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Allen Ripperden Content-Disposition: attachment; filename="vcard.vcf" begin: vcard fn: Allen Ripperden n: Ripperden;Allen org: 3Com email;internet: allen_ripperden@mw.3com.com title: Manager, DQ Test Platform Development x-mozilla-cpt: ;0 x-mozilla-html: FALSE version: 2.1 end: vcard --------------F2EAF46EB8B227A3F6F661B9--