Re: Best way to Drop Tombstones/after GC Grace
Jeff, Thank you i got this- how about Dropping the existing Tombstones right now can setting gc_grace time to zero per Table level would be good or what would you suggest? On Wed, Mar 14, 2018 at 1:41 PM, Jeff Jirsa wrote: > What version of Cassandra? > > https://issues.apache.org/jira/browse/CASSANDRA-7304 sort of addresses > this in 2.2+ > > > > > On Wed, Mar 14, 2018 at 11:32 AM, Madhu-Nosql > wrote: > >> Rahul, >> >> Tomstone caused is on the Application driver side so even though they are >> not using some of the Columns in their logic >> waht they did is that they mentioned in driver logic that means if you >> are updateting one Column so the rest of the Columns so the driver >> automatically >> pick some nulls, internally behind the schnes cassandra threat them as a >> Tombstones >> >> On Wed, Mar 14, 2018 at 12:58 PM, Rahul Singh < >> rahul.xavier.si...@gmail.com> wrote: >> >>> Then don’t write nulls. That’s the root of the issue. Sometimes they >>> surface from prepared statements. Othertimes they come because of default >>> null values in objects. >>> >>> -- >>> Rahul Singh >>> rahul.si...@anant.us >>> >>> Anant Corporation >>> >>> On Mar 13, 2018, 2:18 PM -0400, Madhu-Nosql , >>> wrote: >>> >>> We assume that's becoz of nulls >>> >>> On Tue, Mar 13, 2018 at 12:58 PM, Rahul Singh < >>> rahul.xavier.si...@gmail.com> wrote: >>> >>>> Are you writing nulls or does the data cycle that way? >>>> >>>> -- >>>> Rahul Singh >>>> rahul.si...@anant.us >>>> >>>> Anant Corporation >>>> >>>> On Mar 13, 2018, 11:48 AM -0400, Madhu-Nosql , >>>> wrote: >>>> >>>> Rahul, >>>> >>>> Nodetool scrub is good for rescue, what if its happening all the time? >>>> >>>> On Tue, Mar 13, 2018 at 10:37 AM, Rahul Singh < >>>> rahul.xavier.si...@gmail.com> wrote: >>>> >>>>> Do you anticipate this happening all the time or are you just trying >>>>> to rescue? >>>>> >>>>> Nodetool scrub can be useful too. >>>>> >>>>> >>>>> -- >>>>> Rahul Singh >>>>> rahul.si...@anant.us >>>>> >>>>> Anant Corporation >>>>> >>>>> On Mar 13, 2018, 11:29 AM -0400, Madhu-Nosql , >>>>> wrote: >>>>> >>>>> I got few ways to Drop Tombstones- Chos Monkey/Zombie Data mainly to >>>>> avoid Data Resurrection (you deleted data it will comes back in >>>>> future) >>>>> >>>>> I am thinking of below options, let me know if you have any best >>>>> practice for this >>>>> >>>>> 1.using nodetool garbagecollect >>>>> 2.only_purge_repaired_tombstones >>>>> 3.At Table level making GC_Grace_period to zero and compact >>>>> >>>>> Thanks, >>>>> Madhu >>>>> >>>>> >>>> >>> >> >
Re: Best way to Drop Tombstones/after GC Grace
Rahul, Tomstone caused is on the Application driver side so even though they are not using some of the Columns in their logic waht they did is that they mentioned in driver logic that means if you are updateting one Column so the rest of the Columns so the driver automatically pick some nulls, internally behind the schnes cassandra threat them as a Tombstones On Wed, Mar 14, 2018 at 12:58 PM, Rahul Singh wrote: > Then don’t write nulls. That’s the root of the issue. Sometimes they > surface from prepared statements. Othertimes they come because of default > null values in objects. > > -- > Rahul Singh > rahul.si...@anant.us > > Anant Corporation > > On Mar 13, 2018, 2:18 PM -0400, Madhu-Nosql , wrote: > > We assume that's becoz of nulls > > On Tue, Mar 13, 2018 at 12:58 PM, Rahul Singh < > rahul.xavier.si...@gmail.com> wrote: > >> Are you writing nulls or does the data cycle that way? >> >> -- >> Rahul Singh >> rahul.si...@anant.us >> >> Anant Corporation >> >> On Mar 13, 2018, 11:48 AM -0400, Madhu-Nosql , >> wrote: >> >> Rahul, >> >> Nodetool scrub is good for rescue, what if its happening all the time? >> >> On Tue, Mar 13, 2018 at 10:37 AM, Rahul Singh < >> rahul.xavier.si...@gmail.com> wrote: >> >>> Do you anticipate this happening all the time or are you just trying to >>> rescue? >>> >>> Nodetool scrub can be useful too. >>> >>> >>> -- >>> Rahul Singh >>> rahul.si...@anant.us >>> >>> Anant Corporation >>> >>> On Mar 13, 2018, 11:29 AM -0400, Madhu-Nosql , >>> wrote: >>> >>> I got few ways to Drop Tombstones- Chos Monkey/Zombie Data mainly to >>> avoid Data Resurrection (you deleted data it will comes back in future) >>> >>> I am thinking of below options, let me know if you have any best >>> practice for this >>> >>> 1.using nodetool garbagecollect >>> 2.only_purge_repaired_tombstones >>> 3.At Table level making GC_Grace_period to zero and compact >>> >>> Thanks, >>> Madhu >>> >>> >> >
Re: Best way to Drop Tombstones/after GC Grace
We assume that's becoz of nulls On Tue, Mar 13, 2018 at 12:58 PM, Rahul Singh wrote: > Are you writing nulls or does the data cycle that way? > > -- > Rahul Singh > rahul.si...@anant.us > > Anant Corporation > > On Mar 13, 2018, 11:48 AM -0400, Madhu-Nosql , > wrote: > > Rahul, > > Nodetool scrub is good for rescue, what if its happening all the time? > > On Tue, Mar 13, 2018 at 10:37 AM, Rahul Singh < > rahul.xavier.si...@gmail.com> wrote: > >> Do you anticipate this happening all the time or are you just trying to >> rescue? >> >> Nodetool scrub can be useful too. >> >> >> -- >> Rahul Singh >> rahul.si...@anant.us >> >> Anant Corporation >> >> On Mar 13, 2018, 11:29 AM -0400, Madhu-Nosql , >> wrote: >> >> I got few ways to Drop Tombstones- Chos Monkey/Zombie Data mainly to >> avoid Data Resurrection (you deleted data it will comes back in future) >> >> I am thinking of below options, let me know if you have any best practice >> for this >> >> 1.using nodetool garbagecollect >> 2.only_purge_repaired_tombstones >> 3.At Table level making GC_Grace_period to zero and compact >> >> Thanks, >> Madhu >> >> >
Re: Best way to Drop Tombstones/after GC Grace
Rahul, Nodetool scrub is good for rescue, what if its happening all the time? On Tue, Mar 13, 2018 at 10:37 AM, Rahul Singh wrote: > Do you anticipate this happening all the time or are you just trying to > rescue? > > Nodetool scrub can be useful too. > > > -- > Rahul Singh > rahul.si...@anant.us > > Anant Corporation > > On Mar 13, 2018, 11:29 AM -0400, Madhu-Nosql , > wrote: > > I got few ways to Drop Tombstones- Chos Monkey/Zombie Data mainly to avoid > Data > Resurrection (you deleted data it will comes back in future) > > I am thinking of below options, let me know if you have any best practice > for this > > 1.using nodetool garbagecollect > 2.only_purge_repaired_tombstones > 3.At Table level making GC_Grace_period to zero and compact > > Thanks, > Madhu > >
Best way to Drop Tombstones/after GC Grace
I got few ways to Drop Tombstones- Chos Monkey/Zombie Data mainly to avoid Data Resurrection (you deleted data it will comes back in future) I am thinking of below options, let me know if you have any best practice for this 1.using nodetool garbagecollect 2.only_purge_repaired_tombstones 3.At Table level making GC_Grace_period to zero and compact Thanks, Madhu
Re: What snitch to use with AWS and Google
Kenneth, For AWS -EC2Snitch(if DC in Single Region) For Google- Better go with GossipingPropertyFileSnitch Thanks, Madhu On Mon, Mar 12, 2018 at 6:31 PM, Kenneth Brotman < kenbrot...@yahoo.com.invalid> wrote: > Quick question: If you have one cluster made of nodes of a datacenter in > AWS and a datacenter in Google, what snitch do you use? > > > > Kenneth Brotman >