Re: unsubscribe

2016-09-21 Thread Alain RODRIGUEZ
Hi, Sending a message to user-unsubscr...@cassandra.apache.org is the right way to go if you want to unsubscribe from the "Cassandra User" mailing list. C*heers, --- Alain Rodriguez - @arodream - al...@thelastpickle.com France 2016-09-20 14:58 GMT+02:00 Jerry Poole : > > > >

Re: Nodetool repair

2016-09-21 Thread Alain RODRIGUEZ
Hi George, That's the best way to monitor repairs "out of the box" I could think of. When you're not seeing 2048 (in your case), it might be due to log rotation or to a session failure. Have you had a look at repair failures? I am wondering why the implementor did not put something in the log (e.

Re: Having secondary indices limited to analytics dc

2016-09-21 Thread Andres de la Peña
Hi, Sratio's Lucene index takes a walk around to offer this feature. The index can be created with a configuration option specifying a list of data centers to be excluded from indexing. The index i

Re: Using keyspaces for virtual clusters

2016-09-21 Thread Alain RODRIGUEZ
Hi Dorian, I'm thinking of creating many keyspaces and storing them into many virtual > datacenters (the servers will be in 1 logical datacenter, but separated by > keyspaces). > > Does that make sense (so growing up to 200 dcs of 3 servers each in best > case scenario)? There is 3 main things y

Re: unsubscribe

2016-09-21 Thread Jerry Poole
Thanks for your polite guidance. On Sep 21, 2016, at 4:54 AM, Alain RODRIGUEZ mailto:arodr...@gmail.com>> wrote: Hi, Sending a message to user-unsubscr...@cassandra.apache.org is the right way to go if you want to unsubscribe from the "Cassandra U

Re: Re : Generic keystore when enabling SSL

2016-09-21 Thread Eric Evans
On Tue, Sep 20, 2016 at 12:57 PM, sai krishnam raju potturi wrote: > Due to the security policies in our company, we were asked to use 3rd party > signed certs. Since we'll require to manage 100's of individual certs, we > wanted to know if there is a work around with a generic keystore and > trus

Re: High load on few nodes in a DC.

2016-09-21 Thread Romain Hardouin
Hi, Do you shuffle the replicas with TokenAwarePolicy?TokenAwarePolicy(LoadBalancingPolicy childPolicy, boolean shuffleReplicas)  Best, RomainLe Mardi 20 septembre 2016 15h47, Pranay akula a écrit : I was a able to find the hotspots causing the load,but the size of these partitions ar

Re: Nodetool repair

2016-09-21 Thread Li, Guangxing
Alain, my script actually grep through all the log files, including those system.log.*. So it was probably due to a failed session. So now my script assumes the repair has finished (possibly due to failure) if it does not see any more repair related logs after 2 hours. Thanks. George. On Wed, S

Re: Using keyspaces for virtual clusters

2016-09-21 Thread Eric Stevens
Using keyspaces to support multi tenancy is very close to an anti pattern unless there is a finite and reasonable upper bound to how many tenants you'll support overall. Large numbers of tables comes with cluster overhead and operational complexity you will come to regret eventually. >and because

Re: Re : Generic keystore when enabling SSL

2016-09-21 Thread sai krishnam raju potturi
hi Evans; rather than having one individual certificate for every node, we are looking at getting one Comodo wild-card certificate, and importing that into the keystore. along with the intermediate CA provided by Comodo. As far as the trust-store is concerned, we are looking at importing the int

Re: Nodetool repair

2016-09-21 Thread Romain Hardouin
Do you see any pending AntiEntropySessions (not AntiEntropyStage) with nodetool tpstats on nodes? Romain Le Mercredi 21 septembre 2016 16h45, "Li, Guangxing" a écrit : Alain, my script actually grep through all the log files, including those system.log.*. So it was probably due to a

Re: Using keyspaces for virtual clusters

2016-09-21 Thread Dorian Hoxha
@Alain I wanted to do 2, but looks like that won't be possible because of too much overhead. @Eric Yeah that's what I was afraid of. Though I know that the client connects to every server, I just didn't want to do the extra code. On Wed, Sep 21, 2016 at 4:56 PM, Eric Stevens wrote: > Using keys

Re: Client-side timeouts after dropping table

2016-09-21 Thread John Sanda
I was able to get metrics, but nothing stands out. When the applications start up and a table is dropped, shortly thereafter on a subsequent write I get a NoHostAvailableException that is caused by an OperationTimedOutException. I am not 100% certain on which write the timeout occurs because there

Re: Nodetool repair

2016-09-21 Thread Li, Guangxing
Romain, I started running a new repair. If I see such behavior again, I will try what you mentioned. Thanks. On Wed, Sep 21, 2016 at 9:51 AM, Romain Hardouin wrote: > Do you see any pending AntiEntropySessions (not AntiEntropyStage) with > nodetool tpstats on nodes? > > Romain > > > Le Mercred

Re: Client-side timeouts after dropping table

2016-09-21 Thread Jesse Hodges
Thanks, filing this under "things I wish I'd realized sooner" :) On Tue, Sep 20, 2016 at 10:27 PM, Jonathan Haddad wrote: > 3.7 falls under the Tick Tock release cycle, which is almost completely > untested in production by experienced operators. In the cases where it has > been tested, there h

understanding partitions

2016-09-21 Thread S Ahmed
Hello, If you have a 10 node cluster, how does having 10 partitions or 100 partitions change how cassandra will perform? With 10 partitions you will have 1 partition per node. WIth 100 partitions you will have 10 partitions per node. With 100 partitions I guess it helps because when you add more

understanding partitions and # of nodes

2016-09-21 Thread S Ahmed
Hello, If you have a 10 node cluster, how does having 10 partitions or 100 partitions change how cassandra will perform? With 10 partitions you will have 1 partition per node. WIth 100 partitions you will have 10 partitions per node. With 100 partitions I guess it helps because when you add more

Re: understanding partitions and # of nodes

2016-09-21 Thread Jeff Jirsa
It If you only have 100 partitions, then having more than (100 * RF) nodes doesn’t help you much. However, unless you’re using very specific partitioners, there’s no guarantee that you’ll have 1 partition per node (with 10 nodes / 10 partitions). Cassandra uses murmur3 hash (by default, a