Cassandra proxy to control read/write throughput

2017-10-25 Thread AI Rumman
Hi, I am using different versions of Casandra in my environment where I have 60 nodes are running for different applications. Each application is connecting to its own cluster. I am thinking about abstracting the Cassandra IP from app drivers. App will communicate to one proxy IP which will

Re: [3.0.14] Thrift works fine, CQL/Native queries give nonsensical results

2017-10-25 Thread Michiel Buddingh'
On Mon, Sep 25, 2017 at 11:16:36AM +0200, Michiel Buddingh wrote: > We are currently in the process of migrating data from an old Cassandra > cluster to a new one. When quering data from a table that was copied using > sstableloader, we find that even at consistency level ALL, results contain >

Re: code snippet for cqlsh COPY from

2017-10-25 Thread Andy Tolbert
Hi Suresh, cqlsh COPY does batches intelligently by only grouping inserts targeting the same partition in a batch. As of version 3.6, C* will not emit the "batch size exceeded" errors if all statements in a batch belong to the same partition (CASSANDRA-13467

Re: Index summary redistribution seems to block all compactions

2017-10-25 Thread Sotirios Delimanolis
Nothing obvious in the logs, and nothing seemingly related to the details in that ticket. We don't perform any scrubs either (haven't on this node recently at least).On Wednesday, October 25, 2017, 1:08:38 AM PDT, Marcus Eriksson wrote: Anything in the logs? It

RE: server connection in authenticator

2017-10-25 Thread Harika Vangapelli -T (hvangape - AKRAYA INC at Cisco)
Horia, By just changing Authenticator and Authorizer in cassandra.yaml and adding custom libraries in /usr/share/cassandra/ you can plugin to custom authentication sed -ri \ -e 's/^(authenticator:).*/\1 'com.cassandra.LdapCassandraAuthenticator'/' \ -e

code snippet for cqlsh COPY from

2017-10-25 Thread Suresh Babu Mallampati
Hi All, Can someone provide me the code snippet for the cqlsh COPY from csv file. I just want to know how that COPY mechanism work compared to normal insert/commit to avaoid the batch size exceed the limit. Thanks, Suresh.

Re: Best approach to prepare to shutdown a cassandra node

2017-10-25 Thread Anshu Vajpayee
use nodetool stopdaemon On Wed, Oct 25, 2017 at 4:42 AM, Javier Canillas wrote: > So, just to clarify.. a good approach to shutdown an instance of cassandra > should be: > > *# Drain all information from commitlog into sstables* > *bin/nodetool stopdaemon* >

Re: server connection in authenticator

2017-10-25 Thread Jeff Jirsa
This might be better on the dev list, but the Authenticator and Authorizer interfaces should let you drop a jar in the classpath and turn them on in the yaml - you shouldn’t NEED to change much code, but that doesn’t mean the the interfaces have considered your use case. If the interfaces are

server connection in authenticator

2017-10-25 Thread Horia Mocioi
Hello guys, We are building up an authenticator using certificates. So far we came up with a solution, but implies changing some files in Cassandra code base in order to have the connection in the new Authenticator. So, here are my questions: * how are you guys doing this? * is it possible to

Re: Index summary redistribution seems to block all compactions

2017-10-25 Thread Marcus Eriksson
Anything in the logs? It *could* be https://issues.apache.org/jira/browse/CASSANDRA-13873 On Tue, Oct 24, 2017 at 11:18 PM, Sotirios Delimanolis < sotodel...@yahoo.com.invalid> wrote: > On a Cassandra 2.2.11 cluster, I noticed estimated compactions > accumulating on one node. nodetool

Re: can repair and bootstrap run simultaneously

2017-10-25 Thread Nicolas Guyomar
Hi, I believe that as long as you use -local option in another DC this would be safe, but repairing a DC while boostraping a new node in it does not seems OK AFAIK. On 24 October 2017 at 14:08, Peng Xiao <2535...@qq.com> wrote: > Hi there, > > Can we add a new node (bootstrap) and run repair on