RE: Slender Cassandra Cluster Project

For Slender Cassandra (an 18 node cluster for illustrating best practices) to communicate between regions I seem to have three choices for Amazon Web Services: 1. VPN 2. VPN Peering 3. Over the world wide web What is the correct choice? This article on best practices for running Cassandra on

Re: Current active queries and status/type

Hi Nicolas, Thank you very much for the response. I am looking into something with a smaller time frame than a minute. Tracing is a good way to get these information but it introduces a huge overhead in the system that I'd like to avoid it. Thanks Salvatore 2018-03-01 15:08 GMT+00:00 Nicolas

Cassandra 2.1.18 - Concurrent nodetool repair resulting in > 30K SSTables for a single small (GBytes) CF

Hello, Production, 9 node cluster with Cassandra 2.1.18, vnodes, default 256 tokens, RF=3, compaction throttling = 16, concurrent compactors = 4, running in AWS using m4.xlarge at ~ 35% CPU AVG We have a nightly cronjob starting a "nodetool repair -pr ks cf1 cf2" concurrently on all nodes,

Re: Current active queries and status/type

Hi, With org.apache.cassandra.metrics:type=ClientRequest,scope=Read,name=Latency and OneMinuteRate you can have such a metrics As for the state of the request with regards to other node I do no think you can have that IMHO with JMX (this is available using TRACING per request) On 1 March 2018

Current active queries and status/type

Hello! There is any way to know how many queries a node is currently serving through JMX(or other tools)? And the state of the request so, for example, if the request is waiting for data from another node? Thanks Salvatore

Re: Cassandra filter with ordering query modeling

https://www.slideshare.net/doanduyhai/datastax-day-2016-cassandra-data-modeling-basics On Thu, Mar 1, 2018 at 3:48 PM, Valentina Crisan wrote: > 1) I created another table for Query#2/3. The partition Key was StartTime > and clustering key was name. When I execute

Re: Cassandra filter with ordering query modeling

1) I created another table for Query#2/3. The partition Key was StartTime and clustering key was name. When I execute my queries, I get an exception saying that I need to ALLOW FILTERING. *Primary key(startTime,name) - the only queries that can be answered by this model are: where startTime = ,

Re: Cassandra filter with ordering query modeling

Thank you for your response. I have been through the document and I have tried these techniques but I failed to model my queries correctly. Forexample, I have already tried the following: 1) I created another table for Query#2/3. The partition Key was StartTime and clustering key was name. When

Re: Cassandra filter with ordering query modeling

Hi! Partition key (Id in your case) must be in WHERE cause if not using indexes (but indexes should be used carefully, not like in case of relational DB's). Also, only columns which belong to primary key ( = partition key + clustering key) can be used in WHERE in such cases. That's why 2nd and

Cassandra filter with ordering query modeling

Hi,own vote favorite I am new to Cassandra and I am trying to model a table in Cassandra. My queries look like the following Query #1: select * from TableA where Id = "123"Query #2: select * from TableA

Re: JMX metrics for CL

Thank you so much, Eric! From: Eric Evans Sent: Wednesday, February 28, 2018 6:26:23 PM To: user@cassandra.apache.org Subject: Re: JMX metrics for CL On Tue, Feb 27, 2018 at 2:26 AM, Kyrylo Lebediev

RE: The home page of Cassandra is mobile friendly but the link to the third parties is not

Thanks Nicolas. That worked. Definitely overlap. Nice work on hints and read repair Kurt. I added the relevant proposed text to Issue #’s 14270 and 14271. Kenneth Brotman From: Nicolas Guyomar [mailto:nicolas.guyo...@gmail.com] Sent: Thursday, March 01, 2018 1:42 AM To:

RE: Filling in the blank To Do sections on the Apache Cassandra web site

I’ve got Sphinx on my PC, in a VirtualBox image and going in a Docker container. I’m tickering with it to figure out the best set up going forward. If the VirtualBox image ends up easy to use I might add an image file to the repository for others. I’m really wanting to get the

Re: The home page of Cassandra is mobile friendly but the link to the third parties is not

Works for me : https://issues.apache.org/jira/browse/CASSANDRA-14128 On 1 March 2018 at 10:36, Kenneth Brotman wrote: > The link for 14128 doesn’t work and I can’t find it anywhere. > > > > Kenneth Brotman > > > > *From:* kurt greaves [mailto:k...@instaclustr.com]

RE: The home page of Cassandra is mobile friendly but the link to the third parties is not

The link for 14128 doesn’t work and I can’t find it anywhere. Kenneth Brotman From: kurt greaves [mailto:k...@instaclustr.com] Sent: Wednesday, February 28, 2018 8:39 PM To: User Subject: Re: The home page of Cassandra is mobile friendly but the link to the third parties is not