Mutator or Template?

2012-03-20 Thread Tamar Fraenkel
Hi! I am using Cassandra with Hector. Usually I use ColumnFamilyTemplate and ColumnFamilyUpdater to update column families, but sometimes I use Mutator. 1. Is there a preference of using one vs. the other? 2. Are there any actions that can be done with only one of them? Thanks, *Tamar Fraenkel

Cassandra as Database for Role Based Access Control System

2012-03-20 Thread Maciej Miklas
Hi *, I would like to know your opinion about using Cassandra to implement a RBAC-like authentication authorization model. We have simplified the central relationship of the general model ( http://en.wikipedia.org/wiki/Role-based_access_control) to: user ---n:m--- role ---n:m--- resource

Re: Hector counter question

2012-03-20 Thread Tamar Fraenkel
Thanks. But the increment is thread safe right? if I have two threads trying to increment a counter, then they won't step on each other toe? *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972

Re: cassandra-cli and uncreachable status confusion

2012-03-20 Thread R. Verlangen
That's correct. If you run describe cluster normally you'll see something like: Cluster Information: Snitch: org.apache.cassandra.locator.SimpleSnitch Partitioner: org.apache.cassandra.dht.RandomPartitioner Schema versions: 3a0f6a80-7140-11e1--511aec3785ff: [IP_OF_NODE,

Re: Hector counter question

2012-03-20 Thread Richard Low
On 20 March 2012 06:51, Tamar Fraenkel ta...@tok-media.com wrote: But the increment is thread safe right? if I have two threads trying to increment a counter, then they won't step on each other toe? That's right - you can have many threads incrementing the same counter and it's safe.  But

Re: CAn't bootstrap a new node to my cluster

2012-03-20 Thread Cyril Scetbon
On 3/15/12 9:16 AM, aaron morton wrote: normally join-ring is only used when the node is having some sort of problem. The best approach to bringing up a new is to explicitly set the token and start it with auto_bootstrap=true.

Re: Max # of CFs

2012-03-20 Thread A J
ok, the last thread says that 1.0+ onwards, thousands of CFs should not be a problem. But I am finding that all the allocated heap memory is getting consumed. I started with 8GB heap and then on reading

RE: repair broke TTL based expiration

2012-03-20 Thread Jeremiah Jordan
You need to create the tombstone in case the data was inserted without a timestamp at some point. -Jeremiah From: Radim Kolar [h...@filez.com] Sent: Monday, March 19, 2012 4:48 PM To: user@cassandra.apache.org Subject: Re: repair broke TTL based

Re: Max # of CFs

2012-03-20 Thread Vitalii Tymchyshyn
Hello. From my experience it's unwise to make many column families for same keys because you will have bloom filters and row indexes multiplied. If you have 5000, you should expect your heap requirements multiplied by same factor. Also check your cache sizes. Default AFAIR is 10 keys per

Cassandra and SSD

2012-03-20 Thread Johan Elmerfjord
This is a good presentation about using SSD with Cassandra. It's by RickBranson, DataStax http://www.slideshare.net/rbranson/cassandra-and-solid-state-drives At Adobe we use SSD with great success to get RAM-like Read performance. 99% of all our requests are returned within 4 ms. You can see a

Re: Max # of CFs

2012-03-20 Thread A J
I have both row cache and column cache disabled for all my CFs. cfstats says Bloom Filter Space Used: 1760 per CF. Assuming it is in bytes, it is total of about 9MB of bloom filter size for 5K CFs; which is not a lot. On Tue, Mar 20, 2012 at 11:09 AM, Vitalii Tymchyshyn tiv...@gmail.com wrote:

Re: Get few rows by composite key.

2012-03-20 Thread aaron morton
Is there any way to take rows with first key's part equals AA and second more or equal BB? Do a range slice starting with (AA:BB:) and without a finish row. Remember that range slices (of rows) are not in order when using the Random Partitioner.So you will also get back rows that have a lower

Re: Token Ring Gaps in a 2 DC Setup

2012-03-20 Thread aaron morton
mmm, has repair completed on all nodes ? Also, while it was digging around, I noticed that we do a LOT of reads immediately after writes, and almost every read from the first DC was bringing a read-repair along with it. What CL are you using ? Cheers - Aaron Morton

Re: replication in a 3 data center setup

2012-03-20 Thread aaron morton
More exactly, if you write a record in a node in DC1 will it send one replica of it to DC2 and then another replica to DC3? Or will the node in DC2 replicate the record to DC3 in a chain effect? Coordinator in DC 1 will send the mutation to both DC2 and DC3 at the same time. I need to

Re: Storing Counters in Hive

2012-03-20 Thread aaron morton
What version are you using ? IIRC not all versions of the Hive driver support counters. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/03/2012, at 1:09 PM, Sunit Randhawa wrote: I am trying to store Counters CF from cassandra to

Re: single row key continues to grow, should I be concerned?

2012-03-20 Thread aaron morton
The reads are only fetching slices of 20 to 100 columns max at a time from the row but if the key is planted on one node in the cluster I am concerned about that node getting the brunt of traffic. What RF are you using, how many nodes are in the cluster, what CL do you read at ? If you have

Re: Mutator or Template?

2012-03-20 Thread aaron morton
For hector based questions try the Hector User group https://groups.google.com/forum/?fromgroups#!forum/hector-users Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/03/2012, at 7:26 PM, Tamar Fraenkel wrote: Hi! I am using

Re: Storing Counters in Hive

2012-03-20 Thread Sunit Randhawa
Using DSE 1.0.2. Changing the column value type to 'bigint' worked in moving the Counters CF into Hive. Thanks Jake. On Tue, Mar 20, 2012 at 10:21 AM, aaron morton aa...@thelastpickle.comwrote: What version are you using ? IIRC not all versions of the Hive driver support counters. Cheers

Re: Cassandra as Database for Role Based Access Control System

2012-03-20 Thread aaron morton
user ---n:m--- role ---n:m--- resource I'm not sure what this means. While some inconsistencies may be acceptable, resource ownership (i.e. role=owner) must never ever be mixed up. If you are working at a high enough Consistent Level there Cassandra will provide consistent behaviour.

Re: cassandra-cli and uncreachable status confusion

2012-03-20 Thread aaron morton
no, describe cluster is a feature of the CLI. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/03/2012, at 11:24 AM, Shoaib Mir wrote: On Tue, Mar 20, 2012 at 4:18 AM, aaron morton aa...@thelastpickle.com wrote: There is a server side

Re: cassandra-cli and uncreachable status confusion

2012-03-20 Thread Shoaib Mir
On Wed, Mar 21, 2012 at 4:45 AM, aaron morton aa...@thelastpickle.comwrote: no, describe cluster is a feature of the CLI. How will you recommend doing schema level health checks (consistency) for Cassandra within the cluster? cheers, Shoaib

Re: Cassandra as Database for Role Based Access Control System

2012-03-20 Thread Maki Watanabe
user ---n:m--- role ---n:m--- resource It can work, but Cassandra is not RDBMS as you know, so RDBMS-ish data modeling may not fit in production. (depends on your requirement on performance. I'm not sure.) In general you should better to desgin schema from your access pattern. maki 2012/3/20