JMX metrics for CL

Hello! Is it possible to get counters from C* side regarding CQL queries executed since startup for each CL? For example: CL ONE: NNN queries CL QUORUM: MMM queries etc Regards, Kyrill

Driver consistency issue

Hi All, i have a KeySpace in Cassandra (cassandra version 3.0.9- total 12 Servers )With below definition: {'DC1': '2', 'class': 'org.apache.cassandra.locator.NetworkTopologyStrategy'} Some time i am getting below exception com.datastax.driver.core.exceptions.WriteTimeoutException: Cassandra tim

Re: Driver consistency issue

On Tue, Feb 27, 2018 at 9:45 AM, Abhishek Kumar Maheshwari < abhishek.maheshw...@timesinternet.in> wrote: > > i have a KeySpace in Cassandra (cassandra version 3.0.9- total 12 Servers > )With below definition: > > {'DC1': '2', 'class': 'org.apache.cassandra.locator. > NetworkTopologyStrategy'} > >

Re: Driver consistency issue

Hi Alex, i have only One DC (with name DC1) and have only one keyspace. So i dont think so both of the scenario is possible. (yes in my case QUORUM is equivalent of ALL) cqlsh> SELECT * FROM system_schema.keyspaces where keyspace_name='adlog' ; keyspace_name | durable_writes | replication

Re: Tracing cql code being run through the drive

I think you are looking for this: https://docs.datastax.com/en/developer/java-driver/2.1/manual/logging/#logging-query-latencies You can use com.datastax.driver.core.QueryLogger.NORMAL /SLOW /ERROR to see the queries executed. We are using only slow & error logs in production. Normal is good for d

Re: Driver consistency issue

Hi, Adding the java-driver ML for further question, because this does look like a bug Are you able to reproduce it a clean environnement using the same C* version and driver version ? On 27 February 2018 at 10:05, Abhishek Kumar Maheshwari < abhishek.maheshw...@timesinternet.in> wrote: > Hi Al

RE: Cassandra Summit 2019 / Cassandra Summit 2018

Event planning is fun as long as you can pace it out properly. Once you set a firm date for an event the pressure on you to keep everything on track is nerve racking. To do something on the order of Cassandra Summit 2016, I think we are should plan for 2020. It’s too late for 2018 and even tr

Re: Cassandra Summit 2019 / Cassandra Summit 2018

Hello all, I'm interested planning/organizing a small kinda of NGCC in Lisbon, Portugal in late May early June. Just waiting for the venue to confirm possible dates. Would be a 1day event kinda last year, is this something people would be interested? I can push a google form for accessing the int

Re: Driver consistency issue

Hi, Not always. Randomly i am getting this exception. (one observation, mostly i got this exception when i add new node in cluster.) On Tue, Feb 27, 2018 at 4:29 PM, Nicolas Guyomar wrote: > Hi, > > Adding the java-driver ML for further question, because this does look > like a bug > > Are you

Re: Driver consistency issue

Hi Abhishek & everyone else, might it be related to https://issues.apache.org/jira/browse/CASSANDRA-7868 ? regards, Christian On Tue, Feb 27, 2018 at 12:46 PM, Abhishek Kumar Maheshwari < abhishek.maheshw...@timesinternet.in> wrote: > Hi, > > Not always. Randomly i am getting this exception.

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

Might help, organizationally, to put all these efforts under a single ticket of "Improve web site Documentation" and add these as sub-tasks. Should be able to do that translation post-creation (i.e. in its current state) if that's something that makes sense to you. On Mon, Feb 26, 2018 at 5:24 PM,

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

I was debating that. Splitting it up into smaller tasks makes each one seem less over-whelming. Kenneth Brotman From: Josh McKenzie [mailto:jmcken...@apache.org] Sent: Tuesday, February 27, 2018 5:44 AM To: cassandra Subject: Re: Filling in the blank To Do sections on the Apache Cassan

Version Rollback

