PhpMyAdmin-like Cassandra Client

Hi everbody, I was wondering if there exists a Cassandra client that is a bit more friendly to people that arent as technical enthusiastic as we are? We are currently using the CLI to peek into Cassandra, but that's a bit too much to ask for my non-technical colleagues. Maybe somebody already bui

Re: Cassandra Full-Text Search?

Hi Vijay, I was planning to release the code (C++) but I never got to finish it. It's also based on an older version of Cassandra. Having said that, I'm not sure if the following has already been published on the list: http://github.com/tjake/Lucandra Best wishes, Neophytos Vijay wrote: H

Re: backing up data from cassandra

You can take a snapshot and either leave it in place indefinitely or throw it into your existing backup ecosystem. That's your best option for backup no matter which kind of partitioner you're using. -Jonathan On Mon, Oct 5, 2009 at 12:52 AM, Edmond Lau wrote: > For folks who are using or consi

Cassandra and Oracle Coherence Comparison

Hi, What are the differences and similarities between Cassandra and oracle coherence? Thanks in advance. Sincerely, Evren

Re: Cassandra and Oracle Coherence Comparison

Briefly * Coherence is in-memory, Cassandra is persisted * Coherence has a transactional model, Cassandra is eventually consistent * Coherence has specially written adapters for different environments/languages, Cassandra supports most languages through Thrift * They both are distributed repositori

Re: backing up data from cassandra

How do you take the snapshot? What's the restore process? On Mon, Oct 5, 2009 at 5:22 AM, Jonathan Ellis wrote: > You can take a snapshot and either leave it in place indefinitely or > throw it into your existing backup ecosystem.  That's your best option > for backup no matter which kind of par

Re: backing up data from cassandra

bin/nodeprobe snapshot to restore, move the snapshot sstables from the snapshot location to the live data location (e.g. with dsh). note that the 0.4 branch, which will become 0.4.1, automatically flushes each columnfamily when you ask for a snapshot of the table, so you don't have to do that man

Re: PhpMyAdmin-like Cassandra Client

Johannes, I had a similar concern and worked on a small browser, on which you can currently browse and open columns (for our own usage, it has some features oriented to columns storing JSON data), and do some minimal updates (inserts/deletes). It is web-based, written on Python. Current code and d

[VOTE] Project Logo

Alrighty then. Time to vote on a project logo. The ballot is made up of all the finalist logos with a rating of either 4 or 5 stars[0], and "None of the Above" (just in case you want to express your disgust with one or more of the choices). To vote, reply to the list and fill in the boxes of the

Re: [VOTE] Project Logo

On Mon, 2009-10-05 at 10:12 -0500, Eric Evans wrote: > ~~{ Ballot }~~ > [ 1] 2http://99designs.com/contests/28940/entries/002 > [ 2] 30 http://99designs.com/contests/28940/entries/030 > [ 3] 32 http://99designs.com/contests/28940/en

Re: [VOTE] Project Logo

>  [ 4] 2    http://99designs.com/contests/28940/entries/002 >  [10] 30   http://99designs.com/contests/28940/entries/030 >  [ 3] 32   http://99designs.com/contests/28940/entries/032 >  [11] 33   http://99designs.com/contests/28940/entries/033 >  [ 8] 90   http://99designs.com/contests/28940/entrie

Re: [VOTE] Project Logo

~~{ Ballot }~~ [ 4 ] 2http://99designs.com/contests/28940/entries/002 [ 3 ] 30 http://99designs.com/contests/28940/entries/030 [ 11 ] 32 http://99designs.com/contests/28940/entries/032 [ 10 ] 33 http://99designs.com/contests/

Re: [VOTE] Project Logo

> ~~{ Ballot }~~ >  [10] 2    http://99designs.com/contests/28940/entries/002 >  [ 9] 30   http://99designs.com/contests/28940/entries/030 >  [11] 32   http://99designs.com/contests/28940/entries/032 >  [12] 33   http://99designs.com/contests/

Re: Connection Pooling

As Jonathan Ellis points out one might use common-pool If you also use Spring it makes it very easy to configure, so there are no need to code it yourself. Here is an example Where "cassandraClientTarget" is bean id of your Cassandra client class,

Re: backing up data from cassandra

