top | item 6821161

(no title)

alexpopescu | 12 years 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.

discuss

order

metabrew|12 years ago

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).