Hi all, I'd like to store logs of my application into cassandra. I need to query logs by date (last X logs) or user (give me last X logs for user Y ) and I want to dispatch data among several servers.
I think the best design way is following : Each log identifier is a time based UUID. A CF with key = UUID / *Random Partitioner* will contain log message => allows me to split real data evenly between nodes A CF with key = UUID and *order*-*preserving partitioner * allow me to get last X logs A CF with key = userID and columns name are UUIDs (UUID sorted) => allow me to get last X logs of user Y Am I right ? Many thanks