Would like to ask for suggestion / recommendation for Compaction for Cassandra, what is the default used? and for transaction with more heavy on the read transaction what is the compaction to be used? How about for balanced 50-50 between read and write, what are the compaction to be used?
Really appreciate your inputs.
Thanks & regards,