Re: Multi-column range scans

;>> Sorry, I've just checked, the correct query should be: >>>> >>>> select * from skill_count where skill='Complaints' and >>>> (interval_id,skill_level) >= (140235930,5) and >>>> (interval_id,skill_level) <

Multi-column range scans

Hi, We have a roll-up table that as follows. CREATE TABLE SKILL_COUNT ( skill text, interval_id bigint, skill_level int, skill_count int, PRIMARY KEY (skill, interval_id, skill_level)); Essentially, skill = a names skill i.e. "Complaints" interval_id = a rounded epoch time (15 minu

Re: problem removing dead node from ring

PM, Matthew Allen > wrote: > >> Just out of curiosity, for a dead node, would it be possible to just >> >> - replace the node (no data in data/commit dirs), same IP Address, same >> hostname. >> - restore the cassandra.yaml (initial_token etc) >> - set auto_boo

Re: Multi-DC Environment Question

Thanks Vasileios. I think I need to make a call as to whether to switch to vnodes or stick with tokens for my Multi-DC cluster. Would you be able to show a nodetool ring/status from your cluster to see what the token assignment looks like ? Thanks Matt On Wed, Jun 4, 2014 at 8:31 AM, Vasileio

Re: problem removing dead node from ring

Just out of curiosity, for a dead node, would it be possible to just - replace the node (no data in data/commit dirs), same IP Address, same hostname. - restore the cassandra.yaml (initial_token etc) - set auto_bootstrap:false - start it up and then run a nodetool rebuild ? Or would the Host

Re: Multi-DC Repairs and Token Questions

o be different. > try "Describe keyspace SN_KEYSPACE" and "describe keyspace MY_KEYSPACE" > from CQL. > This will give you an idea about how many replicas are there for these > keyspaces. > > > > On Wed, May 28, 2014 at 11:49 AM, chovatia jaydeep < >

Re: Multi-DC Environment Question

Hi Vasilis, With regards to Question 2. * | How tokens are being assigned when adding a 2nd DC? Is the range -2^64 to 2^63 for each DC, or it is -2^64 to 2^63 for the entire cluster? (I think the latter is correct), * Have you been able to deduce an answer to this (assuming Murmur3 Part

Multi-DC Repairs and Token Questions

Hi, Am a bit confused regarding data ownership in a multi-dc environment. I have the following setup in a test cluster with a keyspace with (placement_strategy = 'NetworkTopologyStrategy' and strategy_options = {'DC_NSW':2,'DC_VIC':2};) Datacenter: DC_NSW == Replicas: 2 Address R

Changing replication strategies

Hi all. To move to a multi-dc setup, I am in the process of preparing our independent production DC's. Part of this means moving from SimpleStragtegy (RF=5) to NetworkTopologyStrategy, but I'm still a bit confused as to some core aspects of replication. The setup will be basic, - DC_NSW will co

Multi-site Active-Active replication - Maintenance Commands

Hi all, We currently run a script that runs the following on our separate clusters each night. The script operates on 3 nodes (out of 9) a night to minimize impact to the cluster. repair -pr compact cleanup These separate clusters are going to start replicating between each other within a

Re: Multi-site Active-Active replication - Preparing Sites - Cluster Name and Snitch

tax > (404) 822 3487 > <http://www.linkedin.com/in/jlacefield> > > > <http://www.datastax.com/what-we-offer/products-services/training/virtual-training> > > > On Sun, Mar 16, 2014 at 10:39 PM, Matthew Allen > wrote: > >> Hi all, >> >> New to

Multi-site Active-Active replication - Preparing Sites - Cluster Name and Snitch

Hi all, New to this list, so apologies in advance if I in inadvertently break some of the guidelines. We currently have 2 geographically separate Cassandra/Application clusters (running in active/warm-standby mode), that I am looking to enable replication between so that we can have an active/act