Re: Cassandra not suitable?

2011-12-06 Thread Peter Schuller
> I'm quite desperate about Cassandra's performance in our production > cluster. We have 8 real-HW nodes, 32core CPU, 32GB memory, 4 disks in > raid10, cassandra 0.8.8, RF=3 and Hadoop. > We four keyspaces, one is the large one, it has 2 CFs, one is kind of > index, the other holds data. There are

sstable count=0, why nodetool ring is not 0

2011-12-06 Thread 祝海通
hi,all We are using Cassandra 1.0.2. I am testing the TTL with loading 400G. When all the data are expired, I waited for some hours. Later, the nodetool ring is still have 90GB. So I made a major compaction. Then there are 30GB from the nodetool ring. After I saw the file system,I found there are

Re: building a new email-like inbox service with cassandra

2011-12-06 Thread Rustam Aliyev
Hi, Just updating this thread: We've pushed initial version to github today. You can find sources, binary package and some information here: https://github.com/elasticinbox/elasticinbox/wiki Your feedback is most welcome. We can discuss it further on elasticin...@googlegroups.com mail list.

Re: Upgrade from 0.6 to 1.0

2011-12-06 Thread Jehan Bing
Found my problem: I was using a very old cassandra (0.6.1). So I upgraded to 0.6.13 first then I could start 1.0.5. And so by trial, I can then answer my other questions: - no, config-convert is not necessary and I can just edit the default cassandra.yaml - no, I don't need schematool, can just

Re: cassandra most stable version ?

2011-12-06 Thread Jahangir Mohammed
We are running 0.8.7. No big issues so far. Thanks, Jahangir. On Tue, Dec 6, 2011 at 5:05 PM, Pierre Chalamet wrote: > Hello, > > ** ** > > Recent problems with Cassandra 1.0.x versions seems to tell it is still > not ready for prime time. > > ** ** > > We are currently using version 0.

cassandra most stable version ?

2011-12-06 Thread Pierre Chalamet
Hello, Recent problems with Cassandra 1.0.x versions seems to tell it is still not ready for prime time. We are currently using version 0.8.5 on our development cluster - although we have not seen much problems with this one, maybe recent versions of 0.8.x might be safer to use. So what

Re: Is this a limitation of CQL?

2011-12-06 Thread Peter Lin
thanks for confirming that. I was guessing that was the rationale and it makes sense. Didn't want to make a stupid assumption. On Tue, Dec 6, 2011 at 4:14 PM, Jeremiah Jordan wrote: > As designed in all versions.  The search queries have to have an indexed > column which is keyed by "=".  C* i

Re: Is this a limitation of CQL?

2011-12-06 Thread Jeremiah Jordan
As designed in all versions. The search queries have to have an indexed column which is keyed by "=". C* is still a key/value store, so you have to have a key to get anywhere... Once the "=" is used to pull in rows, the other parts of the query are then used to filter the results before they

Re: best practices for simulating transactions in Cassandra

2011-12-06 Thread Jérémy SEVELLEC
I dont' use exactly the same approach describe in the presentation. I use the idea to write whole data in one time in one column value to have atomicity. My application make a read before write... to verify the state of the last transactionlog. If there is data in my "transactionlog" column, it' b

Is this a limitation of CQL?

2011-12-06 Thread Peter Lin
I was doing some testing with CQL and noticed something. I'm guessing it's probably user error on my part, but just in case it isn't. If I execute a query like this, I get the following error "Caused by: InvalidRequestException(why:No indexed columns present in by-columns clause with "equals" oper

cqlsh not returning the column name of the first column when reversed

2011-12-06 Thread Konstantin Naryshkin
I am running Cassandra 1.0.0. I am using cqlsh for inspecting my data (very useful tool, thank you whoever wrote it). I notice that when I query for the FIRST N REVERSED column, it is omitting the column name on the first column. For example, cqlsh> SELECT FIRST 1 REVERSED * FROM netflow_raw; '{"bo

