Re: consistency level question

Thanks, *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 2 5612956 On Mon, Mar 19, 2012 at 11:49 AM, aaron morton wrote: > Some information on node failures, consistency levels and avai

Re: Hector counter question

Thanks for the clarification, *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 2 5612956 On Tue, Mar 20, 2012 at 2:16 PM, Richard Low wrote: > On 20 March 2012 06:51, Tamar Fraenkel w

Re: Mutator or Template?

Thanks, I posted there. *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 2 5612956 On Tue, Mar 20, 2012 at 7:39 PM, aaron morton wrote: > For hector based questions try the Hector User g

Failed to delete C:\tmp\lib\cassandra\commitlog\CommitLog-1332175713378.log

Hi, I have a JUNIT test case that runs on Mac, but fails on windows. Below is the code where the exception occurs and the exception. I manually deleted the CommitLog-xyz.log, but that doesn't help. It feels like a bug in cassandra. Any comments? Can anybody suggest a workaround? @BeforeC

Re: Cassandra as Database for Role Based Access Control System

> 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

Re: cassandra-cli and "uncreachable" status confusion

On Wed, Mar 21, 2012 at 4:45 AM, aaron morton wrote: > 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-cli and "uncreachable" status confusion

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 wrote: > There is a server side check to ensure that

Re: Cassandra as Database for Role Based Access Control System

> 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 behavi

Re: Storing Counters in Hive

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 wrote: > What version are you using ? > > IIRC not all versions of the Hive driver support counters. > > Cheers > > -

Re: Mutator or Template?

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 Cassan

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

> 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 ha

Re: Storing Counters in Hive

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 Hiv

Re: replication in a 3 data center setup

> 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: Token Ring Gaps in a 2 DC Setup

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 Fre

Re: Get few rows by composite key.

> 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 lowe

Re: Another consistency level problem

Sounds like a problem in your code. You will have consistent behaviour when running a single cassandra node and CL ALL. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/03/2012, at 1:54 AM, Everton Lima wrote: > Hello people, I was ha

Re: repair broke TTL based expiration

Dne 20.3.2012 15:46, Jeremiah Jordan napsal(a): You need to create the tombstone in case the data was inserted without a timestamp at some point. Yes i figured it out too. It would helped if you can assign TTL to whole sstable. Most common use of TTL is for cache and there is most likely dedic

Re: Max # of CFs

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 wrote: > Hello. > > Fr

Cassandra and SSD

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

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

RE: repair broke TTL based expiration

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 expiratio

Re: Max # of CFs

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 http://www.datastax.com/dev/blog/whats-new-in-cassandra-1-0-improved-memory-and-disk-space-mana

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

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. http://www.datastax.com/docs/1.0/operations/cluster_management#add

Re: Hector counter question

On 20 March 2012 06:51, Tamar Fraenkel 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 reading and increment

Re: cassandra-cli and "uncreachable" status confusion

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, IP_OF