I plan to build, or purchase pre built, two servers to cluster an Oracle
10G database on. However, I am having a hard time figuring out what will
be the best arrangement within my budget of < $5000 per machine.
Dual Xeon or dual Opteron? I'm informed that I'll get better performance
from the latter, and have read that 10G will run, just in 32 bit mode. I
am trying to avoid 32bit vs 64bit library hell.
SATA RAID or SCSI RAID? The former is cheaper, but how reliable is it? I
have looked at the 3Ware 9500S-12 and 8506-12 cards for a RAID 10
config. As far as SCSI is concerned, I'm aware the MTBF on drives is
higher, and it'd be better, but don't know which SCSI hardware RAID card
to try with Linux. I don't want to have to load some proprietary driver
module tied to one specific kernel, and want the system to be able to
boot Linux from the array rather than a boot hard disk.
As for the motherboard, I'm looking at one of the 7xxx chipset boards as
they'll have the 64bit PCI slots the 3Ware (or SCSI raid card) needs and
can support more ram (4gb upwards). Does anyone recommend any particular
brand? (Tyan, Supermicro, other?)
I'd like to get a 4U case as rack space isn't an issue, and am hoping I
can just pop in the required number of SATA or SCSI hotswap cages. If I
go for SATA, will any SATA hotswap do? The SATA spec says it's hot
swappable whatever, but then why do some cages come as '3Ware approved'?
Is it just marketing or is there something to it?
Questions, questions. Advice welcome!