Best specs for a Database Server?
I'm planning on getting a new server dedicated to my database (no site files or PHP will be used on the server). The database is very large, around 4 GB. My site is primarily a forum and gets 50,000+ people a day. So I need some advice on what kind of specs I should look for with a new server.
What operating system would be best?
How much RAM?
How much CPU?
Would RAID help?
What about an SSD hard drive?
I'll most likely be getting the server customized through hostgator.
What operating system would be best?
How much RAM?
How much CPU?
Would RAID help?
What about an SSD hard drive?
I'll most likely be getting the server customized through hostgator.
Aaron Tomosky
I've always seen MySQL run best on Linux. If you want something ready to go and scalable I'd suggest rackspace cloud servers, but it will probably work best if its on the Same LAN as your other server so they need to stay together.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
aarontomosky: Could you give me a reason why Linux?
johanntagle: Could you also give me a reason why I should choose Linux over windows?
Also, I heard that SSD hard drives only have a certain number of writes and they die, wouldn't the database be affected by this?
Thanks for all the info so far.
johanntagle: Could you also give me a reason why I should choose Linux over windows?
Also, I heard that SSD hard drives only have a certain number of writes and they die, wouldn't the database be affected by this?
Thanks for all the info so far.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.