Hacker News new | ask | show | jobs
by alexpopescu 4578 days ago
Can you share what you store in each of the databases?

Here's what I'd speculate:

- Redis: message lists for active users

- Postgres: account details

- Cassandra: all messages

Thanks.

1 comments

Yep, postgres has all the account / user details, lists of what network and channels to join, billing etc.

All the irc messages end up in cassandra, via rabbitmq. We use local redis as a cache for the most recent messages. Our cassandra cluster is on EC2 (~11ms away from our other hardware, which is in LA).