Re: repair -pr in crontab

Hi, we maintain a hard fork of Reaper that works with all versions of Cassandra up to 3.0.x : https://github.com/thelastpickle/cassandra-reaper Just to save you some time digging into all the forks that could exist. Cheers, On Fri, Nov 25, 2016 at 7:37 AM Benjamin Roth

Re: Does recovery continue after truncating a table?

Hi all, I revised the script to reproduce the issue. I think the issue happens more frequently than before. Killing another node is added to the previous script. [script] #!/bin/sh node1_ip= node2_ip= node3_ip= node2_user= node3_user= rows=1 echo "consistency quorum;" >

Re: repair -pr in crontab

I recommend using cassandra-reaper Using crons without proper Monitoring will most likely not work as expected. There are some reaper forks on GitHub. You have to check which one works with your Cassandra version. The original one from Spotify only works on 2.x not on 3.x Am 25.11.2016 07:31

Re: repair -pr in crontab

Hi Artur, When I asked similar questions, someone addressed me to the below links and they are helpful. See http://www.datastax.com/dev/blog/repair-in-cassandra https://lostechies.com/ryansvihla/2015/09/25/cassandras-repair-should-be-called-required-maintenance/

Re: generate different sizes of request from single client

If targetting two different tables for the different sizes works then I’ve submitted a patch for cassandra-stress that allows you to do that: https://issues.apache.org/jira/browse/CASSANDRA-8780 It would be nice to see someone else test it if you have the appetite to build it and try it out.

Re: failure node rejoin

Thanks Ben, I've reported this issue at https://issues.apache.org/j ira/browse/CASSANDRA-12955. I'll tell you if I find anything about the data loss issue. Regards, yuji On Thu, Nov 24, 2016 at 1:37 PM, Ben Slater wrote: > You could certainly log a JIRA for the

Re: generate different sizes of request from single client

Hi Vladimir, It has option of mixed request of read/write but doesn't has any option for mixed request size where I can request different size of request. Thanks, Vikas On Thu, Nov 24, 2016 at 7:46 PM, Vladimir Yudovin wrote: > You can use cassandra stress-tool. >

Re: generate different sizes of request from single client

Gatling + CQL plugin is really cool too On Thu, Nov 24, 2016 at 7:46 PM, Vladimir Yudovin wrote: > You can use cassandra stress-tool. > > It has options to set different load patterns. > > Best

Re: generate different sizes of request from single client

You can use cassandra stress-tool. It has options to set different load patterns. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Thu, 24 Nov 2016 13:27:59 -0500Vikas Jaiman er.vikasjai...@gmail.com wrote Hi all, I want to generate two different

generate different sizes of request from single client

Hi all, I want to generate two different sizes (let's say 1 KB and 10 KB) of request from single client for benchmarking Cassandra. Is there any tool exist for this type of scenario? Vikas

RE: Max Capacity per Node

Hi, I’m not a Cassandra expert but according this reference : http://docs.datastax.com/en/landing_page/doc/landing_page/planning/planningHardware.html#planningHardware__capacity-per-node You already reached (even exceeded) the recommended limit for HDD. As usual, I guess the maximum limits

Max Capacity per Node

Hi Everyone, I have a 24 node cluster (12 in each DC) with a capacity of 3.3 TB per node for the data directory. I'd like to increase the capacity per node. Can anyone tell what is the maximum recommended capacity a node can use? The disks we use are HDD, not SSD. Thanks! Shalom Sagges DBA T:

system.NodeIdInfo - leftover from Cassandra 0.8.3 ?

I've half inherited Cassandra administration on a two DC cluster with 8 nodes (4 in each DC). We've just successfully completed the upgrade to 2.1.6 On completion of upgradesstables the only remaining "jb" sstable was in the System keyspace for NodeIdInfo. I notice that this is no longer

Re: Extremely large ValidationExecutor.MaxPoolSize in Cassandra 2.1.13

This is not a problem per se, it's just the maximum number of concurrent threads allowed in the validation pool which is Integer.MAX_VALUE, which will limit the maximum number of simultaneous validations the node will handle. It may be too big, but you probably will never reach anywhere close to

Re: OperationTimedOutException (NoHostAvailableException)

Do you get this error on specific column families or on all of the environment? Shalom Sagges DBA T: +972-74-700-4035 We Create Meaningful Connections

Re: OperationTimedOutException (NoHostAvailableException)

I tried , that didnt work out.. :( On Thu, Nov 24, 2016 at 4:49 PM, Vladimir Yudovin wrote: > >rpc_address: 0.0.0.0 , broadcast_address: 1.2.3.4 > Did you try set rpc_address to node IP and not to 0.0.0.0 ? > > Best regards, Vladimir Yudovin, > *Winguzone

Re: OperationTimedOutException (NoHostAvailableException)

rpc_address: 0.0.0.0 , broadcast_address: 1.2.3.4 Did you try set rpc_address to node IP and not to 0.0.0.0 ? Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Thu, 24 Nov 2016 04:50:08 -0500Jeff Jirsa jeff.ji...@crowdstrike.com wrote Did you

Re: how to effectively drop table

Actually you shouldn't drop tables prior to dropping keyspace. Just drop keyspace with all its tables. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Thu, 24 Nov 2016 05:38:36 -0500joseph gao gaojf.bok...@gmail.com wrote Hi，Vladimir, I have

Re: how to effectively drop table

Hi，Vladimir, I have to do the whole stuff in 2 step. DROP whole keyspace works in step2. But in step 1, I have to drop 2000 tables。 All I could wait and skip step 1 and do all jobs in step 2. Anyway, thanks very much! 2016-11-24 16:25 GMT+08:00 Vladimir Yudovin : >

OperationTimedOutException (NoHostAvailableException)

Hi all, Following exception thrown sometimes though all nodes are up. * SEVERE : This error occurs if there are not enough Cassandra nodes for the required QUORUM to persist data. Please make sure enough nodes are up at this point of time. Error Count is at 150 Exception

Re: how to effectively drop table

Hi, Is DROP whole keyspace an option? Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Thu, 24 Nov 2016 03:00:40 -0500joseph gao gaojf.bok...@gmail.com wrote Hi, all I've had a very bad system design before. This caused about 1 tables in

how to effectively drop table

Hi, all I've had a very bad system design before. This caused about 1 tables in my cassandra cluster, and the cluster is very unstable. Now I want to redesign the system, but it's so suffering to drop the former tables. Dropping a table may cost 30 seconds or even worse(170s) using cqlsh