Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am wondering where to begin with database scaling/optimization strategies. After reading articles like highscalability.com'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.

share

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 stackoverflow.com Apr 12 '11 at 17:36

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

Browse other questions tagged or ask your own question.