cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eric Tamme <eta...@gmail.com>
Subject Re: Using ttl to expire columns rather than using delete
Date Wed, 12 Oct 2011 13:21:05 GMT
On 10/11/2011 09:49 PM, Terry Cumaranatunge wrote:
> Hello,
> If you set a ttl and expire a column, I've read that this eventually 
> turns into a tombstone and will be cleaned out by the GC. Are 
> expirations considered a form of delete that still requires a node 
> repair to be run in gc_grace_period seconds? The operations guide says 
> you have to run node repair if you have deletes, so I'm trying to find 
> out if we can upsert the column with expirations using a ttl=1 to 
> substitute deletes. The node repair operations is very intensive in 
> our environment and causes a significant performance degradation on 
> the system.
> Thanks

No - if you only use TTL to expire data, and no actual deletes or 
updates on the ttl, then you generally do not need to do a nodetool repair.

I run two clusters that have rolling data sets relying on TTL that have 
been running for months without any issues and have never run nodetool 
repair.

-Eric

Mime
View raw message