RE: Log Slow Queries

2015-06-18 Thread DE VITO Dominique
Hi Carlos, Different possibilities (to log slow queries). 1) A probabilistic way to catch slow queries (probabilistic, but with detailed info) = look for “nodetool settraceprobability” like in http://www.datastax.com/dev/blog/advanced-request-tracing-in-cassandra-1-2 2) Catch slow

nodetool repair

2015-06-18 Thread Jean Tremblay
Hi, I want to make on a regular base repairs on my cluster as suggested by the documentation. I want to do this in a way that the cluster is still responding to read requests. So I understand that I should not use the -par switch for that as it will do the repair in parallel and consume all

Re: Deploying OpsCenter behind a HTTP(S) proxy

2015-06-18 Thread Ben Bromhead
OpsCenter is a little bit tricky to simply just rewrite urls, the lhr requests and rest endpoints it hits are all specified a little differently in the javascript app it loads. We ended up monkey patching a buttload of the js files to get all the requests working properly with our proxy.

Re: nodetool repair

2015-06-18 Thread Jonathan Haddad
If you're using DSE, you can schedule it automatically using the repair service. If you're open source, check out Spotify cassandra reaper, it'll manage it for you. https://github.com/spotify/cassandra-reaper On Thu, Jun 18, 2015 at 12:36 PM Jean Tremblay jean.tremb...@zen-innovations.com

Re: nodetool repair

2015-06-18 Thread Jean Tremblay
Thanks Jonathan. But I need to know the following: If you issue a “nodetool repair” on one node will it repair all the nodes in the cluster or only the one on which we issue the command? If it repairs only one node, do I have to wait that the nodetool repair ends, and only then issue another

sstableloader Could not retrieve endpoint ranges

2015-06-18 Thread Mitch Gitman
I'm using sstableloader to bulk-load a table from one cluster to another. I can't just copy sstables because the clusters have different topologies. While we're looking to upgrade soon to Cassandra 2.0.x, we're on Cassandra 1.2.19. The source data comes from a nodetool snapshot. Here's the

Re: nodetool repair

2015-06-18 Thread arun sirimalla
Hi Jean, Running nodetool repair on a node will repair only that node in the cluster. It is recommended to run nodetool repair on one node at a time. Few things to keep in mind while running repair 1. Running repair will trigger compactions 2. Increase in CPU utilization. Run node tool

Re: Deploying OpsCenter behind a HTTP(S) proxy

2015-06-18 Thread Spencer Brown
In your examples, there are front pages then there are links to more info on different things. Do you want me to just write a front page or to provide content for the different links? On Thu, Jun 18, 2015 at 5:13 AM, Jonathan Ballet jbal...@gfproducts.ch wrote: Hi, I'm looking for

Re: Garbage collector launched on all nodes at once

2015-06-18 Thread Jonathan Haddad
How much memory do you have? Recently people have been seeing really great performance using G1GC with heaps 8GB and offheap memtable objects. On Thu, Jun 18, 2015 at 1:31 AM Jason Wee peich...@gmail.com wrote: okay, iirc memtable has been removed off heap, google and got this

Re: Minor compaction not triggered

2015-06-18 Thread Jayapandian Ponraj
Hi, Curently the cluster runs 2.0.14 on all nodes, will try to upgrade to 2.0.15 The issue is in all the nodes.. simple restart as in a rolling restart of all the nodes? On 18 June 2015 at 15:18, Alain RODRIGUEZ arodr...@gmail.com wrote: Hi, From what I read there are some issue using DTCS.

Re: compaction occurring very frequently

2015-06-18 Thread Carlos Rolo
Hi, 2.1.x does have compaction issues. Upgrading to 2.1.6 should help you. You can also search this mailing list for some recommendations for that specific problem since it is a recurrent issue. Regards, Carlos Juzarte Rolo Cassandra Consultant Pythian - Love your data rolo@pythian | Twitter:

compaction occurring very frequently

2015-06-18 Thread Rahul Bhardwaj
Hi All, We have a cluster (2.1.2) of 3 nodes , There is one table which contains huge amount of data and having sstable count more than 1800 on all 3 nodes. We have noticed that suddently compaction for that CF occurs very frequently right after completion of previous compaction and also taking

Re: Deploying OpsCenter behind a HTTP(S) proxy

2015-06-18 Thread Spencer Brown
First, your firewall should really be your frontend There operational frontend is apache, which is common. You want every url with opscenter in it handled elsewhere. You could also set up proxies for /. cluster-configs, etc... Then there is mod_rewrite, which provides a lot more granularity

Re: Minor compaction not triggered

2015-06-18 Thread Jayapandian Ponraj
Can anyone guide me with any pointers plz On 17 June 2015 at 17:05, Jayapandian Ponraj pandian...@gmail.com wrote: Hi I have a cassandra cluster of 6 nodes, with DateTiered compaction for the tables/CFs For some reason the minor compaction never happens. I have enabled debug logging and I

Deploying OpsCenter behind a HTTP(S) proxy

2015-06-18 Thread Jonathan Ballet
Hi, I'm looking for information on how to correctly deploy an OpsCenter instance behind a HTTP(S) proxy. I have a running instance of OpsCenter 5.1 reachable at http://opscenter:/opscenter/ but I would like to be able to serve this kind of tool under a single hostname on HTTPS along with

Re: Minor compaction not triggered

2015-06-18 Thread Alain RODRIGUEZ
Hi, From what I read there are some issue using DTCS. You should probably go to the last minor version. You should also give more context so people can help. Have you tried a simple restart ? Does it happen on all your nodes ? C*heers, Alain 2015-06-18 11:42 GMT+02:00 Jayapandian Ponraj

Log Slow Queries

2015-06-18 Thread Carlos Alonso
Hi guys. I'm facing slow read requests from time to time, I've spotted the keyspace/cf where this is happening but I can't see anything obvious (single partition slice query, no tombstones, ...) anything else where to look at? I'd like to have the slow queries logged to either log or saved to a