Scaling an RDBMS in 6 Steps
From Gavin Heavyside’s slides:
- Launch successful service
- Read saturation: add caching
- Write saturation: add hardware
- Queries slow down: denormalize
- Reads still too slow: prematerialise common queries, stop joining
- Writes too slow: drop secondary indexes and triggers
Original title and link: Scaling an RDBMS in 6 Steps (NoSQL databases © myNoSQL)