Am Fre, 2002-05-17 um 23.25 schrieb Alex Daniloff:
Hello SuSE folkz, I need your advise on SQL DB layout. Which SQL Database? What kind of data? What kind of application? What is better in terms of performance and speed to install database on a single RAID0-1 array or split data directories between separate Mirroring introduces write penalties, and at least in theory speedups read access. It also enhances (again in theory, it all depends upon the specifics of the hardware) data safety, as you have a complete second harddisc backup. :)
Striping increases read and write speed. (Again it depends upon hardware, there are certain gotchas with IDE drives) It also increases the probability of data loss due drive defects.
single hard drives? Thank you in advance for any ideas or recommendations. Basic recommendation: Make a mockup of your application situation and benchmark it for yourself :)
Andreas