What type of database? Joseph Kezar wrote:
We are in the process of building a database on a 4 processor 1.8GHz, 4GB RAM Dell 6650.I've never worked with an Oracle DBA that would favor this. "Spindles, spindles, spindles" they cry. Now, I realize that you're going to have 8 spindles no matter what.
I am trying to figure out the most efficient way to use LVM for our raw data storage. We have a RAID array with 8x36GB drives in it. Should I do a raid 1+0(mirror 4 disks, and span them to get one logical volume)?
If so this leaves me a /dev/sdb. Or would I get better performance if I mirror 1 + 5, 2 + 6, 3 + 7, 4+ 8 to give me /dev/sd[b-e].If you have to do RAID for everything, then this would probably be most favored (easiest to optimize), but I know several DBAs that would prefer to use 8 independent disks, along with a good backup plan and "Oracle journal logs" for recovery. Of course, I'd probably do the RAID thing because I'm not a DBA :)
David Corbin
_______________________________________________
linux-lvm mailing list
linux-lvm@sistina.com
http://lists.sistina.com/mailman/listinfo/linux-lvm
read the LVM HOW-TO at http://tldp.org/HOWTO/LVM-HOWTO/