Re: best practices for simulating transactions in Cassandra

2011-12-06 Thread John Laban
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 data to be replayed (the "after" data). And then later, if you find that the transaction didn't complete, you j

Upgrade from 0.6 to 1.0

2011-12-06 Thread Jehan Bing
Hi, I've seen recent posts saying it was possible to upgrade directly from 0.6 to 1.0. But how? I ran "nodetool drain" on all my nodes and shut them down. However, there is not config-convert tool anymore. Since I basically using the default config, is it important? Or is it OK to just use t

Re: OutOfMemory Exception during bootstrap

2011-12-06 Thread Harald Falzberger
You are right Samal, configuring cassandra-env.sh a little bit and let it calculate heap size solved the problem! thank you! On Mon, Dec 5, 2011 at 11:23, Harald Falzberger wrote: > I don't think that this is the problem because I'm testing on a > supercomputer with 16T RAM. > > Is it possible, t

Re: AssertionError in hintedhandoff - 1.0.5

2011-12-06 Thread Ramesh Natarajan
https://issues.apache.org/jira/browse/CASSANDRA-3579 thanks Ramesh On Tue, Dec 6, 2011 at 2:16 AM, Sylvain Lebresne wrote: > Do you mind opening a ticket on > https://issues.apache.org/jira/browse/CASSANDRA ? > > Thanks > > -- > Sylvain > > On Tue, Dec 6, 2011 at 12:52 AM, Ramesh Natarajan wro

Re: best practices for simulating transactions in Cassandra

2011-12-06 Thread Jérémy SEVELLEC
Hi John, I had exactly the same reflexions. I'm using zookeeper and cage to lock et isolate. but how to rollback? It's impossible so try replay! the idea is explained in this presentation http://www.slideshare.net/mattdennis/cassandra-data-modeling (starting from slide 24) - insert your whole

Re: Second Cassandra users survey

2011-12-06 Thread Matthias Pfau
It took some time to gather our requirements and to check what are our most important needs. However, here they are: * Column position range queries: We would like to access columns not by their name, but by their position in the row. Example: row("A":v1, "B":v2, "C":v3, "D":v4); ; ordered by

Re: CQL Install for 0.8.X?

2011-12-06 Thread Joe Stein
Thanks Eric! On Mon, Dec 5, 2011 at 10:38 PM, Eric Evans wrote: > On Mon, Dec 5, 2011 at 1:40 PM, Joe Stein wrote: > > Hey, trying to grab cqlsh for a 0.8.6 cluster but all the online docs I > am > > finding are pointing to http://www.apache.org/dist/cassandra/drivers/pyor > > say it moved to t

Cassandra not suitable?

2011-12-06 Thread Patrik Modesto
Hi, I'm quite desperate about Cassandra's performance in our production cluster. We have 8 real-HW nodes, 32core CPU, 32GB memory, 4 disks in raid10, cassandra 0.8.8, RF=3 and Hadoop. We four keyspaces, one is the large one, it has 2 CFs, one is kind of index, the other holds data. There are about

Re: Re: Re: Cassandra DataModeling recommendations

2011-12-06 Thread pcohen
Thanks to both of you for these very useful and interesting links/proposals. Best Regards Hi Thanks for the answer, as I read the book on Cassandra, I was not aware at that time on Composite Key which I recently discovered.   Composite Type's are us

Re: AssertionError in hintedhandoff - 1.0.5

2011-12-06 Thread Sylvain Lebresne
Do you mind opening a ticket on https://issues.apache.org/jira/browse/CASSANDRA ? Thanks -- Sylvain On Tue, Dec 6, 2011 at 12:52 AM, Ramesh Natarajan wrote: > Hi, > >  We are running a 8 node cassandra cluster running cassandra 1.0.5. > All our CF use leveled compaction.  We ran a test where we