Re: new "nodetool ring" output and unbalanced ring?

2012-09-10 Thread Guy Incognito
out of interest, why -100 and not -1 or + 1? any particular reason? On 06/09/2012 19:17, Tyler Hobbs wrote: To minimize the impact on the cluster, I would bootstrap a new 1d node at (42535295865117307932921825928971026432 - 100), then decommission the 1c node at 4253529586511730793292182592897

Re: Data Modeling- another question

2012-08-27 Thread Guy Incognito
i would respectfully disagree, what you have said is true but it really depends on the use case. 1) do you expect to be doing updates to individual fields of an item, or will you always update all fields at once? if you are doing separate updates then the first is definitely easier to handle

Re: Truncate failing with 1.0 client against 0.7 cluster

2012-07-16 Thread Guy Incognito
on wrote: UnavailableException is a server side error, whats the full error message ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/07/2012, at 5:31 AM, Guy Incognito wrote: i'm doing an upgrade of Cassandra 0.7 to 1.0 at the mome

Truncate failing with 1.0 client against 0.7 cluster

2012-07-16 Thread Guy Incognito
i'm doing an upgrade of Cassandra 0.7 to 1.0 at the moment, and as part of the preparation i'm upgrading to 1.0 client libraries (we use Hector 1.0-5) prior to upgrading the cluster itself. I'm seeing some of our integration tests against the dev 0.7 cluster fail as they get UnavailableExcepti

Re: cassandra 1.0.9 error - "Read an invalid frame size of 0"

2012-06-26 Thread Guy Incognito
i have seen this as well, is it a known issue? On 18/06/2012 19:38, Gurpreet Singh wrote: I found a fix for this one, rather a workaround. I changed the rpc_server_type in cassandra.yaml, from hsha to sync, and the error went away. I guess, there is some issue with the thrift nonblocking ser

Re: Schema advice/help

2012-03-28 Thread Guy Incognito
On 28/03/2012 09:49, Maciej Miklas wrote: yes - but anyway in your example you need "key range quey" and that requires OOP, right? On Tue, Mar 27, 2012 at 5:13 PM, Guy Incognito <mailto:dnd1...@gmail.com>> wrote: multiget does not require OPP. On 27/03/2012 09:5

Re: Schema advice/help

2012-03-27 Thread Guy Incognito
dpress.com/2011/03/02/cassandra-secondary-index-patterns/ On Tue, Mar 27, 2012 at 10:10 AM, Guy Incognito <mailto:dnd1...@gmail.com>> wrote: without the ability to do disjoint column slices, i would probably use 5 different rows. userId:itemType -> activityId then it

Re: problem in create column family

2012-03-27 Thread Guy Incognito
why don't you show us the command you're actually trying to run? On 27/03/2012 08:52, puneet loya wrote: I m using cassandra 1.0.8.. Please reply On Tue, Mar 27, 2012 at 12:28 PM, R. Verlangen > wrote: Not sure about that, what version of Cassandra are you using?

Re: Schema advice/help

2012-03-27 Thread Guy Incognito
without the ability to do disjoint column slices, i would probably use 5 different rows. userId:itemType -> activityId then it's a multiget slice of 10 items from each of your 5 rows. On 26/03/2012 22:16, Ertio Lew wrote: I need to store activities by each user, on 5 items types. I always wan

Re: Exceptions related to thrift transport

2012-03-22 Thread Guy Incognito
are you perhaps trying to send a large batch mutate? i've seen broken pipes etc in cassandra 0.7 (currently in the process of upgrading to 1.0.8) when a large batch mutate is sent. On 22/03/2012 07:09, Tiwari, Dushyant wrote: Hector version 1.0-3 What is the reason for the second exception,

Re: Newbie Question: Cassandra consuming 100% CPU on ubuntu server

2012-02-18 Thread Guy Incognito
perhaps entirely unrelated, but somebody was asking about lockups on EC2 yesterday and found: http://wiki.apache.org/cassandra/FAQ#ubuntu_hangs On 18/02/2012 14:58, Aditya Gupta wrote: Am I installing it the right way ? While installing I didn't verify the signatures using public key. On Sat,

Re: read-repair?

2012-02-02 Thread Guy Incognito
sorry to be dense, but which is it? do i get the old version or the new version? or is it indeterminate? On 02/02/2012 01:42, Peter Schuller wrote: i have RF=3, my row/column lives on 3 nodes right? if (for some reason, eg a timed-out write at quorum) node 1 has a 'new' version of the row/co

read-repair?

2012-02-01 Thread Guy Incognito
how does read repair work in the following scenario? i have RF=3, my row/column lives on 3 nodes right? if (for some reason, eg a timed-out write at quorum) node 1 has a 'new' version of the row/column (eg clock = 10), but node 2 and 3 have 'old' versions (clock = 5), when i try to read my ro

atomicity of a row write

2012-01-23 Thread Guy Incognito
hi all, having read: http://wiki.apache.org/cassandra/FAQ#batch_mutate_atomic i would like some clarification: is a write to a single row key in a single column family atomic in the sense that i can do a batch mutate where i 1) write col 'A' to key 'B' 2) write 'col 'C' to key 'B' and eithe

