Re: Value-Added Services Layer

2011-10-27 Thread Sasha Dolgy
I don't have grand visions of having fat clients connect directly to Cassandra to read/write data. Too much risk in my opinion. On Tue, Oct 25, 2011 at 4:50 PM, Edward Capriolo edlinuxg...@gmail.com wrote: If you do not think restful API's are useful, try to make a fat client that speaks a

Re: Fail to upgrade to 1.0.0 from 0.8.5

2011-10-27 Thread Sylvain Lebresne
Do you mind opening a bug report on https://issues.apache.org/jira/browse/CASSANDRA? -- Sylvain On Thu, Oct 27, 2011 at 12:35 AM, Zhong Li z...@voxeo.com wrote: Hi, I am trying to upgrade our test servers to 1.0.0 from 0.8.5 and got exceptions when restart. INFO 22:25:37,727 Opening

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?

Counter Experience (Performance)?

2011-10-27 Thread Joe Stein
Hey folks, I am interested in what others have seen in regards to their experience in the amount of depth and width (CF, Rows Columns) that they can/do write per batch and simultaneously and what is the inflection point where performance degrades. I have been expanding my use of counters and am

Re: Fail to upgrade to 1.0.0 from 0.8.5

2011-10-27 Thread Zhong Li
Done. https://issues.apache.org/jira/browse/CASSANDRA-3407 On Oct 27, 2011, at 3:40 AM, Sylvain Lebresne wrote: Do you mind opening a bug report on https://issues.apache.org/jira/browse/CASSANDRA? -- Sylvain On Thu, Oct 27, 2011 at 12:35 AM, Zhong Li z...@voxeo.com wrote: Hi, I

2 node cluster, 1 node down, overall failure

2011-10-27 Thread RobinUs2
I currently run a 2-node cluster with version cassandra 1.0 (stable). With replication factor 2 on the keyspace which I'm testing. When I shutdown node B, it's impossible to connect with thrift to node A. The gossiper on node A says that node B is down. My keyspace: create keyspace Testing with

Re: Counter Experience (Performance)?

2011-10-27 Thread Jake Luciani
What's your bottleneck? http://spyced.blogspot.com/2010/01/linux-performance-basics.html On Thu, Oct 27, 2011 at 9:37 AM, Joe Stein crypt...@gmail.com wrote: Hey folks, I am interested in what others have seen in regards to their experience in the amount of depth and width (CF, Rows Columns)

Re: 2 node cluster, 1 node down, overall failure

2011-10-27 Thread Jake Luciani
You are unable to connect? or you are getting an UnavailableException? On Thu, Oct 27, 2011 at 11:14 AM, RobinUs2 ro...@us2.nl wrote: I currently run a 2-node cluster with version cassandra 1.0 (stable). With replication factor 2 on the keyspace which I'm testing. When I shutdown node B,

Re: 2 node cluster, 1 node down, overall failure

2011-10-27 Thread RobinUs2
The error I currently see when I take down node B: Error performing get_indexed_slices on NODE A IP:9160: exception 'cassandra_UnavailableException' -- View this message in context:

Re: 2 node cluster, 1 node down, overall failure

2011-10-27 Thread Jake Luciani
What consistency level are you using? With RF=2 your only option is CL.ONE when a node is down. On Thu, Oct 27, 2011 at 11:47 AM, RobinUs2 ro...@us2.nl wrote: The error I currently see when I take down node B: Error performing get_indexed_slices on NODE A IP:9160: exception

Re: 2 node cluster, 1 node down, overall failure

2011-10-27 Thread RobinUs2
I'm reading with: cassandra_ConsistencyLevel::ANY (phpcassa lib). Is there any way to verify that all the nodes know that they are RF=2 ? -- View this message in context:

Re: 2 node cluster, 1 node down, overall failure

2011-10-27 Thread RobinUs2
Thank you very much Jake! It solved the problem. All reads and writes are working now. Have a nice day! -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/2-node-cluster-1-node-down-overall-failure-tp6936722p6936947.html Sent from the

Re: Counter Experience (Performance)?

2011-10-27 Thread Joe Stein
Thanks Jake, bottleneck is the disk I believe each write is taking 50ms, EBS probably (doing testing in ec2). I will move my testing over to our production network and run it on some nodes on some real hardware since that where it will end up. I am seeing things slow down linearly and nothing

Re: UnavailableException with 1 node down and RF=2?

2011-10-27 Thread Jonathan Ellis
Ha. On the one hand, good on you for searching the list archives for similar problems. On the other hand, after over a year it's probably worth starting a new thread. :) Standard questions: - What Cassandra version are you running? - Are there exceptions in the log for the machine still

Re: UnavailableException with 1 node down and RF=2?

2011-10-27 Thread Javier Canillas
What the problem might be is that you are setting the Consistency Level to a value bigger than 1. In such cases, Cassandra will respond you with an UnavailableException since it can't achieve the level of consistency you are asking for. Remember that, when you have RF=2, CS values as ALL and

Re: UnavailableException with 1 node down and RF=2?

