Re: ReadRepairStage

2019-07-18 Thread Bobbie Haynes
I have updated all the nodes in the cluster dcread_repair_chance to 0.0 stilll i see lot of messages. On Thu, Jul 18, 2019 at 10:13 AM Bobbie Haynes wrote: > Hi, > We are using Apache Cassandra 3.11.4 .Recently we are seeing > overloaded readrepair ERROR messages in the entir

ReadRepairStage

2019-07-18 Thread Bobbie Haynes
Hi, We are using Apache Cassandra 3.11.4 .Recently we are seeing overloaded readrepair ERROR messages in the entire cluster because that we are getting timeouts ..I'm not able to find the root cause for this . Appreciate any inputs on this issue .. ERROR [ReadRepairStage:2537] 2019-07-18

Re: Increasing the size limits implications

2019-04-30 Thread Bobbie Haynes
RDBMS, because larger transactions improve > performance. That doesn't apply with Cassandra. > > Batches are OK at keeping multiple tables in sync, that's about it. > > Jon > >> On Mon, Apr 29, 2019 at 10:18 AM Bobbie Haynes wrote: >> >> Hi, >&g

Increasing the size limits implications

2019-04-29 Thread Bobbie Haynes
Hi, I'm inserting into cassandra in batches(With each containing single PK ).But my batch is failing and throwing exceptions. I want to know if we increase batch_size_warn_threshold_in_kb to 200KB and batch_size_fail_threshold_in_kb to 300KB. What could be potential issues i could be facing

Re: Audit in C*

2019-03-13 Thread Bobbie Haynes
Yes.we are using it and it is very helpful to u so far...! On Wed, Mar 13, 2019 at 11:38 AM Rahul Singh wrote: > Which version are you referring to? > > On Wed, Mar 13, 2019 at 10:28 AM Nitan Kainth > wrote: > >> Hi, >> >> Anybody have used auditing to find out failed login attempts, or >>

data modelling

2019-03-05 Thread Bobbie Haynes
Hi Could you help modelling this usecase I have below table ..I will update tagid's columns set(bigit) based on PK. I have created the secondary index column on tagid to query like below.. Select * from keyspace.customer_sensor_tagids where tagids CONTAINS 11358097; this query is doing

Re: datamodelling

2019-02-05 Thread Bobbie Haynes
even if i try to create a agent_type it will be same issue again because agent_id and agent_type have same values... On Tue, Feb 5, 2019 at 11:36 AM Bobbie Haynes wrote: > unfortunately i do not have different of agents(agent_type) .. i only have > agent_id which is also a UUID type. >

Re: datamodelling

2019-02-05 Thread Bobbie Haynes
tition into smaller ones but you > will have to query with agent_id and agent_type in that case. > > On Tue, Feb 5, 2019 at 12:59 PM Bobbie Haynes > wrote: > >> Hi Everyone, >> Could you please help me in modeling my table >> below.I'm s

datamodelling

2019-02-05 Thread Bobbie Haynes
Hi Everyone, Could you please help me in modeling my table below.I'm stuck here. My Partition key is agent_id and clustering column is rowid. Each agent can have a minimum of 1000 rows to 10M depends on how busy the agent .I'm facing large partition issue for my busy agents.

Re: Cassandra 3.11.3 map errors

2019-01-15 Thread Bobbie Haynes
Hi Roy, I don't think the Memory Leak issue is related to MAP errors .I was also using Reaper in our cluster.I have seen Memory Leak issue (ERROR [Reference-Reaper:1] 2019-01-14 00:03:46,469 Ref.java:224 - LEAK DETECTED) when some of SStables got corrupted because of disk space issue

Cassandra running Multiple JVM's

2018-10-24 Thread Bobbie Haynes
I have three Physical servers. I want to run cassandra on multiple JVM's i.e each physical node contains 2 cassandra nodes so that i could able to run 6 node cluster.Could anyone help me pointing setup guide. Each Physical node Configuration:- RAM -256 GB --- I want to assign each JVM(64GB)