Sorry if this newbie question has been asked before. (I checked but couldn't find it).
I have just found that I can no longer run my web apps on the very reliable (no maintenance for me) in-house hosting server that I used because I exceeded my hard disk max allocation of just 2GB(!) and also I exceeded the active memory allocation which was just a few MBs. I have now been told that I have to setup my own server. So, what is the best server choice?
These are my needs:
- I need a server OS that is secure and requires minimal setup and management. (There is no IT professional around so I will have to do everything myself.)
- I need to run some php (later python?) web apps that drive a backend language corpus sqlite (later mysql) database of several GBs in size, that ideally I want to store entirely in active memory to speed us sorting of select results. In corpus database applications, often the select will produce many hundreds or thousands of results that have all to be sorted on multiple columns. (Indexing is essential but fast sorting is also key).
- I need to run a very low demand (but critical) Drupal content management system with probably less than 10,000 hits a week.
- (I don't need any file server, print server, email server functionality)
The current hosting server is Linux/Apache managed through cPanel. I'm looking at buying a server with 48GB of DDR3 RAM, Raid 1, and two SAS drives. (Is this completely overkill?)
The big question is should I go for Linux (e.g. CentOS, SME Server, or something equivalent) or Windows Server 2008 R2? Linux seems most suitable for php/mysql apps, but I wonder if Win Server 2008 R2 is easier to manage.
Any comments/advice would be greatly appreciated.