Hi All, I'm planning to upgrade my C* cluster to version 3.x and was wondering what's the best way to perform a rollback if need be. If I used snapshot restoration, I would be facing data loss, depends when I took the snapshot (i.e. a rollback might be required after upgrading half the cluster fo

RE: Version Rollback

Could you tell us the size and configuration of your Cassandra cluster? Kenneth Brotman From: shalom sagges [mailto:shalomsag...@gmail.com] Sent: Tuesday, February 27, 2018 6:19 AM To: user@cassandra.apache.org Subject: Version Rollback Hi All, I'm planning to upgrade my C* cluster t

Re: Cassandra Summit 2019 / Cassandra Summit 2018

I can help organize. I organize three meetups in the area here and know several venues that would be able to lend space if needed. We can host about 20-30 people at our office or get a location through a coworking spot / one of the universities ( Georgetown or George Washington) The community s

Jon Haddad on Diagnosing Performance Problems in Production

One presentation that I hope can get updated is Jon Haddad's very thorough presentation on Diagnosing Performance Problems in Production. I've seen another version somewhere where I believe he says something like "This should help you fix 99% of the problems you see." Seems right. I'm sure it

Re: Driver consistency issue

Please don’t cross-post multiple lists. Datastax list removed Abishek, do you have auth enabled? Does the system auth keyspace have rf=3? -- Jeff Jirsa > On Feb 27, 2018, at 2:59 AM, Nicolas Guyomar > wrote: > > Hi, > > Adding the java-driver ML for further question, because this does lo

Cassandra Daemon not coming up

I am using Cassandra 3.0.9 version on a 12 node cluster. I have multiple node down after a restart. The cassandra VM is not coming up with an asset error as below. On running in debug mode it is failing while doing operation on " resource_role_permissons_index" in system_auth keyspace. Please let m

Re: Jon Haddad on Diagnosing Performance Problems in Production

Is Jon blog post https://academy.datastax.com/planet-cassandra/blog/cassandra-summit-recap-diagnosing-problems-in-production was relocated somewhere ? On 27 February 2018 at 16:34, Kenneth Brotman wrote: > One presentation that I hope can get updated is Jon Haddad’s very thorough > presentation

RE: Cassandra Daemon not coming up

Can you check if you’ve enough disk space available ? ~Asad From: mahesh rajamani [mailto:rajamani.mah...@gmail.com] Sent: Tuesday, February 27, 2018 10:11 AM To: user@cassandra.apache.org Subject: Cassandra Daemon not coming up I am using Cassandra 3.0.9 version on a 12 node cluster. I have mult

RE: Cassandra Daemon not coming up

Were there any changes to the system such as permissions, etc. Did you add users / change auth scheme? On Feb 27, 2018, 10:27 AM -0600, ZAIDI, ASAD A , wrote: > Can you check if you’ve enough disk space available ? > ~Asad > > From: mahesh rajamani [mailto:rajamani.mah...@gmail.com] > Sent: Tuesd

RE: Jon Haddad on Diagnosing Performance Problems in Production

Nicolas, I think you had the link to the other version I was thinking of. I couldn’t find it. I think it might have gotten taken down; a lot of other stuff seems to be gone too. Maybe it will be back. Maybe they are just redoing stuff. Either way, it’s another sign of Mom and Dad drifti

RE: Cassandra Summit 2019 / Cassandra Summit 2018

The Meet Up groups might be a good way to implement a distributed asynchronous event that can still be optionally attended in person. We could make a nice kit for a few meetings for them that ties together with the event and connects them as participates in it. Here is the Meetup website

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

so... are those pages in the code tree of github? I don't see them or a directory structure under /doc. Is mirroring the documentation between the apache site and a github source a big issue? On Tue, Feb 27, 2018 at 7:50 AM, Kenneth Brotman < kenbrot...@yahoo.com.invalid> wrote: > I was debating

Re: Jon Haddad on Diagnosing Performance Problems in Production

On 02/27/2018 10:20 AM, Nicolas Guyomar wrote: > Is Jon blog > post  > https://academy.datastax.com/planet-cassandra/blog/cassandra-summit-recap-diagnosing-problems-in-production > was relocated somewhere ? https://web.archive.org/web/20160322011022/planetcassandra.org/blog/cassandra-summit-recap-

RE: Jon Haddad on Diagnosing Performance Problems in Production

Perhaps Mr. Hadad himself will share it again somewhere; he was kind enough to share it once at datastax! From: Kenneth Brotman [mailto:kenbrot...@yahoo.com.INVALID] Sent: Tuesday, February 27, 2018 10:39 AM To: user@cassandra.apache.org Subject: RE: Jon Haddad on Diagnosing Performance Problem

Re: Jon Haddad on Diagnosing Performance Problems in Production

There isn't a ton from that talk I'd consider "wrong" at this point, but some of it is a little stale. I always start off looking at system metrics. For a very thorough discussion on the matter check out Brendan Gregg's USE [1] method. I did a blog post on my own about the talk [2] that has scre

Re: Version Rollback

My speculation is that IF (bigif) the sstable formats are compatible between the versions, which probably isn't the case for major versions, then you could drop back. If the sstables changed format, then you'll probably need to figure out how to rewrite the sstables in the older format and then ss

Re: Data Deleted After a few days of being off

Does cassandra still function if the commitlog dir has no writes? Will the data still go into the memtable and serve queries? On Tue, Feb 27, 2018 at 1:37 AM, Oleksandr Shulgin < oleksandr.shul...@zalando.de> wrote: > On Tue, Feb 27, 2018 at 7:37 AM, A wrote: > >> >> I started going through the

RE: Version Rollback

I wonder if you could use Apache Spark to do it? Kenneth Brotman From: Carl Mueller [mailto:carl.muel...@smartthings.com] Sent: Tuesday, February 27, 2018 9:22 AM To: user@cassandra.apache.org Subject: Re: Version Rollback My speculation is that IF (bigif) the sstable formats are compa

Re: JMX metrics for CL

Hello, There are no such metrics that I am aware of. One way you could do this is to have your own implementation of QueryHandler and your own metrics and filter the queries based on the CL and increment the according metric. Then, in cassandra-env.sh you could specify to use your class using

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

It’s just content for web pages. There isn’t a working outline or any draft on any of the JIRA’s yet. I like to keep things simple. Did I miss something? What does it matter right now? Thanks Carl, Kenneth Brotman From: Carl Mueller [mailto:carl.muel...@smartthings.com] Sent: Tue

Re: Version Rollback

MOST minor versions support rollback - the exceptions are those where internode protocol changes (3.0.14 being the only one in recent memory), or where sstable format changes (again rare). No major versions support rollback - the only way to do it is to upgrade in a way that you can effectively

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

If there was a github for the docs, we could start posting content to it for review. Not sure what the review/contribution process is on Apache. Google searches on apache documentation and similar run into lots of noise from actual projects. I wouldn't mind trying to do a little doc work on the re

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

The docs have been in tree for years :) https://github.com/apache/cassandra/tree/trunk/doc There’s even a docker image to build them so you don’t need to mess with sphinx. Check the README for instructions. Jon > On Feb 27, 2018, at 9:49 A

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

