Can you share what you store in each of the databases? Here's what I'd speculate... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		alexpopescu on Nov 29, 2013 \| parent \| context \| favorite \| on: IRCCloud 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.

metabrew on Nov 29, 2013 [–]

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

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact