Solved

Best specs for a Database Server?

Posted on 2013-01-25
5
275 Views
Last Modified: 2013-02-04
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.
0
Comment
Question by:davideo7
  • 2
  • 2
5 Comments
 
LVL 38

Expert Comment

by:Aaron Tomosky
ID: 38821459
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.
0
 
LVL 24

Accepted Solution

by:
johanntagle earned 334 total points
ID: 38821744
What operating system would be best?

Linux.

How much RAM?

Assuming your tables are innodb, it's ideal to be able cache all your tables and indexes in memory.  So go for 8GB (more than enough for DB plus system processes).

How much CPU?

I wouldn't worry so much on this one.  Most of the time if a web app is eating a lot of CPU, more CPU is not the solution, application and database tuning is.  To give you an idea, I manage a 120GB database of a very busy website - CPU utilization peaks at 10% of an 8-core machine (we got that machine more for a large memory support).

Would RAID help?
What about an SSD hard drive?

Yes and Yes.

Having said that, none of these will do you any good if you do not tune your database instance.  I always point people to the following links to get them started with this:

http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/
http://blog.codesherpas.com/on_the_path/2011/03/tuning-mysql.html
0
 

Author Comment

by:davideo7
ID: 38838731
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.
0
 
LVL 24

Assisted Solution

by:johanntagle
johanntagle earned 334 total points
ID: 38838831
It's free.

Many people who have compared the performance of MySQL on the two platforms didn't notice any real difference, though in some case while the response time was the same the linux server was utilizing less CPU vs it's windows counterpart that was running on hardware with same specs (see bottom comment at http://www.webmasterworld.com/forum112/24.htm)

Also see some Windows-specific MySQL limitations at http://dev.mysql.com/doc/refman/5.5/en/limits-windows.html

Also, I believe there are more malware that exploit Windows vulnerabilities vs Linux.

Again, Linux is free.... so why spend on windows if you are not going to gain anything?  Unless, of course Windows is what you are familiar with.  If you have never touched Linux before and you are not the adventurous type, then by all means choose Windows because you need to be productive.

Re SSD - of course is a drive dies, your database is affected.  But I very much doubt that statement regarding their lifespan otherwise they won't be so popular now.
0
 
LVL 38

Assisted Solution

by:Aaron Tomosky
Aaron Tomosky earned 166 total points
ID: 38839850
All I said was that MySQL runs faster on Linux. I can't explain why as I don't know enough about that sort of low level thing.

Honestly unless you want to be patching and securing your own server, why not just get a rackspace cloud server with the ram you need? Those things have ridiculous connections and I've never had a load the storage couldn't handle
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Alternative access for remote users 6 40
shadow copies 7 16
DNS Scavenging configuration 5 19
VMware Black Screen 13 28
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now