Re: Questions on time series use case, tombstones, TWCS

2017-08-09 Thread Jeff Jirsa
The deleting compaction strategy from protectwise (https://github.com/protectwise/cassandra-util/blob/master/deleting-compaction-strategy/README.md) was written (I believe) to solve a similar problem - business based deletion rules to enable flexible TTLs. May want to glance at that. Other

Re: JOB | Permanent Database Engineer (the Netherlands)

2017-08-09 Thread Chuck Reynolds
Tell me more. On 8/8/17, 10:44 PM, "James Tobin" wrote: Hello, I'm working with an employer that is looking to hire someone to become their lead on Apache Cassandra in the Netherlands. Consequently I had hoped that some members of this mailing list may

Re: Questions on time series use case, tombstones, TWCS

2017-08-09 Thread kurt greaves
> > With STCS, estimated droppable tombstones being always 0.0 (thus also no > automatic single SSTable compaction may happen): Is this a matter of not > writing with TTL? If yes, would enabling TTL with STCS improve the disk > reclaim situation, cause then single SSTAble compactions will kick in?

Questions on time series use case, tombstones, TWCS

2017-08-09 Thread Steinmaurer, Thomas
Hello, our top contributor from a data volume perspective is time series data. We are running with STCS since our initial production deployment in 2014 with several clusters with a varying number of nodes, but currently with max. 9 nodes per single cluster per different region in AWS with