currently we’re planning to purchase new servers for our website. A rough overview of our mysql-scenario:
665 Mio rows, 25G data, and 55G index files.
Average of 400 queries per seconds, 15% inserts, 9% updates, 1% deletes, 75% selects (on one slave, we’re running 4 slaves overall).
We’ve choosen DELL PowerEdge 2950 machines, 2x dual core Intels (Woodcrest) with 8 GB RAM.
From a performance point of view: What Do you think would be better?
a) 2 x 146 GB SAS 15krpm disks as RAID 1
b) 4 x 73 GB SAS 15krpm disks, where we would put the index files on one partition, and the data files on the other? Would we gain a performance increase from that ? I’ve read something about that in the docs, but didn’t saw any benchmarkings about that ?
c) 5 x 73 GB SAS disks on a RAID 5 ( more spindles) ?
What do you think?
And what is your opinion about the processors? Should we stick to a one-processor server (e.g. instead of 2 x dual core xeon 2.3 GHz -> 1 x dual core xeon 1.6), and invest the money to more RAM? Would that be a better investment?