I am trying to determine compaction strategy for our use case.
In our use case we will have updates on a row a few times. And we have a
ttl also defined on the table level.
Our typical workload is less then 1000 writes + reads per second. At the
max it could go up to 2500 per second.
We use SSD and have around 64 gb of ram on each node. Our cluster size is
around 70 nodes.
I looked at time series but we cant guarantee that the updates will happen
within a give time window. And if we have out of order updates it might
impact on when we remove that data from the disk.
So i was looking at level tiered, which supposedly is good when you have
updates. However its io bound and will affect the writes. everywhere i read
it says its not good for write heavy workload.
But Looking at our write velocity, is it really write heavy ?
I guess what i am trying to find out is will level tiered compaction will
impact the writes in our use case or it will be fine given our write rate
is not that much.
Also is there anything else i should keep in mind while deciding on the