I was just getting ready to install sphinx. Cool. From: Jon Haddad [mailto:jonathan.had...@gmail.com] On Behalf Of Jon Haddad Sent: Tuesday, February 27, 2018 9:51 AM To: user@cassandra.apache.org Subject: Re: Filling in the blank To Do sections on the Apache Cassandra web site The docs

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

There’s a section dedicated to contributing to Cassandra documentation in the docs as well: https://cassandra.apache.org/doc/latest/development/documentation.html > On Feb 27, 2018, at 9:55 AM, Kenneth Brotman > wrote:

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

Nice thanks On Tue, Feb 27, 2018 at 12:03 PM, Jon Haddad wrote: > There’s a section dedicated to contributing to Cassandra documentation in > the docs as well: https://cassandra.apache.org/doc/latest/ > development/documentation.html > > > > On Feb 27, 2018, at 9:55 AM, Kenneth Brotman > wrote

Re: Data Deleted After a few days of being off

No. I inserted using USING TTL 86400;  On Monday, February 26, 2018, 11:45:07 PM PST, Oleksandr Shulgin wrote: On Tue, Feb 27, 2018 at 7:37 AM, A wrote: I started going through the logs and haven't noticed anything yet... Very unexpected behavior. Maybe I'm asking the obvious, but

Re: Data Deleted After a few days of being off

On 27 Feb 2018 20:58, "A" wrote: No. I inserted using USING TTL 86400; Well, that answers your question I believe? -- Alex

Re: Jon Haddad on Diagnosing Performance Problems in Production

+1 That was a nice talk! I don't know why I haven't come across that video before! On Tue, Feb 27, 2018 at 9:12 AM, Jonathan Haddad wrote: > There isn't a ton from that talk I'd consider "wrong" at this point, but > some of it is a little stale. I always start off looking at system > metrics.

Batch too large exception

Hi, I have been getting batch too large exception when performing WRITE from Client application. My insert size is 5MB, so I have to split the 10 insert objects to insert at one go. It save some inserts and closes after some uncertain time. And it is a wide column table, we do have 113 columns. Ca

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

This is an awesome effort. Thank you Sent from my iPhone > On Feb 27, 2018, at 1:17 PM, Carl Mueller > wrote: > > Nice thanks > > >> On Tue, Feb 27, 2018 at 12:03 PM, Jon Haddad wrote: >> There’s a section dedicated to contributing to Cassandra documentation in >> the docs as well: >> htt

Cassandra on high performance machine: virtualization vs Docker

What i've got to set up my Apache Cassandra cluster are some Servers with 20 Core cpu * 2 Threads and 128 GB ram and 8 * 2TB disk. Just read all over the web: Do not use big nodes for your cluster, i'm convinced to run multiple nodes on a single physical server. So the question is which techno

Re: Cassandra on high performance machine: virtualization vs Docker

Docker will provide less per node overhead. And yes, virtualizing smaller nodes out of a bigger physical makes sense. Of course you lose the per node failure protection, but I guess this is not production? <==> "Who do you think made the first stone spear? The Asperger guy. If you get rid of

Re: Cassandra on high performance machine: virtualization vs Docker

Same technique works for production, too. Rack aware snitch will protect against placing replicas on the same host, as long as the rack info is correct -- Jeff Jirsa > On Feb 27, 2018, at 8:43 PM, daemeon reiydelle wrote: > > Docker will provide less per node overhead. > > And yes, virtua