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.