Find solution
Which is a better configuration for server?

Server Configuration for mysql database of social networking site?

  • I want to make a social networking website. The userbase is around to be 10000. For this I am using MySql Database. I want to know the configuration of the server for this like how much gz processor, and how much of RAM would be needed for that. Should I be using only dedicated server or shared server will work?? Any help will be appreciated.

  • Answer:

    It totally depends on your workload, such a simple description is insufficient to give anything but the most generic recommendation.

Stewart Smith at Quora Visit the source

Was this solution helpful to you?

Other answers

User base of size 10000 is actually quite small for asking questions like that. Since you have asked 2Gb RAM and normal 2.1GHz processor will be quite enough. Shared server will also work fine. If you get a free instance of Amazon EC2 that will work quite good and can be your dedicated server.

Neeraj Khandelwal

The question is quite vague in terms of DB size, table size, number of tables etc. Stewart is right, it depends on your workload and our application. You are the person who can decide the configuration perfectly. The best possible approach I can recommend is to use cloud services (Amazon RDS/EC2 or Rackspace) starting from 512MB/1GB instance and scale up/out as required. A simple tip would be to have more RAM than your MySQL indexes size.

Muhammad Wasif

It depends on the budget. A cloud hosted solutions is always preferred because it is easily scalable and flexible to move to other destination. There are many VPS providers at low cost. You can opt according to your solution. If you are using Ubuntu, you will need at least 1 GB RAM to have good performance. Less than that will slow down the application noticeably.

Hemant Shinde

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.