Internal Security - Authentication & Authorization

2017-03-13 Thread Jacob Shadix
I'm looking for a deeper understanding of how Cassandra interacts with the system_auth keyspace to authenticate/authorize users. Here is what I have pieced together. Please let me know if I am on the right track. A user attempts to connect to Cassandra. Cassandra checks against system_auth for

Re: Does "nodetool repair" need to be run on each node for a given table?

2017-03-13 Thread daemeon reiydelle
I ​ find it helpful to read the manual first. After review, I would be happy to answer specific questions. https://docs.datastax.com/en/cassandra/2.1/cassandra/tools/toolsRepair.html​ *...* *Daemeon C.M. ReiydelleUSA (+1) 415.501.0198London (+44) (0) 20 8144 9872* On Mon, Mar 13, 2017

changing compaction strategy

2017-03-13 Thread Mike Torra
I'm trying to change compaction strategy one node at a time. I'm using jmxterm like this: `echo 'set -b org.apache.cassandra.db:type=ColumnFamilies,keyspace=my_ks,columnfamily=my_cf CompactionParametersJson

Does "nodetool repair" need to be run on each node for a given table?

2017-03-13 Thread Thakrar, Jayesh
I understand that the nodetool command connects to a specific server and for many of the commands, e.g. "info", "compactionstats", etc, the information is for that specific node. While for some other commands like "status", the info is for the whole cluster. So is "nodetool repair" that

Re: How to obtain partition size

2017-03-13 Thread Oskar Kjellin
How about this tool? https://github.com/instaclustr/cassandra-sstable-tools > On 13 Mar 2017, at 17:56, Artur R wrote: > > Hello! > > I can't find where C* stores information about partitions size (if stores it > at all). > So, the questions; > > 1. How to obtain the

How to obtain partition size

2017-03-13 Thread Artur R
Hello! I can't find where C* stores information about partitions size (if stores it at all). So, the questions; 1. How to obtain the size (in rows or in bytes - doesn't matter) of some particular partition? I know that there is *system.size_estimates* table with *mean_partition_size*, but it's

Re: A Single Dropped Node Fails Entire Read Queries

2017-03-13 Thread Shalom Sagges
Just some more info, I've tried the same scenario on 2.0.14 and 2.1.15 and didn't encounter such errors. What I did find is that the timeout errors appear only until the node is discovered as "DN" in nodetool status. Once the node is in DN status, the errors stop and the data is retrieved. Could

Re: Incremental Repair

2017-03-13 Thread Paulo Motta
> there are some nasty edge cases when you mix incremental repair and full repair ( https://issues.apache.org/jira/browse/CASSANDRA-13153 ) mixing incremental and full repairs will just make that more likely to happen, but although unlikely it's still possible for a similar condition to happen

Problem when try to use Date type at Cassandra

2017-03-13 Thread Otávio Gonçalves de Santana
I'm reading the types in Cassandra, and I would like to use dates, The documentations say that I can save the time as String with the following format: https://docs.datastax.com/en/cql/3.3/cql/cql_reference/cql_data_types_c.html So: CREATE KEYSPACE IF NOT EXISTS newKeySpace

Re: scylladb

2017-03-13 Thread Dor Laor
On Mon, Mar 13, 2017 at 12:17 AM, benjamin roth wrote: > @Dor,Jeff: > > I think Jeff pointed out an important fact: You cannot stop CS, swap > binaries and start Scylla. To be honest that was AFAIR the only "Oooh :(" I > had when reading the Scylla "marketing material". > If

Re: scylladb

2017-03-13 Thread Avi Kivity
Hi, We did indeed consider support for a mixed cluster, but in the end decided against it, for many reasons: - the internode protocol is underdocumented and keeps changing, so it would be hard to support it, and hard to test it - it would limit the kind of optimizations we can do by

Re: scylladb

2017-03-13 Thread Dor Laor
We came to the thread to provide technical answers about whether the difference in performance arise from C++ only or beyond. When the discussion included numa, we even dove deep into the weeds. I think we provided enough answers and I respect all of the opinions here and thus if someone has

Re: scylladb

2017-03-13 Thread benjamin roth
@Dor,Jeff: I think Jeff pointed out an important fact: You cannot stop CS, swap binaries and start Scylla. To be honest that was AFAIR the only "Oooh :(" I had when reading the Scylla "marketing material". If that worked it would be very valuable from both Scylla's and a users' point of view. As

Re: Row cache tuning

2017-03-13 Thread Thomas Julian
Hi Matija, ​Leveraging page cache yields good results and if accounted for can provide you with performance increase on read side ​ I would like to leverage the page cache to improve read performance. How this can be done? Best Regards, Julian. On Mon, 13 Mar 2017