Re: cassandra repair takes ages

Changing the datadrives to SSD would help to speed up the repairs. Also don't run 3 node, RF2. That makes Quorum = All. Regards, Carlos Juzarte Rolo Cassandra Consultant / Datastax Certified Architect / Cassandra MVP Pythian - Love your data rolo@pythian | Twitter: @cjrolo | Skype: cjr2k3 |

Re: what's the read cl of list read-on-write operations?

But it seems that it uses cl to read list from cluster just like I said: https://github.com/apache/cassandra/blob/trunk/src/java/org/apache/cassandra/cql3/statements/ModificationStatement.java#L398 2018-04-20 16:12 GMT+08:00 DuyHai Doan : > The read operation on the list

Re: what's the read cl of list read-on-write operations?

Let me clarify my question more: Given the rf is 3, r/w cl is quorum. Initially, the list is empty, the user appends one element into the list: list += [foo] Then node A is down, and the user prepends another element: list = [bar] + list Then A comes back, assuming the list on A is still [foo],

cassandra repair takes ages

Hello, I have a 3 node cluster with RF 2 and using STCS. I use SSDs for commitlogs and HDDs for data. Apache Cassandra version is 3.11.2. I basically have a huge keyspace ('newts' from opennms) and a big keyspace ('opspanel'). Here's a summary of the 'du' output for one node (which is more or

Regular NullPointerExceptions from `nodetool compactionstats` on 3.7 node

Hi all, We have a cluster running on Cassandra 3.7 (we already know this is considered a "bad" version and plan to upgrade to 3.11 in the not-too-distant future) and we have a few Nagios checks that run `nodetool compactionstats` to check how many pending compactions there currently are, as well

Re: How to restrict users to specific DC.

Thanks Sam, that's what i was looking for good to know it's in pipeline Regards Pranay On Thu, Apr 19, 2018 at 4:23 AM, Sam Tunnicliffe wrote: > https://issues.apache.org/jira/browse/CASSANDRA-13985 is probably what > you're looking for here > > Thanks, > Sam > > On 10 April

Understanding nodetool describering

I was trying to understand the token ranges the nodetool describering retunrs, i ran it on different keyspaces across clusters of different sizes, couldn't figure out how the no.of token ranges we calculated ?? If it something like replication * no.of nodes in DC * num_token not sure

Re: How to configure Cassandra to NOT use SSLv2?

On 04/20/2018 08:46 AM, Lou DeGenaro wrote: > Could you be more specific?  What does one specify exactly to assure > SSLv2 is not used for both client-server and server-server > communications?  Example yaml statements would be wonderful.  The defaults in cassandra.yaml have only TLS specified in

Re: SSTable count in Nodetool tablestats(LevelCompactionStrategy)

I'm currently investigating this issue on one of our clusters (but much worse, we're seeing >100 SSTables and only 2 in the levels) on 3.11.1. What version are you using? It's definitely a bug. On 17 April 2018 at 10:09, wrote: > Dear Community, > > > > One of the tables

Re: 答复: Cassandra 3.7 - Problem with Repairs - all nodes failing

Hi, You can have a look to https://github.com/apache/cassandra/blob/trunk/NEWS.txt which list every modification / advice for upgrading between each C* version On 20 April 2018 at 09:25, Xiangfei Ni wrote: > By the way,is there official documentation for online upgrade

Re: Large size KS management

On Fri, Apr 20, 2018 at 4:08 AM, Aiman Parvaiz wrote: > Hi all > > I have been given a 15 nodes C* 2.2.8 cluster to manage which has a large > size KS (~800GB). > Is this per node or in total? > Given the size of the KS most of the management tasks like repair take a >

Re: 答复: 答复: Cassandra 3.7 - Problem with Repairs - all nodes failing

Hi, I believe there is no such official apache documentation, and since Datastax removed the old guide to redirect to the apache one, you are left with Google to look for guidance. As a general advice (from what I can recall) : - you might want to run nodetool cleanup before upgrading to free

答复: 答复: 答复: Cassandra 3.7 - Problem with Repairs - all nodes failing

Thank you very much,Nicolas. Best Regards, 倪项菲/ David Ni 中移德电网络科技有限公司 Virtue Intelligent Network Ltd, co. Add: 2003,20F No.35 Luojia creative city,Luoyu Road,Wuhan,HuBei Mob: +86 13797007811|Tel: + 86 27 5024 2516 发件人: Nicolas Guyomar 发送时间: 2018年4月20日 16:37 收件人:

