This question already has an answer here:
I need a solution for social networking webapp, the DB structure is
- users - login credentials.
- user_order - user orders.
- 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.
- Should I use MySql or NoSQL?
- Does MySql or NoSql impact the server performance?
- What should be server's configuration?