Re: colum family

2009-11-18 Thread Jonathan Ellis
Not yet. On Wed, Nov 18, 2009 at 5:04 AM, Gatos ega...@gmail.com wrote: Is it possible create column families not from the configuration file?

Re: admin console ?

2009-11-18 Thread Jonathan Ellis
Cassandra takes advantage of the JMX standard to expose its internals. You can access these via JConsole and lots of other tools. We've also wrapped some of the most common in bin/nodeprobe. For thrift queries there is bin/cassandra-cli and a web tool in contrib/cassandra_browser. On Wed, Nov

Re: admin console ?

2009-11-18 Thread Matthias Wessendorf
Thx, in 0.4.2 I don't see the contrib/cassandra_browser -Matthias On Wed, Nov 18, 2009 at 6:40 PM, Jonathan Ellis jbel...@gmail.com wrote: Cassandra takes advantage of the JMX standard to expose its internals.  You can access these via JConsole and lots of other tools. We've also wrapped

Re: admin console ?

2009-11-18 Thread Igor Katkov
As a side question, Is there a console-based (TTY) JConsole alternative? Perhaps a web GUI proxy? On Wed, Nov 18, 2009 at 12:40 PM, Jonathan Ellis jbel...@gmail.com wrote: Cassandra takes advantage of the JMX standard to expose its internals. You can access these via JConsole and lots of

Re: admin console ?

2009-11-18 Thread Jonathan Ellis
That is new in trunk. On Wed, Nov 18, 2009 at 11:45 AM, Matthias Wessendorf mat...@apache.org wrote: Thx, in 0.4.2 I don't see the contrib/cassandra_browser -Matthias On Wed, Nov 18, 2009 at 6:40 PM, Jonathan Ellis jbel...@gmail.com wrote: Cassandra takes advantage of the JMX standard to

Re: admin console ?

2009-11-18 Thread Matthias Wessendorf
I saw it. thx will try that and mod_py thx, m On Wed, Nov 18, 2009 at 6:47 PM, Jonathan Ellis jbel...@gmail.com wrote: That is new in trunk. On Wed, Nov 18, 2009 at 11:45 AM, Matthias Wessendorf mat...@apache.org wrote: Thx, in 0.4.2 I don't see the contrib/cassandra_browser -Matthias

Re: admin console ?

2009-11-18 Thread Igor Katkov
I suppose it will Cassandra tailored solution, have you ever stumbled upon something decent but general purpose JMX text JMX client? On Wed, Nov 18, 2009 at 12:52 PM, Jonathan Ellis jbel...@gmail.com wrote: Michael Greene is working on something web-based:

Cassandra backup and restore procedures

2009-11-18 Thread Jon Graham
Hello Everyone, Is there a recommended backup/restore procedure to be able to recover a failed node? How does Cassandra keep track of a node's identity? Should a replacement node keep the same IP address/DNS name as the original node? Does a node still receive data while a nodeprobe snapshot

Re: admin console ?

