At Posterous we use MySQL as a main data store but MongoDB for simple analytics and Redis for set operations around contacts and subscriptions.

Redis is also great as a backing store for the Rails queuing system Resque.