How to scale when database gets huge?
Some suggested reading for you:


http://highscalability.com/  The greatest blog ever in regards to scaling websites.  Tons of fantastic information there.
Read about sharding.  http://en.wikipedia.org/wiki/Shard_(database_architecture)