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

I am wondering where to begin with database scaling/optimization strategies. After reading articles like's facebook architecture article, and this twitter architecture article, I am not sure if by RAM they mean only memcached, or something else.

My questions are:

  • Can entire SQL databases be stored in RAM? I'm thinking sharding and all that here... Just learning (not from a db background).
  • Are SQL database indexes stored in RAM?
  • Are NOSQL databases stored in RAM? Can they be?
  • Or is Memcached the standard for storing things in RAM? So 99% of requests read from RAM (Memcached), and the database (disk) is a backup?

Just looking for a point in the right direction.


merged by sysadmin1138 Apr 12 '11 at 18:43

This question was merged with What does it mean when Twitter says their entire database is in RAM? because it is an exact duplicate of that question.

migrated from Apr 12 '11 at 17:36

This question came from our site for professional and enthusiast programmers.