Maximum memory usage

2019-02-06 Thread Rahul Reddy
Hello, I see maximum memory usage alerts in my system.log couple of times in a day as INFO. So far I haven't seen any issue with db. Why those messages are logged in system.log do we have any impact for reads/writes with those warnings? And what nerd to be looked INFO [RMI TCP

Revive a downed node with a different IP address

2019-02-06 Thread Antoine d'Otreppe
Hi all, New to Cassandra, I'm trying to wrap my head around how dead nodes should be revived. Specifically, we deployed our cluster in Kubernetes, which means that nodes that go down will lose their IP address. When restarted, it is possible that: 1. their IP address changes 2. their new IP

Re: Revive a downed node with a different IP address

2019-02-06 Thread Jeff Jirsa
On Wed, Feb 6, 2019 at 5:47 AM Antoine d'Otreppe wrote: > Hi all, > > New to Cassandra, I'm trying to wrap my head around how dead nodes should > be revived. > > > Specifically, we deployed our cluster in Kubernetes, which means that > nodes that go down will lose their IP address. When

RE: SASI queries- cqlsh vs java driver

2019-02-06 Thread Kenneth Brotman
Isn’t that a lot of SASI indexes for one table. Could you denormalize more to reduce both columns per table and SASI indexes per table? Eight SASI indexes on one table seems like a lot. Kenneth Brotman From: Peter Heitman [mailto:pe...@heitman.us] Sent: Tuesday, February 05, 2019 6:59

Bootstrap keeps failing

2019-02-06 Thread Léo FERLIN SUTTON
Hello ! I am having a recurrent problem when trying to bootstrap a few new nodes. Some general info : - I am running cassandra 3.0.17 - We have about 30 nodes in our cluster - All healthy nodes have between 60% to 90% used disk space on /var/lib/cassandra So I create a new node and

RE: Maximum memory usage

2019-02-06 Thread Kenneth Brotman
Can you give us the “nodetool tablehistograms” Kenneth Brotman From: Rahul Reddy [mailto:rahulreddy1...@gmail.com] Sent: Wednesday, February 06, 2019 6:19 AM To: user@cassandra.apache.org Subject: Maximum memory usage Hello, I see maximum memory usage alerts in my system.log

RE: SASI queries- cqlsh vs java driver

2019-02-06 Thread Kenneth Brotman
Exactly. When you design your data model correctly you shouldn’t have to use ALLOW FILTERING in the queries. That is not recommended. Kenneth Brotman From: Peter Heitman [mailto:pe...@heitman.us] Sent: Wednesday, February 06, 2019 6:09 PM To: user@cassandra.apache.org Subject: Re: SASI

How to read the Index.db file

2019-02-06 Thread Pranay akula
I was trying to get all the partition of a particular SSTable, i have tried reading Index,db file i can read some part of it but not all of it , is there any way to convert it to readable format? Thanks Pranay

Two datacenters with one cassandra node in each datacenter

2019-02-06 Thread Kunal
HI All, I need some recommendation on using two datacenters with one node in each datacenter. In our organization, We are trying to have two cassandra dataceters with only 1 node on each side. From the preliminary investigation, I see replication is happening but I want to know if we can use

Re: SASI queries- cqlsh vs java driver

2019-02-06 Thread Peter Heitman
You are completely right! My problem is that I am trying to port code for SQL to CQL for an application that provides the user with a relatively general search facility. The original implementation didn't worry about secondary indexes - it just took advantage of the ability to create arbitrarily

RE: Two datacenters with one cassandra node in each datacenter

2019-02-06 Thread Kenneth Brotman
Hi Kunal, The short answer is absolutely not; that’s not what Cassandra is for. Cassandra is a distributed database for when you have to much data for one machine. Kenneth Brotman From: Kunal [mailto:kunal.v...@gmail.com] Sent: Wednesday, February 06, 2019 3:47 PM To:

Re: SASI queries- cqlsh vs java driver

2019-02-06 Thread Peter Heitman
Yes, I "know" that allow filtering is a sign of a (possibly fatal) inefficient data model. I haven't figured out how to do it correctly yet On Thu, Feb 7, 2019, 7:59 AM Kenneth Brotman wrote: > Exactly. When you design your data model correctly you shouldn’t have to > use ALLOW FILTERING in

RE: SASI queries- cqlsh vs java driver

2019-02-06 Thread Kenneth Brotman
The problem is you’re not using a query first design. I would recommend first reading chapter 5 of Cassandra: The Definitive Guide by Jeff Carpenter and Eben Hewitt. It’s available free online at this link

RE: Bootstrap keeps failing

2019-02-06 Thread Kenneth Brotman
Not sure off hand why that is happening but could you try bootstrapping that node from scratch again or try a different new node? Kenneth Brotman From: Léo FERLIN SUTTON [mailto:lfer...@mailjet.com.INVALID] Sent: Wednesday, February 06, 2019 9:15 AM To: user@cassandra.apache.org Subject:

Re: SASI queries- cqlsh vs java driver

2019-02-06 Thread Peter Heitman
Yes, I have read the material. The problem is that the application has a query facility available to the user where they can type in "(A = foo AND B = bar) OR C = chex" where A, B, and C are from a defined list of terms, many of which are columns in the mytable below while others are from other

Re: Two datacenters with one cassandra node in each datacenter

2019-02-06 Thread dinesh.jo...@yahoo.com.INVALID
Hey Kunal, Can you add more details about the size of data, read/write throughput, what are your latency expectations, etc? What do you mean by "performance" issue with replication? Without these details it's a bit tough to answer your questions. Dinesh On Wednesday, February 6, 2019,

Re: Bootstrap keeps failing

2019-02-06 Thread dinesh.jo...@yahoo.com.INVALID
Would it be possible for you to take a thread dump & logs and share them? Dinesh On Wednesday, February 6, 2019, 10:09:11 AM PST, Léo FERLIN SUTTON wrote: Hello ! I am having a recurrent problem when trying to bootstrap a few new nodes. Some general info :  - I am running

Re: Maximum memory usage

2019-02-06 Thread dinesh.jo...@yahoo.com.INVALID
Are you running any nodetool commands during that period? IIRC, this is a log entry emitted by the BufferPool. It may be harm unless it's happening very often or logging a OOM. Dinesh On Wednesday, February 6, 2019, 6:19:42 AM PST, Rahul Reddy wrote: Hello, I see maximum memory

Re: Two datacenters with one cassandra node in each datacenter

2019-02-06 Thread dinesh.jo...@yahoo.com.INVALID
You also want to use Cassandra with a minimum of 3 nodes. Dinesh On Wednesday, February 6, 2019, 11:26:07 PM PST, dinesh.jo...@yahoo.com wrote: Hey Kunal, Can you add more details about the size of data, read/write throughput, what are your latency expectations, etc? What do you mean