Re: Snapshot SSTable modified??

I looked at the source code for GNU tar, and it looks for a change in the create time or (more likely) a change in the size. This seems very strange to me — I would think that creating a snapshot would cause a flush and then once the SSTables are written, hardlinks would be created and the SSTa

Re: Snapshot SSTable modified??

I've run across this problem before - it seems like GNU tar interprets changes in the link count as changes to the file, so if the file gets compacted mid-backup it freaks out even if the file contents are unchanged. I worked around it by just using bsdtar instead. On Thu, May 24, 2018 at 6:08 AM

Re: EXT: Cassandra Monitoring tool

Good article about it on LI https://www.linkedin.com/pulse/snap-cassandra-s3-tablesnap-vijaya-kumar-hosamani/ On May 25, 2018, 2:52 PM -0500, Joaquin Casares , wrote: > Hello Aneesh, > > While this doesn't provide a GUI, tablesnap is a community tool that does a > great job at handling backups:

Re: EXT: Cassandra Monitoring tool

Hello Aneesh, While this doesn't provide a GUI, tablesnap is a community tool that does a great job at handling backups: https://github.com/JeremyGrosser/tablesnap Cheers, Joaquin Joaquin Casares Consultant Austin, TX Apache Cassandra Consulting http://www.thelastpickle.com On Fri, May 25,

Re: Log application Queries

this is awesome Jeff. Regards, Nitan K. Cassandra and Oracle Architect/SME Datastax Certified Cassandra expert Oracle 10g Certified On Fri, May 25, 2018 at 3:00 PM, Jeff Jirsa wrote: > https://issues.apache.org/jira/browse/CASSANDRA-13983 was added to > cassandra 4.0 > > > > On Fri, May 25, 20

Re: Log application Queries

https://issues.apache.org/jira/browse/CASSANDRA-13983 was added to cassandra 4.0 On Fri, May 25, 2018 at 8:24 AM, Nitan Kainth wrote: > Hi, > > I would like to log all C* queries hitting cluster. Could someone please > tell me how can I do it at cluster level? > Will nodetool setlogginglevel w

Re: Log application Queries

Thanks Alain Regards, Nitan K. Cassandra and Oracle Architect/SME Datastax Certified Cassandra expert Oracle 10g Certified On Fri, May 25, 2018 at 2:05 PM, Alain RODRIGUEZ wrote: > Nate wrote a post about this exact topic. In case it is of some use: > http://thelastpickle.com/blog/2016/02/10/l

Re: Log application Queries

Nate wrote a post about this exact topic. In case it is of some use: http://thelastpickle.com/blog/2016/02/10/locking-down-apache-cassandra-logging.html C*heers, --- Alain Rodriguez - @arodream - al...@thelastpickle.com France / Spain The Last Pickle - Apache Cassandra Consult

Re: Cassandra Monitoring tool

Hello Aneesh, Alain and I also worked on this project that you might find useful: https://github.com/thelastpickle/docker-cassandra-bootstrap It is a Docker Compose environment to showcase the Prometheus graphs that we worked on. There's still a missing update, so do please check back soon, but

Re: Cassandra Monitoring tool

Hello, With more details on your criteria, it would be easier. I used: - SPM from Sematext (Commercial - dashboards out of the box) - Datastax OpsCenter (Commercial, With DSE only nowadays) - Grafana/Graphite or Prometheus (Open source - 'do it yourself' - but some templates exist) - Datadog (Co

Re: unsubscribe

Hello Matthias, I don't think you really left :). Give this address a try instead: user-unsubscr...@cassandra.apache.org ;-) C*iao, 2018-05-24 23:37 GMT+01:00 Matthias Hübner : > Ciao >

Re: Reading Data from C* Cluster

Hello, Where I can have configurable codes in partition key as cassandra supports. > I am sorry I don't understand this. 1) How much data I can put in one partition ? > Well, Cassandra supports huge partitions. In practice, the value of 100 MB per partition is often shared. I consider it's a go

Re: Log application Queries

So settraceprobability is better option than nodetool :) Regards, Nitan K. Cassandra and Oracle Architect/SME Datastax Certified Cassandra expert Oracle 10g Certified On Fri, May 25, 2018 at 12:15 PM, Surbhi Gupta wrote: > nodeool setlogginglevel is only valid for below : > > >- org.apache

Re: EXT: Cassandra Monitoring tool

Thank you Hari for the details. One more question, please suggest me some cluster managing too for Cassandra cluster. Looking for opensource tools that will support to take snapshot and restore via GUI. Regards, Aneesh On Fri, May 25, 2018 at 10:00 PM, Harikrishnan Pillai < hpil...@walmartlabs.c

Re: EXT: Cassandra Monitoring tool

I assume you are using open source cassandra and you can look at Prometheus grafana for cassandra monitoring and lot information available in internet regarding how to setup the Prometheus monitoring for cassandra . Sent from my iPhone > On May 25, 2018, at 9:23 AM, ANEESH KUMAR K.M wrote: >

Cassandra Monitoring tool

Please suggest me some good cluster monitoring tool for cassandra multi region cluster.

Re: Log application Queries

nodeool setlogginglevel is only valid for below : - org.apache.cassandra - org.apache.cassandra.db - org.apache.cassandra.service.StorageProxy On 25 May 2018 at 09:01, Nitan Kainth wrote: > Thanks Surbhi. I found another way. I used nodetool settraceprobability 1 > and it is logging

Re: Log application Queries

Thanks Surbhi. I found another way. I used nodetool settraceprobability 1 and it is logging in system_traces. How is it different from nodeool setlogginglevel? Regards, Nitan K. Cassandra and Oracle Architect/SME Datastax Certified Cassandra expert Oracle 10g Certified On Fri, May 25, 2018 at 1

Re: Log application Queries

If using dse then u can enable in dse.yaml. # CQL slow log settings cql_slow_log_options: enabled: true threshold_ms: 0 ttl_seconds: 259200 As far as my understanding says setlogginglevel is used for changing the logging level as below but not for slow query . - ALL - TRACE - DEBUG

Log application Queries

Hi, I would like to log all C* queries hitting cluster. Could someone please tell me how can I do it at cluster level? Will nodetool setlogginglevel work? If so, please share example with library name. C* version 3.11