Re: UnavailableException when data grows

2010-09-28 Thread Oleg Anastasyev
Rana Aich aichrana at gmail.com writes: Yet my nodetool shows the following: 192.168.202.202Down       319.94 GB     7200044730783885730400843868815072654      |--| 192.168.202.4 Up         382.39 GB     23719654286404067863958492664769598669     |   ^ 192.168.202.2 Up         106.81 GB  

Re: Best strategy for adding new nodes to the cluster

2010-09-28 Thread Janne Jalkanen
On 28 Sep 2010, at 08:37, Michael Dürgner wrote: What do you mean by running live? I am also planning to use cassandra on EC2 using small nodes. Small nodes have 1/4 cpu of the large ones, 1/4 cost, but I/O is more than 1/4 (amazon does not give explicit I/O numbers...), so I think 4

Re: Is there a debian 0.6.1 install package archived anywhere?

2010-09-28 Thread Eric Evans
On Mon, 2010-09-27 at 14:42 -0700, Kyusik Chung wrote: We're running a cassandra cluster using 0.6.1 and we need to add a node. Id like to add another node with the same version so that I don't have to test a mixed version cluster or test (and conduct) a whole-scale upgrade to 0.6.5and

Migrating from Mysql to Cassandra

2010-09-28 Thread sekhar kosuru
Hi I am involving in migrating our database Mysql to Cassandra. After Google about Cassandra database i feel following are some issues we need to find the solutions. Suggest me if my analysis is wrong or for my doubts. *1) Projecting all the rows* - If we fixed KeyRange count to N records and

Re: Dazed and confused with Cassandra on EC2 ...

2010-09-28 Thread Jedd Rashbrooke
Peter - my apologies for the slow response - we had to divert down a 'Plan B' approach last week involving MySQL, memcache, redis and various other uglies. On 20 September 2010 23:11, Peter Schuller peter.schul...@infidyne.com wrote: Are you running an old JVM by any chance? (Just grasping

Schema Questions?

2010-09-28 Thread Frank LoVecchio
Question regarding schema set-up and modification: I just set up the newest nightly build of 0.7, imported our .yaml file after starting Cassandra, and everything is honky-dorey. We're not sure if Pelops is capable of modifying shema definitions, but it doesn't appear any changes we make to the

Re: Schema Questions?

2010-09-28 Thread Peter Schuller
Question regarding schema set-up and modification:  I just set up the newest nightly build of 0.7, imported our .yaml file after starting Cassandra, and everything is honky-dorey.  We're not sure if Pelops is capable of modifying shema definitions, but it doesn't appear any changes we make to

Re: Schema Questions?

2010-09-28 Thread Frank LoVecchio
I understand adding column family configuration fields using thrift in Pelops for system_add_column_family, and even renaming column families, but what about modifying the actual column family configuration values, e.g. read_repair_chance: 1.0 to read_repair_chance: .5 (as a poor example)? On

Re: Migrating from Mysql to Cassandra

2010-09-28 Thread Aaron Morton
1) Thats the general approach http://wiki.apache.org/cassandra/FAQ#iter_world for Not sure why you think it will run into aninfinitelooop.2) Not sure what your question is here. You either need to maintain the indexes yourself (by using a CF where the cols are the keys for another CF) or use the

Re: Schema Questions?

2010-09-28 Thread Aaron Morton
There is asystem_update_column_family(CDef) function on the trunk, so it will be in 0.7-beta2. Take a look at the interface/cassandra.thrift .AOn 29 Sep, 2010,at 09:31 AM, Frank LoVecchio fr...@isidorey.com wrote:I understand adding column family configuration fields using thrift in Pelops for

Re: Schema Questions?

2010-09-28 Thread Frank LoVecchio
Ok, I tried that method in Pelops, and this is the error I get when trying to to update a Column Family Type from Standard to Super: InvalidRequestException(why:types do not match.) at org.apache.cassandra.thrift.Cassandra$system_update_column_family_result.read(Cassandra.java:27741)

avro + cassandra + ruby

2010-09-28 Thread Gabor Torok
Hi, I'm attempting to use avro to talk to cassandra because the ruby thrift client's read performance is pretty bad (I measured 4x slower than java). However, I run into a problem when calling multiget_slice. The server gives a KeyspaceNotDefinedException because clientState.getKeyspace()

Re: avro + cassandra + ruby

2010-09-28 Thread Ryan King
On Tue, Sep 28, 2010 at 4:06 PM, Gabor Torok gabor.to...@sunpowercorp.com wrote: Hi, I'm attempting to use avro to talk to cassandra because the ruby thrift client's read performance is pretty bad (I measured 4x slower than java). Only 4x feels like a win. :) One thing you should try is to

Wed: Seattle Scalability / Hadoop / NoSQL Meetup: Killer Guests!

2010-09-28 Thread Bradford Stephens
Hey guys! Just wanted to let you know that Wednesday's meetup is going to have some *fantastic* speakers from around the world :) You need to come! http://www.meetup.com/Seattle-Hadoop-HBase-NoSQL-Meetup/calendar/13704368/ Wednesday, 7pm, Amazon SLU. First we have Tim Anglade, who flew here all

Re: Is the secondary index maintained synchronously in 0.7

2010-09-28 Thread Jonathan Ellis
because it's not worth the penalty to concurrency On Tue, Sep 28, 2010 at 9:02 PM, Alvin UW alvi...@gmail.com wrote: Why the secondary index is not updated absolutely atomically? 2010/9/2 Jonathan Ellis jbel...@gmail.com yes, it is updated atomically (but not in isolation, it's possible for

Couple of minor logging / error message things

2010-09-28 Thread Aaron Morton
Noticed these when working against the current 0.7.0 beta2 (#3) build...When sending a system_add_keyspace request with an invalid keyspace the response to the client is fine...(python)InvalidRequestException: InvalidRequestException(why='Invalid keyspace name: Test Keyspace 1285729085.78')However

Re: avro + cassandra + ruby

2010-09-28 Thread Gabor Torok
Thanks, that made things better by about 30%. Unfortunately for me that's still unacceptable... :-( I feel like I'm doing something wrong with avro (see my original post). Was anyone able to make it work?

Re: Couple of minor logging / error message things

2010-09-28 Thread Jonathan Ellis
On Tue, Sep 28, 2010 at 10:28 PM, Aaron Morton aa...@thelastpickle.com wrote: Noticed these when working against the current 0.7.0 beta2 (#3) build... When sending a system_add_keyspace request with an invalid keyspace the response to the client is fine... (python) InvalidRequestException:

Truncate + Snapshot + Cannot Allocate Memory == Timeout

2010-09-28 Thread Aaron Morton
Running on the current 0.7.0 beta2 #3.On my dev workstation (unubtu 10.4) Iaccidentallylet cassandra have 4GB and free memory got down to 100 MB . I was running some tests that added a few ( 100) rows to the CF's in Keyspace1, then Truncated the CF's for the next tests.I got the following error in

Re: Truncate + Snapshot + Cannot Allocate Memory == Timeout

2010-09-28 Thread Jonathan Ellis
On Tue, Sep 28, 2010 at 11:25 PM, Aaron Morton aa...@thelastpickle.com wrote: 1) Is the memory error just a result of me letting my machine run stupidly low on memory? No, it's the JVM forking to run ln. Enable overcommit, or get JNA so it does the link w/ native code instead. 2) Should it

Re: Is there a debian 0.6.1 install package archived anywhere?

2010-09-28 Thread Kyusik Chung
Thanks Eric. Im not sure why I couldnt locate it earlierthought I had looked in all the directories. Kyusik Chung