Re: Compaction Strategy

2018-09-19 Thread Nitan Kainth
It’s not recommended to disable compaction, you will end up with hundreds to thousands of sstables and increased read latency. If your data is immitable, means no update/deletes it will have least impact. Decreasing compaction throughput will release resources for application but don’t accumula

Re: [EXTERNAL] Re: cold vs hot data

2018-09-19 Thread Alaa Zubaidi (PDF)
This is one of the options that we are thinking of, but this will require more storage, which is something that we are trying to avoid. We will test the performance for the batch inserts. Thanks On Tue, Sep 18, 2018 at 6:35 AM, Durity, Sean R wrote: > Wouldn’t you have the same problem with two

Re: cold vs hot data

2018-09-19 Thread Alaa Zubaidi (PDF)
Let me check lvmcache..Thanks On Thu, Sep 13, 2018 at 11:39 PM, Mateusz wrote: > On piątek, 14 września 2018 02:46:43 CEST Alaa Zubaidi (PDF) wrote: > > The data can grow to +100TB however the hot data will be in most cases > less > > than 10TB but we still need to keep the rest of data accessib

Re: Cassandra system table diagram

2018-09-19 Thread Joseph Arriola
Hi, I recomend this http://kdm.dataview.org/ its free and it has the implementation of good design practices that you can find in the DataStax courses. 2018-09-19 11:26 GMT-06:00 Abdul Patel : > Hi, > > Do we have somehwere cassandra system tables relation diagram? > Or just system table dia

Re: cold vs hot data

2018-09-19 Thread Alaa Zubaidi (PDF)
Thanks Ben, I will try this on 4.0 when its available. On Thu, Sep 13, 2018 at 7:06 PM, Ben Slater wrote: > Not quite a solution but you will probably be interested in the discussion > on this ticket: https://issues.apache.org/jira/browse/CASSANDRA-8460 > > On Fri, 14 Sep 2018 at 10:46 Alaa Zub

Re: Compaction Strategy

2018-09-19 Thread rajasekhar kommineni
Hello, Can any one respond to my questions. Is it a good idea to disable auto compaction and schedule it every 3 days. I am unable to control compaction and it is causing timeouts. Also will reducing or increasing compaction_throughput_mb_per_sec eliminate timeouts ? Thanks, > On Sep 17, 2

Cassandra system table diagram

2018-09-19 Thread Abdul Patel
Hi, Do we have somehwere cassandra system tables relation diagram? Or just system table diagram?

Re: Error during truncate: Cannot achieve consistency level ALL , how to fix it

2018-09-19 Thread sha p
RF is replication factor. Sorry for confusing On 19 Sep 2018 5:45 p.m., "Jonathan Baynes" wrote: What RF is your system_auth keyspace? If its one, match it to the user keyspace, and restart the node. *From:* sha p [mailto:shatestt...@gmail.com] *Sent:* 19 September 2018 11:49 *To:* user@ca

RE: Error during truncate: Cannot achieve consistency level ALL , how to fix it

2018-09-19 Thread Jonathan Baynes
What RF is your system_auth keyspace? If its one, match it to the user keyspace, and restart the node. From: sha p [mailto:shatestt...@gmail.com] Sent: 19 September 2018 11:49 To: user@cassandra.apache.org Subject: Error during truncate: Cannot achieve consistency level ALL , how to fix it Hi A

Cassandra repair in different version

2018-09-19 Thread nokia ceph
Hi , i have 5 node cassandra cluster. 3 nodes are in 3.0.13 version and 2 nodes are in 3.0.6. Is it safe to do a node repair on the cluster?? Regards, Renoy

Error during truncate: Cannot achieve consistency level ALL , how to fix it

2018-09-19 Thread sha p
> > Hi All, >>> I am new to Cassandra. Following below link >>> >>> >>> https://grokonez.com/spring-framework/spring-data/start-spring-data-cassandra-springboot#III_Sourcecode >>> >>> >>> I have three node cluster , keyspace set with RF = 2 , but when I run >>> this application from above source c