2009-11-18 Thread Paul Brown
There is the SUN JMX HtmlAdaptor that you can add to the mix; it exposes a minimal HTML console via HTTP. It used to be packed with the SUN JMX RI, and then I think it ended up in the OpenDMK (http://bit.ly/hqLf0). In any case, they're packaged under Apache-incompatible terms (GPL2/CDDL), so

Re: Cassandra backup and restore procedures

2009-11-18 Thread Jonathan Ellis
On Wed, Nov 18, 2009 at 12:05 PM, Jon Graham sjclou...@gmail.com wrote: Hello Everyone, Is there a recommended backup/restore procedure to be able to recover a failed node? Until tickets 193 and 520 are done, the easiest thing is to copy all the sstables from the other nodes that have

Re: admin console ?

2009-11-18 Thread Jonathan Ellis
Paul Querna pointed out yesterday that the CDDL is compatible with the Apache license, with some limitations: http://www.apache.org/legal/3party.html#category-b On Wed, Nov 18, 2009 at 12:20 PM, Paul Brown paulrbr...@gmail.com wrote: There is the SUN JMX HtmlAdaptor that you can add to the mix;

Re: Cassandra backup and restore procedures

2009-11-18 Thread Ramzi Rabah
Hey Jonathan, why should a replacement node keep the same IP address/DNS name as the original node? Wouldn't having the same token as the node that went down be sufficient (provided that you did the steps above of copying the data from the 2 neighboring nodes)? On Wed, Nov 18, 2009 at 10:30 AM,

Re: Cassandra backup and restore procedures

2009-11-18 Thread Jonathan Ellis
Tokens can change, so IP is used for node identification, e.g. for hinted handoff. On Wed, Nov 18, 2009 at 1:00 PM, Ramzi Rabah rra...@playdom.com wrote: Hey Jonathan, why should a replacement node keep the same IP address/DNS name as the original node? Wouldn't having the same token as the

Re: java.lang.OutOfMemoryError: unable to create new native thread

2009-11-18 Thread mobiledreamers
yes fedora core 11 any ideas on how to alleviate this issue the conf params are really low too! MemtableSizeInMB32/MemtableSizeInMB !-- ~ The maximum number of columns in millions to store in memory per ~ ColumnFamily before flushing to disk. This is also a per-memtable ~ setting.

Re: Cassandra backup and restore procedures

2009-11-18 Thread Jon Graham
Hello Jonathan, Is the system table information contained in the system/Location* files? How do I know which nodes hold the replicated copies when using ordered preserving partitioning? Are replicas always stored in neighboring nodes? Are the left (before) and right (after) nodes you mentioned

error when doing nodeprobe flush

2009-11-18 Thread kevin
i get this error on cassandra when i do nodeprobe flush. nodeprobe -host x.x.x.x flush 11:36:53,008 ERROR DebuggableThreadPoolExecutor:120 - Error in executor futuretask java.util.concurrent.ExecutionException: java.lang.AssertionError at

Re: Cassandra backup and restore procedures

2009-11-18 Thread Simon Smith
I'm sorry if this was covered before, but if you lose a node and cannot bring it (or a replacement) back with the same IP address or DNS name, is your only option to restart the entire cluster? E.g. if I have nodes 1, 2, and 3 with replication factor 3, and then I lose node 3, is it possible to

Re: error when doing nodeprobe flush

2009-11-18 Thread Jonathan Ellis
This happens when you flush and there was no data in the binarymemtable. It's harmless (everything that does have data, still gets flushed). Since you're running from svn you can update to the latest 0.4 code though which fixes the exception. On Wed, Nov 18, 2009 at 1:43 PM, kevin

Re: Cassandra backup and restore procedures

2009-11-18 Thread Jonathan Ellis
No, bootstrap is currently only for adding new nodes, not replacing dead ones. On Wed, Nov 18, 2009 at 1:47 PM, Simon Smith simongsm...@gmail.com wrote: I'm sorry if this was covered before, but if you lose a node and cannot bring it (or a replacement) back with the same IP address or DNS

Re: error when doing nodeprobe flush

2009-11-18 Thread kevin
On Wed, Nov 18, 2009 at 11:49 AM, Jonathan Ellis jbel...@gmail.com wrote: This happens when you flush and there was no data in the binarymemtable. It's harmless (everything that does have data, still gets flushed). thanks for the info. Since you're running from svn you can update to the

Re: error when doing nodeprobe flush

2009-11-18 Thread Jonathan Ellis
all the 0.4 code is compatible in every sense. On Wed, Nov 18, 2009 at 1:55 PM, kevin kevincastigli...@gmail.com wrote: On Wed, Nov 18, 2009 at 11:49 AM, Jonathan Ellis jbel...@gmail.com wrote: This happens when you flush and there was no data in the binarymemtable.  It's harmless (everything

Re: admin console ?

2009-11-18 Thread Jeff Hammerbacher
You could try exposing JMX metrics via a REST interface using http://code.google.com/p/polarrose-jmx-rest-bridge, at which point curl becomes your client. On Wed, Nov 18, 2009 at 10:35 AM, Jonathan Ellis jbel...@gmail.com wrote: Paul Querna pointed out yesterday that the CDDL is compatible with

Java Cassandra client connecting to a pool of servers?

2009-11-18 Thread Freeman, Tim
I'd like to be able to say that a cluster of Cassandra servers keeps working even if one of the nodes goes down. This would require the clients to connect to a different node if the one that it's using goes down. Is there code on the client side to do this already? There's a Cassandra.Client

date range queries

2009-11-18 Thread Adam Fisk
First off, very impressive project -- thanks for everyone's hard work! I'm wondering how I would do date range queries in Cassandra, say for all messages for a given user in the last week. Can someone provide an example? Thanks so much. -Adam -- Adam Fisk http://www.littleshoot.org |

Re: Java Cassandra client connecting to a pool of servers?

2009-11-18 Thread elsif
We are using the open source tcp balancer from http://www.inlab.de/balance.html without any issues so far. Freeman, Tim wrote: I'd like to be able to say that a cluster of Cassandra servers keeps working even if one of the nodes goes down. This would require the clients to connect to a

ERROR [pool-1-thread-373] 2009-11-18 18:04:06,431 StorageProxy.java (line 179) error writing key camaras

2009-11-18 Thread mobiledreamers
*Got a new error from cassandra Operation timed out! Please let me know if this a normal error and how to fix this thanks java.util.concurrent.TimeoutException: Operation timed out - received only 0 responses from .* at

Re: date range queries

2009-11-18 Thread Jonathan Ellis
The easiest is to store the messages in a row with timeuuid column names. Then you can just use get_slice in either forward or reverse order. On Wed, Nov 18, 2009 at 6:07 PM, Adam Fisk a...@littleshoot.org wrote: First off, very impressive project -- thanks for everyone's hard work! I'm

Re: Java Cassandra client connecting to a pool of servers?

2009-11-18 Thread Santal Li
We are using DNS name to access Cassandra pool. such as: cassandra.mydomain.com, it point to the server list of Cassandra Node , when client query the DNS name, it will result a random IP in the list to client. if some node was down, the DNS server can automatic remove it's IP from IP list. There

java.util.concurrent.TimeoutException: Operation timed out - received only 0 responses from .

2009-11-18 Thread mobiledreamers
Can you plase tell what this error is ? ERROR - error writing key ruske *java.util.concurrent.TimeoutException: Operation timed out - received only 0 responses from .* at org.apache.cassandra.service.QuorumResponseHandler.get(QuorumResponseHandler.java:88) at