I assume the server also needs to be stopped while your are swapping files, but what about if you have a cluster of several servers and need to restore. Is the process to shutdown all the servers, move the files and restart? Or can you you do it one at a time. (I assume one at a time might mean

Re: backing up data from cassandra

On Mon, Oct 5, 2009 at 11:10 AM, Anthony Molinaro wrote: > I assume the server also needs to be stopped while your are swapping > files, but what about if you have a cluster of several servers and > need to restore.  Is the process to shutdown all the servers, move > the files and restart? Or can

Re: backing up data from cassandra

Isn't the question about how you back up a cassandra cluster, not a single node? Can you snapshot the various nodes at different times or do they need to be synchronized? Is there a minimal set of nodes that are sufficient to back up? Thorsten Jonathan Ellis wrote: bin/nodeprobe snapshot to

Re: [VOTE] Project Logo

Oops, I had two at #8. Fixed: >>  [ 8] 90   http://99designs.com/contests/28940/entries/090 >>  [ 9] 175  http://99designs.com/contests/28940/entries/175

Re: backing up data from cassandra

On Mon, Oct 5, 2009 at 11:23 AM, Thorsten von Eicken wrote: > Isn't the question about how you back up a cassandra cluster, not a > single node? Sure, but the generalization is straightforward. :) > Can you snapshot the various nodes at different times or do > they need to be synchronized? The

Re: [VOTE] Project Logo

~~{ Ballot }~~ [2 ] 2http://99designs.com/contests/28940/entries/002 [6 ] 30 http://99designs.com/contests/28940/entries/030 [12] 32 http://99designs.com/contests/28940/entries/032 [5 ] 33 http://99designs.com/contests/28940/e

Re: [VOTE] Project Logo

~~{ Ballot }~~ [ 11 ] 2http://99designs.com/contests/28940/entries/002 [ 8 ] 30 http://99designs.com/contests/28940/entries/030 [ 7 ] 32 http://99designs.com/contests/28940/entries/032 [ 6 ] 33 http://99designs.com/contests/28940

Re: [VOTE] Project Logo

> ~~{ Ballot }~~ > [ 3] 2http://99designs.com/contests/28940/entries/002 > [ 9] 30 http://99designs.com/contests/28940/entries/030 > [ 4] 32 http://99designs.com/contests/28940/entries/032 > [ 6] 33 http://99designs.com/contests/

Re: Storage proxy write latency is too high

In case anyone is following this, here is an update: I was able to narrow it down to Cassandra-Cassandra link. Storage proxy latency depends on size of the key. The larger amount of data (per key) is transfered the larger latency is. No surprise here. Client connects to a demons "A" and sends key-

Re: Storage proxy write latency is too high

so for a 200KB value you are seeing >200ms of latency in MessagingService? How much for a 1KB value? -Jonathan On Mon, Oct 5, 2009 at 1:46 PM, Igor Katkov wrote: > In case anyone is following this, here is an update: > > I was able to narrow it down to Cassandra-Cassandra link. Storage proxy >

Re: [VOTE] Project Logo

Here's my ballot...since I'm in Chicago, you should know that it counts twice, three times if my neighbor has died (I'll check on that and get back to you...) ~~{ Ballot }~~ [ 12 ] 2http://99designs.com/contests/28940/entries/002 [

Re: Storage proxy write latency is too high

measured via JMX console i.e. does not include client-cassandra-client latency 20 client threads 176975b value StorageProxy.WriteLatency ~660ms 10 client threads 176975b value StorageProxy.WriteLatency ~350ms 05 client threads 176975b value StorageProxy.WriteLatency ~156ms 20 client threads 4978b

Re: [VOTE] Project Logo

+1 -- Tim Estes CEO Digital Reasoning Systems Nashville, TN On Oct 5, 2009, at 3:11 PM, Jonathan Mischo wrote: Here's my ballot...since I'm in Chicago, you should know that it counts twice, three times if my neighbor has died (I'll check on that and get back to you...)

Re: Storage proxy write latency is too high

On Mon, Oct 5, 2009 at 2:17 PM, Igor Katkov wrote: > measured via JMX console i.e. does not include client-cassandra-client > latency > > 20 client threads 176975b value StorageProxy.WriteLatency ~660ms > 10 client threads 176975b value StorageProxy.WriteLatency ~350ms > 05 client threads 176975b

Re: [VOTE] Project Logo

On Mon, 2009-10-05 at 15:18 -0400, Tim Estes wrote: > +1 Are you indicating that you want to vote with rankings identical to Jonathan, or that you agree that his vote should count 2 or more times, or...? > On Oct 5, 2009, at 3:11 PM, Jonathan Mischo wrote: > > > Here's my ballot...since I'm in C

Re: [VOTE] Project Logo

I recognize my esteemed colleague in the Chicago delegation and echo his truths before putting forth my own ballot: ~~{ Ballot }~~ [ 10 ] 2    http://99designs.com/contests/28940/entries/002 [ 9 ] 30   http://99designs.com/contests/28940/en

Re: [VOTE] Project Logo

> > [ 12 ] 2http://99designs.com/contests/28940/entries/002 > [ 11] 30 http://99designs.com/contests/28940/entries/030 > [ 8 ] 32 http://99designs.com/contests/28940/entries/032 > [ 1 ] 33 http://99designs.com/contests/28940/entries/033 > [ 5 ] 90 http://99designs.com/contests/289

Re: [VOTE] Project Logo

Eric Evans wrote: On Mon, 2009-10-05 at 10:12 -0500, Eric Evans wrote: ~~{ Ballot }~~ [ ] 2http://99designs.com/contests/28940/entries/002 [ ] 30 http://99designs.com/contests/28940/entries/030 [ 1] 32 http://99designs.com/cont

Re: [VOTE] Project Logo

On Mon, Oct 5, 2009 at 5:12 PM, Eric Evans wrote: > > Alrighty then. Time to vote on a project logo. > > The ballot is made up of all the finalist logos with a rating of either > 4 or 5 stars[0], and "None of the Above" (just in case you want to > express your disgust with one or more of the choic

Re: [VOTE] Project Logo

+1 on the Chicago comment. :) Hope to rank the logos later. Many look quite good. If #369 isn't picked, I'd like to get permission to use it as a program logo for a Gov't effort that is making use of Cassandra. :) -- Tim Estes CEO Digital Reasoning Systems Nashville, TN On Oct 5, 2009, at

Maximum Value Size

I have been working with Cassandra for a little over a week now, and I've got a quick question. I am trying to figure out if there is a maximum value size that could cause performance degradation. Is there any reason that storing or returning a value of 20MB or so may be problematic (key and name

Re: Maximum Value Size

You should definitely upgrade to 0.4, it might mean using raw Thrift but we have at least one person doing that in Perl. (Is Net::Cassandra much more than a thin wrapper anyway?) Cassandra isn't optimized for blob support (see https://issues.apache.org/jira/browse/CASSANDRA-265 for one proposal t

Error in the latest Trunk - RackAware Statergy

Hi, I am getting the following error http://pastebin.com/m6a716383 ERROR [pool-1-thread-11] 2009-10-05 21:32:03,646 StorageProxy.java (line 179) error writing key c8f3c84c-6253-46fc-b1da-f00a871904f1 java.lang.UnsupportedOperationException: Rack-aware bootstrapping not supported at org.apach

Re: [VOTE] Project Logo

+1 Regards, On Mon, Oct 5, 2009 at 10:51 AM, Igor Katkov wrote: > ~~{ Ballot }~~ > [ 11 ] 2http://99designs.com/contests/28940/entries/002 > [ 8 ] 30 http://99designs.com/contests/28940/entries/030 > [ 7 ] 32 http://99designs

RE: Maximum Value Size

Thanks for the quick and helpful reply. We will be looking for a way to use 0.4. Net::Cassandra for the most part appears to be just a thin wrapper. We may explore using raw Thrift, but there is concern over connection persistence and how the current modules handle that. We haven't looked int

Re: [VOTE] Project Logo

On Mon, 2009-10-05 at 15:06 -0700, Vijay wrote: > +1 > Regards, > What are you +1ing here? The entire set as ranked by Igor? > On Mon, Oct 5, 2009 at 10:51 AM, Igor Katkov > wrote: > ~~{ Ballot }~~ > [ 11 ] 2http://99d

Re: Error in the latest Trunk - RackAware Statergy

On Mon, Oct 5, 2009 at 5:02 PM, Vijay wrote: > ERROR [pool-1-thread-11] 2009-10-05 21:32:03,646 StorageProxy.java (line > 179) error writing key c8f3c84c-6253-46fc-b1da-f00a871904f1 > java.lang.UnsupportedOperationException: Rack-aware bootstrapping not > supported pretty self-explanatory I would

Re: [VOTE] Project Logo

~~{ Ballot }~~ [3] 2 http://99designs.com/contests/28940/entries/002 [4] 30 http://99designs.com/contests/28940/entries/030 [9] 32 http://99designs.com/contests/28940/entries/032 [8] 33 http://99designs.com/contests/28940/entries/033 [5] 90 ht

Cassandra Fatal Exceptions

Hi, I updated from trunk two days ago, but ever since I've been receiving a series of Fatal Exceptions. My logs show that about an hour after starting Cassandra I receive a RejectedExecutionException and two Assertion exceptions. From that point on, the log files just fill up with repeated TimeoutE

Re: Cassandra Fatal Exceptions

looks like you ran into a regression. that's the risk you run on trunk. :) Could you open a ticket for this on https://issues.apache.org/jira/browse/CASSANDRA ? -Jonathan On Mon, Oct 5, 2009 at 5:32 PM, Chris Were wrote: > Hi, > I updated from trunk two days ago, but ever since I've been recei

Re: Error in the latest Trunk - RackAware Statergy

thanks Jonathan, I thought it was a typo or error or something which was unexpected :)... Ok i have the requirement for rack awareness i will write something and send the code across. if there is something which i need to know i will sync up @ IRC... (hopefully it will starts working for me).

Re: Cassandra Fatal Exceptions

Dan beat you to it: http://issues.apache.org/jira/browse/CASSANDRA-471 On Mon, Oct 5, 2009 at 5:39 PM, Jonathan Ellis wrote: > looks like you ran into a regression.  that's the risk you run on trunk. :) > > Could you open a ticket for this on > https://issues.apache.org/jira/browse/CASSANDRA ? >

Re: Error in the latest Trunk - RackAware Statergy

Sandeep, any tips for bootstrap + rack aware that Vijay should know? On Mon, Oct 5, 2009 at 5:39 PM, Vijay wrote: > thanks Jonathan, > I thought it was a typo or  error or something which was unexpected :)... Ok > i have the requirement for rack awareness i will write something and send > the cod

Re: Error in the latest Trunk - RackAware Statergy

Jonathan and Sandeep, seems like something which is similar to that of the PropertyFileEndPointSnitch.java but instead of getting the IP from the Configuration file i will compare it with the real ip of the servers does it sound ok? Regards, On Mon, Oct 5, 2009 at 3:42 PM, Jonathan Ellis

Re: Cassandra Fatal Exceptions

Thanks -- I'll head back to 0.4.0 then :) Cheers. On Tue, Oct 6, 2009 at 9:11 AM, Jonathan Ellis wrote: > Dan beat you to it: http://issues.apache.org/jira/browse/CASSANDRA-471 > > On Mon, Oct 5, 2009 at 5:39 PM, Jonathan Ellis wrote: > > looks like you ran into a regression. that's the risk y

Re: [VOTE] Project Logo

[1] http://99designs.com/contests/28940/entries/033 On Mon, Oct 5, 2009 at 8:12 AM, Eric Evans wrote: > > Alrighty then. Time to vote on a project logo. > > The ballot is made up of all the finalist logos with a rating of either > 4 or 5 stars[0]

Re: [VOTE] Project Logo

~~{ Ballot }~~ [6] 2 http://99designs.com/contests/28940/entries/002 [4] 30 http://99designs.com/contests/28940/entries/030 [5] 32 http://99designs.com/contests/28940/entries/032 [1] 33 http://99designs.com/contests/28940/entries/033 [2] 90 ht

Re: [VOTE] Project Logo

On Mon, 2009-10-05 at 21:49 -0300, Nico Steppat wrote: > ~~{ Ballot }~~ > [6] 2 http://99designs.com/contests/28940/entries/002 > [4] 30 http://99designs.com/contests/28940/entries/030 > [5] 32 http://99designs.com/contests/28940/entries/032 >

Re: [VOTE] Project Logo

My votes... > > > ~~{ Ballot }~~ > [ 5 ] 2http://99designs.com/contests/28940/entries/002 > [ 7 ] 30 http://99designs.com/contests/28940/entries/030 > [ 8 ] 32 http://99designs.com/contests/28940/entries/032 > [ 2 ] 33 http://99

Re: [VOTE] Project Logo

My vote. > ~~{ Ballot }~~ > [ ] 2http://99designs.com/contests/28940/entries/002 > [ ] 30 http://99designs.com/contests/28940/entries/030 > [ ] 32 http://99designs.com/contests/28940/entries/032 > [2 ] 33 http://99designs.com

Re: [VOTE] Project Logo

Votes below. Eric Evans wrote: Alrighty then. Time to vote on a project logo. The ballot is made up of all the finalist logos with a rating of either 4 or 5 stars[0], and "None of the Above" (just in case you want to express your disgust with one or more of the choices). To vote, reply to the

Re: [VOTE] Project Logo

Fingers crossed for no eyes... ~~{ Ballot }~~ [ ] 2http://99designs.com/contests/28940/entries/002 [ ] 30 http://99designs.com/contests/28940/entries/030 [ ] 32 http://99designs.com/contests/28940/entries/032 [1 ] 33 http://99des