2011-10-27 Thread Jonathan Ellis
(I see that you did start a new thread and solved it with Jake's help.) On Thu, Oct 27, 2011 at 11:23 AM, Jonathan Ellis jbel...@gmail.com wrote: Ha.  On the one hand, good on you for searching the list archives for similar problems.  On the other hand, after over a year it's probably worth

Monitoring question for a multi DC (active/standby) configuration

2011-10-27 Thread Anand Somani
Hi, Have a requirement to do a multi dc low latency application. This will be in an active/standby setup. So I am planning on using LOCAL_QUORUM for writes. Now if there is a hard requirement of maximum loss of data (on a dc destruction) to some minutes, - In cassandra what is the recommended

Re: super sub slice query?

2011-10-27 Thread Caleb Rackliffe
I had the same question you did, I think. Below is as far as I got with Hector… I have a column family of super-columns with long names. The columns in each super-column also have long names. I'm using Hector, and what I want to do is get the last column in each super-column, for a range of

error message

2011-10-27 Thread mike.li
Hello , can anyone tell me what's wrong with the following error: ERROR [HintedHandoff:1] 2011-10-27 19:57:09,914 AbstractCassandraDaemon.java (line 133) Fatal exception in thread Thread[HintedHandoff:1,5,main] java.lang.AssertionError at

Re: error message

2011-10-27 Thread Jonathan Ellis
https://issues.apache.org/jira/browse/CASSANDRA-3385 On Thu, Oct 27, 2011 at 1:27 PM, mike...@thomsonreuters.com wrote: Hello , can anyone tell me what’s wrong with the following error: ** ** ERROR [HintedHandoff:1] 2011-10-27 19:57:09,914 AbstractCassandraDaemon.java (line 133) Fatal

RE: error message

2011-10-27 Thread mike.li
Thank you, Johnathan. Mike Li Lead Database Engineer Thomson Reuters Phone: 314-468-8128 mike...@thomsonreuters.com www.thomsonreuters.com From: Jonathan Ellis [mailto:jbel...@gmail.com] Sent: Thursday, October 27, 2011 1:37 PM To: user@cassandra.apache.org Subject: Re: error message

compaction threshold and leveledCompaction

2011-10-27 Thread mike.li
Why these two gives different results? ./nodetool -h 172.xx.xxx.xx getcompactionthreshold Timeseries TickData Current compaction thresholds for Timeseries/TickData: min = 1, max = 2147483647 [default@Timeseries] show schema; use Timeseries; ... and min_compaction_threshold = 4 and

SimpleAuthenticator missing in Cassandra 1.0

2011-10-27 Thread RobinUs2
It seems that org.apache.cassandra.auth.SimpleAuthenticator is missing in the cassandra 1.0 binaries. Is this on purpose or did I found a bug? -- View this message in context:

Re: UnavailableException with 1 node down and RF=2?

2011-10-27 Thread R. Verlangen
Thats correct. It was a read consistency problem, not so smart of me ;-) Thank you anyway. 2011/10/27 Jonathan Ellis jbel...@gmail.com (I see that you did start a new thread and solved it with Jake's help.) On Thu, Oct 27, 2011 at 11:23 AM, Jonathan Ellis jbel...@gmail.com wrote: Ha. On

Re: SimpleAuthenticator missing in Cassandra 1.0

2011-10-27 Thread Brandon Williams
On Thu, Oct 27, 2011 at 3:25 PM, RobinUs2 ro...@us2.nl wrote: It seems that org.apache.cassandra.auth.SimpleAuthenticator is missing in the cassandra 1.0 binaries. Is this on purpose or did I found a bug? From NEWS.txt: - The SimpleAuthenticator and SimpleAuthority classes have been moved

Re: SimpleAuthenticator missing in Cassandra 1.0

2011-10-27 Thread Jonathan Ellis
https://issues.apache.org/jira/browse/CASSANDRA-2922 On Thu, Oct 27, 2011 at 3:25 PM, RobinUs2 ro...@us2.nl wrote: It seems that org.apache.cassandra.auth.SimpleAuthenticator is missing in the cassandra 1.0 binaries. Is this on purpose or did I found a bug? -- View this message in context:

Re: SimpleAuthenticator missing in Cassandra 1.0

2011-10-27 Thread RobinUs2
Oke, that makes sense, even though I couldn't find it in the first place. What would you suggest for authentication? Firewall rules that only allow from whitelist hosts? Writing a custom Authenticator? -- View this message in context:

Re: SimpleAuthenticator missing in Cassandra 1.0

2011-10-27 Thread Pete Warden
For what it's worth, here's where I ended up after digging into Cassandra security as a new user: http://petewarden.typepad.com/searchbrowser/2011/08/securing-cassandra-on-ec2.html On Thu, Oct 27, 2011 at 1:39 PM, RobinUs2 ro...@us2.nl wrote: Oke, that makes sense, even though I couldn't find

Re: SimpleAuthenticator missing in Cassandra 1.0

2011-10-27 Thread Dave Brosius
Had found the same thing, and updated: http://wiki.apache.org/cassandra/SimpleAuthenticator On 10/27/2011 04:25 PM, RobinUs2 wrote: It seems that org.apache.cassandra.auth.SimpleAuthenticator is missing in the cassandra 1.0 binaries. Is this on purpose or did I found a bug? -- View this

Loading Cassandra 0.87 column family using Java

2011-10-27 Thread Jaiswal Neetu
Hi, I am new for Cassandra and Java. Can someone guide me to load multiple columns of Cassandra column family using single statement in Cassandra-cli? Or load multiple columns using Java program? Sending sample will be great help. Thanks Neetu

Best way to search content in Cassandra

2011-10-27 Thread Jean-Nicolas Boulay Desjardins
Normally in SQL I would use % operator to get what looks like what I am searching. Example: [...] type = image/% It would give me all the rows that have a column type with image/ in it. So those would show up: image/png image/gif ... Is there anything similar with Cassandra? I am also using