Re: Replacing supercolumns with composite columns; Getting the equivalent of retrieving a list of supercolumns by name

2012-01-04 Thread Guy Incognito
i know it's a throwaway example, but i would probably structure your column the other way around in that case. ie steve.4, steve.5, steve.6, greg.4, greg.6, greg.9. and then do two slice queries, steve.4-steve.10, greg.4-greg.10. On 04/01/2012 15:41, Jeremiah Jordan wrote: You can't use a slic

Re: Doubts related to composite type column names/values

2011-12-20 Thread Guy Incognito
afaik composite lets you do sorting in a way that would be difficult/impossible with string concatenation. eg with the string ascending, and the integer descending. if i had composites available (which i don't b/c we are on 0.7), i would use them over string concatenation. string concatenati

Re: memory estimate for each key in the key cache

2011-12-18 Thread Guy Incognito
to be blunt, this doesn't sound right to me, unless it's doing something rather more clever to manage the memory. i mocked up a simple class containing a byte[], ByteBuffer and long, and the shallow size alone is 32 bytes. deep size with a byte[16], 1-byte bytebuffer and long is 132. this is

Re: best practices for simulating transactions in Cassandra

2011-12-10 Thread Guy Incognito
you could try writing with the clock of the initial replay entry? On 06/12/2011 20:26, John Laban wrote: Ah, neat. It is similar to what was proposed in (4) above with adding transactions to Cages, but instead of snapshotting the data to be rolled back (the "before" data), you snapshot the dat

Re: UUIDType

2011-11-21 Thread Guy Incognito
tent with RFC4122, and it seems like they are not either. On 21/11/2011 18:34, Jonathan Ellis wrote: I think that's correct, but why would you want to do that? On Sun, Nov 20, 2011 at 2:55 AM, Guy Incognito wrote: am i correct that neither of Cassandra's UUIDTypes (at least in 0.7) compar

UUIDType

2011-11-20 Thread Guy Incognito
am i correct that neither of Cassandra's UUIDTypes (at least in 0.7) compare UUIDs according to RFC4122 (ie as two unsigned longs)?

Re: indexes from CassandraSF

2011-11-14 Thread Guy Incognito
sets new location (L3) on user U0 BTW, just to reiterate since this sometimes comes up, the timestamps being stored in these tuples are not longs, they're time UUIDs, so T1 and T2 are never equal. Ed On Sun, Nov 13, 2011 at 6:52 AM, Guy Incognito wrote: [1] i'm not particularly wo

Re: Mass deletion -- slowing down

2011-11-14 Thread Guy Incognito
i think what he means is...do you know what day the 'oldest' day is? eg if you have a rolling window of say 2 weeks, structure your query so that your slice range only goes back 2 weeks, rather than to the beginning of time. this would avoid iterating over all the tombstones from prior to the

Re: indexes from CassandraSF

2011-11-13 Thread Guy Incognito
s. Take a look at the sample code. Hope this helps, Ed On Sat, Nov 12, 2011 at 3:59 PM, Guy Incognito wrote: help? On 10/11/2011 19:34, Guy Incognito wrote: hi, i've been looking at the model below from Ed Anuff's presentation at Cassandra CF (http://www.slideshare.net/edanuff/inde

Re: indexes from CassandraSF

2011-11-12 Thread Guy Incognito
help? On 10/11/2011 19:34, Guy Incognito wrote: hi, i've been looking at the model below from Ed Anuff's presentation at Cassandra CF (http://www.slideshare.net/edanuff/indexing-in-cassandra). Couple of questions: 1) Isn't there still the chance that two concurrent upd

indexes from CassandraSF

2011-11-10 Thread Guy Incognito
hi, i've been looking at the model below from Ed Anuff's presentation at Cassandra CF (http://www.slideshare.net/edanuff/indexing-in-cassandra). Couple of questions: 1) Isn't there still the chance that two concurrent updates may end up with the index containing two entries for the given us

Re: security

2011-11-09 Thread Guy Incognito
appropriate rules. On Tue, Nov 8, 2011 at 6:30 PM, Guy Incognito wrote: hi, is there a standard approach to securing cassandra eg within a corporate network? at the moment in our dev environment, anybody with network connectivity to the cluster can connect to it and mess with it. this would not be

security

2011-11-08 Thread Guy Incognito
hi, is there a standard approach to securing cassandra eg within a corporate network? at the moment in our dev environment, anybody with network connectivity to the cluster can connect to it and mess with it. this would not be acceptable in prod. do people generally write custom authentica

CompositeType for use with 0.7

2011-11-05 Thread Guy Incognito
Is this a lib I can just drop into a 0.7 instance of cassandra and use? I'm not sure what to make of the README about not using it with versions earlier than 0.8.0-rc1. https://github.com/riptano/hector-composite the goal is to start using CompositeTypes in 0.7 (which I can't upgrade to 0.8

super sub slice query?

2011-10-27 Thread Guy Incognito
is there such a thing? a query that runs against a SC family and returns a subset of subcolumns from a set of super-columns? is there a way to have eg a slice query (or super slice query) only return the column names, rather than the value as well?