As a lone developer in my company I'm missing someone to bounce ideas off with. I've been given the task of gathering some hardware requirements for our server so we can make some internal websites public facing.
Current hardware is
SRV1 - Stats processor.
Windows server 2003 Intel Xeon CPU 3.00ghz 1 gig RAM 512 gig mirrored raid drives
SRV2 - Currently being used to replicate certain tables.
Windows Server 2003 Intel Pentium 4 1200MHZ 1.00 gig RAM 40 gig harddrive
The current traffic stats of SRV1 are
Traffic 1 ø per hour Received 149 GiB 1,034 MiB Sent 445 GiB 3,096 MiB Total 594 GiB 4,130 MiB
The machine is running wamp stack. There's a couple of simple java based programs which are doing reads and writes to the database.
Loads data into myisam table -> Runs select only queries on myisam table and use information to insert and update a large InnoDB table. -> Summarises the data (insert and on duplicate key update query) in the large InnoDB table (currently 7.5 GiB 13 mill records ) into smaller InnobDB tables (largest 2 gig 2,016,166 records) for fast read access.
Reads the smaller InnoDB tables to do some alerting/reporting of the data they contain.
Read only access to the smaller InnoDB tables both internally and externally.
I don't believe the server will have a vast number of connections via the web server even when we off the data stored inside these tables out to customers. So I'm not too concerned about that, I'm more concerned about speed of access to the data.
So, to summarise this stupidly long question.
What would people recommend in terms of OS/RAM/Hard drives/Raid/ Processors. I'm guessing the answer is going to be get the best you can afford. But I'll admit I'm a bit clueless as to what they best I could afford in things such as ram/raid/processing/harddrives is and how much things should cost.
Any extra advice anyone has to spare would be greatly appreciated.
Thanks in advance