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.
Here's what I'd speculate:
- Redis: message lists for active users
- Postgres: account details
- Cassandra: all messages
Thanks.
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).