At dotCloud we use PostgreSQL, Riak and redis.

- PostgreSQL for the user database since it maps nicely to django and sqlalchemy models

- Redis for caches and non persistent data

- Riak for everything else

We love the fact that it is easy to scale, that bitcask is safe (it writes to disk:-p) and easy to backup (rsync or cp is enough).