Re: Changing existing Cassandra cluster from single rack configuration to multi racks configuration

2019-03-12 Thread Laxmikant Upadhyay
Hi Justin, If you have 6 node cluster with RF = 3 nodes in each rack. So nodes in rac1 will be primary ower of different token ranges and their replica will be rac2 and rac3. If one of the node in rac1 goes down then their replicas present in rac2 and rac3 will be serving the request. However

Re: AxonOps - Cassandra operational management tool

2019-03-12 Thread Rahul Singh
Nice.. Good to see the community producing tools around the Cassandra product. Few pieces of feedback *Kudos* 1. Glad that you are doing it 2. Looks great 3. Willing to try it out if you find this guy called "Free Time" for me :) *Criticism* 1. It mimics a lot of stack components that are out

Re: cassandra upgrades multi-DC in parallel

2019-03-12 Thread Rahul Singh
Carl, If you have done an automation and tested it a few time on a lower environment with the same data from production, I'd say go for it.. but as Jonathan said, if there's an issue, you won't be able to continue operations. On Tue, Mar 12, 2019 at 3:20 PM Jonathan Haddad wrote: > Nothing

Two day Apache Cassandra track at ApacheConNA 2019

2019-03-12 Thread Nate McCall
Hi Folks, I am delighted to share with you that we, the Apache Cassandra community, have been given a two day track at this year's ApacheCon North America. The goal of this track is simple: we are going to get together to talk about Apache Cassandra. As such, this will be the ideal place to

Re: Migrate large volume of data from one table to another table within the same cluster when COPY is not an option.

2019-03-12 Thread Stefan Miklosovic
Hi Sean, for sure, the best approach would be to create another table which would treat just that specific query. How do I set the flag for not allowing allow filtering in cassandra.yaml? I read a doco and there seems to be nothing about that. Regards On Wed, 13 Mar 2019 at 06:57, Durity, Sean

Re: Changing existing Cassandra cluster from single rack configuration to multi racks configuration

2019-03-12 Thread Justin Sanciangco
Maybe this was a specific issue to my topology in the past where I had 9 nodes with a 3 rack implementation. Each rack contained a unique replica set so when a node went down it put very high load on the nodes in the same rack. How does the data get distributed in this case where there are only

RE: Migrate large volume of data from one table to another table within the same cluster when COPY is not an option.

2019-03-12 Thread Durity, Sean R
If there are 2 access patterns, I would consider having 2 tables. The first one with the ID, which you say is the majority use case. Then have a second table that uses a time-bucket approach as others have suggested: (time bucket, id) as primary key Choose a time bucket (day, week, hour, month,

Re: cassandra upgrades multi-DC in parallel

2019-03-12 Thread Jonathan Haddad
Nothing prevents it technically, but operationally you might not want to. Personally I’d prefer have the safety net of a dc to fall back on in case there’s an issue with the upgrade. On Wed, Mar 13, 2019 at 7:48 AM Carl Mueller wrote: > If there are multiple DCs in a cluster, is it safe to

cassandra upgrades multi-DC in parallel

2019-03-12 Thread Carl Mueller
If there are multiple DCs in a cluster, is it safe to upgrade them in parallel, with each DC doing a node-at-a-time?

Re: Changing existing Cassandra cluster from single rack configuration to multi racks configuration

2019-03-12 Thread Alexander Dejanovski
Hi Justin, I'm not sure I follow your reasoning. In a 6 node cluster with 3 racks (2 nodes per rack) and RF 3, if a node goes down you'll still have one node in each of the other racks to serve the requests. Nodes within the same racks aren't replicas for the same tokens (as long as the number of

Re: Changing existing Cassandra cluster from single rack configuration to multi racks configuration

2019-03-12 Thread Jeff Jirsa
On Tue, Mar 12, 2019 at 5:28 PM Justin Sanciangco wrote: > I would recommend that you do not go into a 3 rack single dc > implementation with only 6 nodes. If a node goes down in this situation, > the node that is paired with the node that is downed will have to service > all of the load instead

Re: Changing existing Cassandra cluster from single rack configuration to multi racks configuration

2019-03-12 Thread Justin Sanciangco
I would recommend that you do not go into a 3 rack single dc implementation with only 6 nodes. If a node goes down in this situation, the node that is paired with the node that is downed will have to service all of the load instead of being evenly distributed throughout the cluster. While its

Re: Bootstrap keeps failing

2019-03-12 Thread Léo FERLIN SUTTON
Hello ! Just wanted to let you know : We finally managed to get a solution ! First of all we increased `streaming_socket_timeout_in_ms` to `8640`. We are using cassandra-reaper to manage our repairs, they last about 15 days on this cluster and a re-launched almost immediately once they are

Re: Migrate large volume of data from one table to another table within the same cluster when COPY is not an option.

2019-03-12 Thread Leena Ghatpande
Our data model cannot be like below as you have recommended as majority of the reads need to select the data by the partition key (id) only, not by date. You could remodel your data in such way that you would make primary key like this ((date), hour-minute, id) or ((date, hour-minute), id) By

Re: New node insertion methods

2019-03-12 Thread Kyrylo Lebediev
Hi Vsevolod, > Are there any workarounds to speed up the process? (e.g. doing cleanup only > after all 4 new nodes joined cluster), or inserting multiple nodes > simultaneously with specific settings? e.g. doing cleanup only after all 4 new nodes joined cluster === allowed inserting multiple

New node insertion methods

2019-03-12 Thread Vsevolod Filaretov
Hello everyone! We have a cluster of 4 nodes, 4.5 tb/data per node, and are in the middle of adding 4 more nodes to the cluster. Joining a new node based on official guidelines/helps (setup cassandra on a new node, start cassandra instance, wait until node goes from JOINING state to NORMAL,

Re: too many logDroppedMessages and StatusLogger

2019-03-12 Thread Marco Gasparini
thanks for the answer Nate, my queries are more like the following: select f1,f2,f3, bigtxt from mytable where f1= ? and f2= ? limit 10; insert into mytable (f1,f2,f3,bigtxt) values (?,?,?,?) actually I have a text field (bigtxt) that could be > 1MB. Marco Il giorno lun 11 mar 2019 alle ore