offline node copy

Hi all. I have running cassandra cluster and i want add new node in new datanenter(need 100% of data). But i don't want full data copy by network. Can i copy data manually and then sync new node to cluster? Something like: 1. Make snapshot on working node and write to external drive. 2. Restore

Re: Is it possible to bootstrap the 1st node of a new DC?

> > > I've learned from experience that the node immediately joins the cluster, >> and starts accepting reads (from other DCs) for the range it owns. > > > This seems to be the incorrect assumption at the heart of the confusion. > You "should" be able to prevent this behavior entirely via correct

Re: Question about consistency

Interesting. I'll give it a try and report back my findings. Thank you, Michael. On Wednesday, September 9, 2015, Laing, Michael wrote: > Perhaps a variation on > https://issues.apache.org/jira/browse/CASSANDRA-9753? > > You could try setting speculative retry to 0

Re: Question about consistency

What are your read repair settings? On Tue, Sep 8, 2015 at 9:28 PM, Eric Plowe wrote: > To further expand. We have two data centers, Miami and Dallas. Dallas is > our disaster recovery data center. The cluster has 12 nodes, 6 in Miami and > 6 in Dallas. The servers in

Re: Question about consistency

Perhaps a variation on https://issues.apache.org/jira/browse/CASSANDRA-9753? You could try setting speculative retry to 0 to avoid cross-dc reads. On Wed, Sep 9, 2015 at 7:55 AM, Eric Plowe wrote: > read_repair_chance: 0 > dclocal_read_repair_chance: 0.1 > > > On

Re: Question about consistency

read_repair_chance: 0 dclocal_read_repair_chance: 0.1 On Wednesday, September 9, 2015, Laing, Michael wrote: > What are your read repair settings? > > On Tue, Sep 8, 2015 at 9:28 PM, Eric Plowe

Re: Question about consistency

Would this work: ALTER TABLE session_state WITH speculative_retry = '0ms'; ALTER TABLE session_state WITH speculative_retry = '0PERCENTILE'; I can't set it to 0, but was wondering if these would have the same effect? ~Eric On Wed, Sep 9, 2015 at 8:19 AM, Eric Plowe

Re: Question about consistency

Yeah, that's what I did. Just wanted to verify it that will indeed turn it off. On Wednesday, September 9, 2015, Laing, Michael wrote: > "alter table test.test_root WITH speculative_retry = '0.0PERCENTILE';" > > seemed to work for me with C* version 2.1.7 > > On Wed,

Re: Trace evidence for LOCAL_QUORUM ending up in remote DC

Thanks for reporting back, Tom. Can you drop a comment on the ticket with a sentence or two describing your specific case and that speculative_retry = NONE was a valid work-around? That will make it easier for the next folks that come along to have a concrete problem/solution in a single comment

Should replica placement change after a topology change?

Good afternoon, I am investigating various topology changes, and their effect on replica placement. As far as I can tell, replica placement is not changing after I’ve changed the topology and run nodetool repair + cleanup. I followed the procedure described at

Tomorrow: Free webinar on Times series IoT data ingestion into Cassandra using Kaa

[image: Time series IoT data ingestion into Cassandra using Kaa] During this webinar, we will build a solution that ingests

Re: offline node copy

wont ur data be out of sync? On Wed, Sep 9, 2015 at 2:19 AM, a a wrote: > Hi all. > > I have running cassandra cluster and i want add new node in new > datanenter(need 100% of data). > But i don't want full data copy by network. > Can i copy data manually and then sync new

Re: Question about consistency

"alter table test.test_root WITH speculative_retry = '0.0PERCENTILE';" seemed to work for me with C* version 2.1.7 On Wed, Sep 9, 2015 at 10:11 AM, Eric Plowe wrote: > Would this work: > > ALTER TABLE session_state WITH speculative_retry = '0ms'; > ALTER TABLE

Re: Question about consistency

It appears that: "alter table test.test_root with speculative_retry = 'NONE';" is also valid. Seems a bit more definitive :) On Wed, Sep 9, 2015 at 12:11 PM, Eric Plowe wrote: > Yeah, that's what I did. Just wanted to verify it that will indeed turn it > off. > > On

Re: Should replica placement change after a topology change?

On Wed, Sep 9, 2015 at 7:52 AM, Richard Dawe wrote: > I am investigating various topology changes, and their effect on replica > placement. As far as I can tell, replica placement is not changing after > I’ve changed the topology and run nodetool repair + cleanup. I

Re: Question about consistency

On Wed, Sep 9, 2015 at 12:07 PM, Eric Plowe wrote: > So I set speculative_retry to NONE and I encountered the situation about > 30 minutes ago. I presume your clocks are synced, and if so that sounds like unexpected behavior. So if you have a means of repro, I would : 1)

Re: offline node copy

On Wed, Sep 9, 2015 at 12:19 AM, a a wrote: > I have running cassandra cluster and i want add new node in new > datanenter(need 100% of data). > But i don't want full data copy by network. > Can i copy data manually and then sync new node to cluster? > tl;dr - "yes"

Re: Is it possible to bootstrap the 1st node of a new DC?

On Wed, Sep 9, 2015 at 1:05 AM, Tom van den Berge wrote: > >> I've learned from experience that the node immediately joins the cluster, >>> and starts accepting reads (from other DCs) for the range it owns. >> >> >> This seems to be the incorrect assumption at the

Re: What is your backup strategy for Cassandra?

On Sun, Sep 6, 2015 at 12:32 AM, Gene wrote: > I've seen quite a few blog posts here and there about various back up > strategies. I'm wondering if anyone on this list would be willing to share > theirs. > https://github.com/JeremyGrosser/tablesnap > Things I'm curious

Re: SELECT DISTINCT and rows with only static columns

On Fri, Sep 4, 2015 at 5:30 PM, Kay Johansen wrote: > > Now that I know this I can plan for this, but I'm wondering why this is > the case so I can understand the underlying mechanism. > While it's not impossible that a question of this nature will be answered on

Re: Basic QA : Cassandra +Solr

On Sat, Sep 5, 2015 at 3:59 AM, Samya Maiti wrote: > >- Is the data shored in Cassandra & Solr(documents) separately? If so >how much extra space is required in disk? > > I don't know the answer to this, because built in Solr support is a feature of DSE, a

High CPU usage on some of nodes

Hey guys, We've been having issues in the past couple of days with CPU usage / load average suddenly skyrocketing on some nodes of the cluster, affecting performance significantly so majority of requests start timing out. It can go on for several hours, with CPU spiking through the roof then

Upgrade Limitations Question

Hello All, I've asked this on the Cassandra IRC channel earlier, but I am asking the list as well so that I get feedback from more people. We have recently upgraded from Cassandra 1.2.19 to 2.0.16 and we are currently in the stage where all boxes are running 2.0.16 but nt upgradesstables has not

Re: Question about consistency

So I set speculative_retry to NONE and I encountered the situation about 30 minutes ago. On Wednesday, September 9, 2015, Laing, Michael wrote: > It appears that: "alter table test.test_root with speculative_retry = > 'NONE';" is also valid. > > Seems a bit more

Re: Question about consistency

Wiser heads may have to chime in then :) On Wed, Sep 9, 2015 at 3:07 PM, Eric Plowe wrote: > So I set speculative_retry to NONE and I encountered the situation about > 30 minutes ago. > > > > On Wednesday, September 9, 2015, Laing, Michael >