I have read multiple questions where it was explained that it is not ideal to run a manual compaction on Cassandra tables using SizeTieredCompactionStrategy. Also, it was noted that running the manual compaction even once would mean that we need to continue to do it manually going forward as well. So the temporary solution was given to split the output files.
My question is based on a weird scenario my team is in: There are 5 tables in the keyspace:
--- 4 of the tables are very small tables (5-10GB size) and use STCS
--- 1 large table (will reach 1-3 TB eventually) is using LCS. We decided on this compactionstrategy because this table is going to have lot of updates compared to inserts.
So, we have already run nodetool compact manually for this keyspace. Given this situation, I have the following questions.
1. Is it even recommended to have tables with different compaction strategy in the same keyspace? Does Compaction run into any issues for this keyspace as we have tables with different strategies?
2. Is it right to believe that LCS is the better option for the large table mentioned above?
3. Since we already executed compaction manually for the keyspace, do we have to keep doing this going forward? Is this applicable for both STCS and LCS based tables?
Your suggestions and inputs are greatly appreciated.