答复: Cassandra 3.7 - Problem with Repairs - all nodes failing

By the way,is there official documentation for online upgrade cassandra from 3.9 to 3.11.2 which I can follow? Best Regards, 倪项菲/ David Ni 中移德电网络科技有限公司 Virtue Intelligent Network Ltd, co. Add: 2003,20F No.35 Luojia creative city,Luoyu Road,Wuhan,HuBei Mob: +86 13797007811|Tel: + 86 27 5024 2516

Re: what's the read cl of list read-on-write operations?

The read operation on the list column is done locally on each replica so replication factor does not really apply here On Fri, Apr 20, 2018 at 7:37 AM, Jinhua Luo wrote: > Hi All, > > Some list operations, like set by index, needs to read the whole list > before update. >

答复: 答复: Cassandra 3.7 - Problem with Repairs - all nodes failing

Hi Nicolas, Thanks for your reply. The doc you sent to me only includes what have been upgrade between every version,but I want the doc of how to do the online upgrade,do you have this kind of doc? Best Regards, 倪项菲/ David Ni 中移德电网络科技有限公司 Virtue Intelligent Network Ltd, co. Add: 2003,20F No.35

RE: SSTable count in Nodetool tablestats(LevelCompactionStrategy)

I used version: 3.11.2 I want to add that both the counts (SSTables, sum of numbers shown in levels), change after some time and become equal(i.e. the mismatch does not last forever) which has led me to believe that this mismatch happens only when the compaction process is going on and once

Re: How to know version of TLS being used

Hi , I am using python. Is capturing traffic using wireshark right way to know this? Thanks Ashutosh On Fri, Apr 20, 2018 at 11:11 AM Rajesh Kishore wrote: > If you are using java client , generally to find what is the protocol and > cipher used , you can configure

Re: what's the read cl of list read-on-write operations?

Do you confirm it just reads the local storage? If so, I have a question: Think that, the user reads the list using QUORUM CL, e.g. the value is {a,b,c}, then, it wants to set the second item b. It sends such write request to some coordinator, but that coordinator has outdated version in its

Re: Nodetool repair multiple dc

One quick question on reaper ..what data is stored in reaper_db keyspace ? And how much does it grow? Do we have to cleanup that frequently or reaper has mechnism to slef clean ? On Friday, April 13, 2018, Alexander Dejanovski wrote: > Hi Abdul, > > Reaper has been used

How to configure Cassandra to NOT use SSLv2?

Running Cassandra produces the following error message: "SSLv2Hello is not a recognized protocol" because the JVM being used does not support SSLv2. The JVM does not support SSLv2 because "it's a HUGE security risk." How does one configure Cassandra to *not* use SSLv2? Thanks. Lou.

Re: Cassandra 3.7 - Problem with Repairs - all nodes failing

We dont have enough time before our major infrastructure upgrade to do the cassandra upgrade. is there any insight on the below if I run the repair with DC option (-dc localdatacenter) for local datacenters, then all repairs are successfully. Is this indication that the repairs are good? can

Re: what's the read cl of list read-on-write operations?

The inconsistency scenario you describe can occur for sure Now repair (read repair, consistent read + weekly repair) is there to fix it "Why Cassandra do not read from cluster with somehow read CL before updating the list?" Because read-before-write on the cluster level is an anti-pattern. The

Re: How to know version of TLS being used

Yes that's also the way. On Fri, 20 Apr 2018, 15:55 Ashutosh Kumar, wrote: > Hi , > I am using python. Is capturing traffic using wireshark right way to know > this? > Thanks > Ashutosh > > On Fri, Apr 20, 2018 at 11:11 AM Rajesh Kishore >

Re: How to configure Cassandra to NOT use SSLv2?

On 04/20/2018 07:41 AM, Lou DeGenaro wrote: > Running Cassandra produces the following error message: > > "SSLv2Hello is not a recognized protocol" > > because the JVM being used does not support SSLv2. The JVM does not > support SSLv2 because "it's a HUGE security risk." > > How does one

Re: How to configure Cassandra to NOT use SSLv2?

Could you be more specific? What does one specify exactly to assure SSLv2 is not used for both client-server and server-server communications? Example yaml statements would be wonderful. Your patience with the security neophyte is greatly appreciated. Lou. On Fri, Apr 20, 2018 at 9:35 AM,