Hello, We are working on some new cassandra requirements and I wanted to get your recommendations on how to go ahead and put schema in place in terms of how many CF one should have for below scenario:
1- There are 10 applications. Out of which 1 or 2 applications are very active giving 90%+ load. 2- Every application has 10-15 defined transaction types. 3- Transaction Data needs to be stored in cassandra that is categorized based on application (#1), transaction type (#2) and originating server. Size of each transaction data is 5KB. There can be max. of 250 million transactions per day. Transaction Data can be purged after 60 days. (There are no updates but only inserts) 4- Finally, Transaction Data Report need to be generated that can be rolled-up based on a timeline (could be past 5 mins upto max of 60 days) based on application, transaction type and/or originating server. Wanted to take the user group suggestion on how to decide on umber of CF and indexing option.
