NoSQL Zone is brought to you in partnership with:

Eric is the Editorial Manager at DZone, Inc. Feel free to contact him at egenesky@dzone.com Eric has posted 804 posts at DZone. You can read more from them at their website. View Full User Profile

Cassandra Column TTL Support in DSE Search

12.27.2012
| 1414 views |
  • submit to reddit

Alex Liu, of the Datastax Cassandra Developer Center, recently blogged about Cassandra's ability to support column TTL (time to live). He describes how Column TTL works, as well as how DSE search supports column TTL.  Here's what he has to say about the future - you can read the original post  here:

Good Practice to Set TTL Index Rebuilding Parameters

TTL index rebuilding does consume resources, e.g. cpu, memory and read Cassandra column families. You can make the re-indexing frequency to a longer time if there’s not much TTL data in Cassandra column families. For common use case, you need check the frequency of your compaction, and assign the re-indexing frequency to short than compaction frequency and match the re-indexing frequency to your business requirement.

Future Work

We may make TTL re-indexing per column family, and expose it to the administration page, so we can tune it for each column family. We may have a per index TTL which can be set through solr restful API. I believe those enhancement will be available in the feature.

We may also make Cassandra to support PUSH, so it can automatically re-index the data when column expired. Another thought is to have a row base TTL.

Published at DZone with permission of its author, Eric Genesky.

(Note: Opinions expressed in this article and its replies are the opinions of their respective authors and not those of DZone, Inc.)