Re: Guidelines for configuring Thresholds for Cassandra metrics

2016-08-29 Thread Ryan Svihla
Benedict I really don't want to turn this into a battle about who's opinion is more valid and I really respect all the good work you've done for Apache Cassandra. I'll just reiterate that I'm comfortable saying 0.6 is a good starting point and it is often not the ideal once you go through more t

Read timeouts on primary key queries

2016-08-29 Thread Joseph Tech
Hi, We recently started getting intermittent timeouts on primary key queries (select * from table where key=) The error is : com.datastax.driver.core.exceptions.ReadTimeoutException: Cassandra timeout during read query at consistency LOCAL_QUORUM (2 responses were required but only 1 replica a re

Re: Read timeouts on primary key queries

2016-08-29 Thread Patrick McFadin
You aren't achieving quorum on your reads as the error is explains. That means you either have some nodes down or your topology is not matching up. The fact you are using LOCAL_QUORUM might point to a datacenter mis-match on node count + RF. What does your nodetool status look like? Patrick On M

Output of "select token from system.local where key = 'local' "

2016-08-29 Thread Siddharth Verma
Hi, Could someone help me understand the output of the following command select token from system.local where key = 'local'; I guess, it shows a set of tokens, How to interpret the primary token range owned by that particular node. Sample output {'-1035756551821816651', '-108957861241888777', '-11

Re: Output of "select token from system.local where key = 'local' "

2016-08-29 Thread Eric Zietlow
Siddharth, This is the tokens assigned to your local node. It looks from this that you have 256 vnodes set. The system.local only stored information on the local node. Thanks, Eric Zietlow On Mon, Aug 29, 2016 at 5:32 PM, Siddharth Verma < verma.siddha...@snapdeal.com> wrote: > Hi, > Could s

Re: Output of "select token from system.local where key = 'local' "

2016-08-29 Thread Siddharth Verma
Hi Eric, Thanks for your reply. I know about V nodes, and token ownership. If I want to find the token range, how do i do that from this data? For eg, the 1st entry is -1035756551821816651. which range is it, i.e. is this the start/end, and how to find the other extremity of this range. Thanks, Si

Bootstrapping multiple C* nodes in AWS

2016-08-29 Thread Aiman Parvaiz
Hi all I am running C* 2.1.12 in AWS EC2 Classic with RF=3 and vnodes(256 tokens/node). My nodes are distributed in three different availability zones. I want to scale up the cluster size, given the data size per node it takes around 24 hours to add one node. I wanted to know if its safe to add mu

Re: Bootstrapping multiple C* nodes in AWS

2016-08-29 Thread Ben Slater
Hi Aiman, Best practice would be to map cassandra racks to AWS availability zones. If you are following this then you would add one node per AZ to keep the number of nodes in each rack balanced. It is technically possible to add multiple nodes simultaneously (at least joining simultaneously - you

Re: Bootstrapping multiple C* nodes in AWS

2016-08-29 Thread Jeff Jirsa
Related reading: https://issues.apache.org/jira/browse/CASSANDRA-2434 and   https://issues.apache.org/jira/browse/CASSANDRA-7069 From: Ben Slater Reply-To: "user@cassandra.apache.org" Date: Monday, August 29, 2016 at 11:48 PM To: "user@cassandra.apache.org" Subject: Re: Bootstrapping mult