Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

This question already has an answer here:

I need a solution for social networking webapp, the DB structure is

  1. users - login credentials.
  2. user_order - user orders.
  3. user_friends - user friends.

We expect a solution to handle 100 million users, whenever user logins I will have to query all the 3 tables. XMPP will be used as messaging server for users to chat.

  1. Should I use MySql or NoSQL?
  2. Does MySql or NoSql impact the server performance?
  3. What should be server's configuration?
share|improve this question

marked as duplicate by Jenny D, Tom O'Connor, RobM, Lucas Kauffman, Iain May 9 '13 at 9:03

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

Neither. Postgres. – Tom O'Connor May 9 '13 at 8:16

I will advice you to hire a team of experienced database consultants. This is not a simple question which can be answered on serverfault.

First of all what type of NoSQL? Do you need integrity for your data? What will the database store, how much will it store, how intensive are the queries? If you have to ask such questions here you are already out of your league.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.