Effective ownership on both nodes 0 %

2012-06-11 Thread Prakrati Agrawal
Dear all I have a Cassandra cluster with 2 nodes. I was trying to increase the replication factor of keyspace in Cassandra to 2. I did the following steps: UPDATE KEYSPACE demo WITH strategy_options = {DC1:2,DC2:2}; on both the nodes Then I ran the nodetool repair on both the nodes Then I ran my

Re: Cassandra Supports multi tenant or not

2012-06-11 Thread Toru Inoko
please refer following url, if you'd like to know about multi-tenancy with Cassandra. http://wiki.apache.org/cassandra/MultiTenant And, Hector supports multi tenant datamodel on cassandra. https://github.com/hector-client/hector/wiki/Virtual-Keyspaces Recently, I have disscussed about multi

Re: Composite columns: CLI or CQL?

2012-06-11 Thread Sylvain Lebresne
More details would help, like at least the query you're using to do the insertion and that fails, as well as the exact error message. -- Sylvain On Mon, Jun 11, 2012 at 2:42 AM, Georg Köster georg.koes...@gmail.com wrote: Dear all, I'm really excited about Cassandra's peer-to-peer

Why cassandra nodes ownership is 0.00%

2012-06-11 Thread Prakrati Agrawal
Dear all I have a Cassandra cluster with 2 nodes. I am using NetworkTopologyStrategy. I was trying to increase the replication factor of keyspace in Cassandra to 2. I did the following steps: UPDATE KEYSPACE demo WITH strategy_options = {DC1:2,DC2:2}; on both the nodes Then I ran the nodetool

Re: Composite columns: CLI or CQL?

2012-06-11 Thread Georg Köster
I used Pelops and now I tried Astyanax and I get no details on the value that cassandra is analyzing - only the composite key is in the error message. If I insert a String instead of the Long (Long.toString(...) and Long.valueOf()) my tests work but my column size is larger of course. I can use it

Re: Commit log durability per column family

2012-06-11 Thread aaron morton
It's not possible and it's not possible to make the change. A write to the same key in multiple CF's is written as a single log record. So it's not possible for difference CF's to use different strategies. The closest thing is the durable_writes KS property which turns off the commit log

Re: Effective ownership on both nodes 0 %

2012-06-11 Thread aaron morton
Also when I run the command ./nodetool –h ip_address ring I found that both nodes ownership is 0 %. Please tell me how should I fix that. It would be a lot easier to answer you question if you showed the output from nodetool ring. UPDATE KEYSPACE demo WITH strategy_options =

RE: how to configure cassandra as multi tenant

2012-06-11 Thread MOHD ARSHAD SALEEM
Hi Aaron, Can you send me some particular link related to multi tenant research Regards Arshad From: aaron morton [aa...@thelastpickle.com] Sent: Thursday, June 07, 2012 3:34 PM To: user@cassandra.apache.org Subject: Re: how to configure cassandra as multi tenant

Re: how to configure cassandra as multi tenant

2012-06-11 Thread Sasha Dolgy
Google, man. http://wiki.apache.org/cassandra/MultiTenant http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/about-multitenant-datamodel-td7575966.html

RE: how to configure cassandra as multi tenant

2012-06-11 Thread MOHD ARSHAD SALEEM
Hi Sasha, Thanks for your reply. but what you send this is just to create keyspace manually using command prompt.how to create keyspace(Multi tenant) automatically using cassandra API's. Regards Arshad From: Sasha Dolgy [sdo...@gmail.com] Sent: Monday, June

Re: Dead node still being pinged

2012-06-11 Thread Samuel CARRIERE
Well, I don't see anything special in the logs. Remove token seems to have done its job : accorging to the logs, old stored hints have been deleted. If I were you, I would connect (through JMX, with jconsole) to one of the nodes that is sending messages to an old node, and would have a look at

Hector code not running when replication factor set to 2

2012-06-11 Thread Prakrati Agrawal
Dear all I had a 2 node cluster with replication factor set to 1. Then I changed the replication factor to 2 and brought down one node so that only 1 node was up and running. Then I ran my Hector code on the running node. But it gave me Unavailable Exception. I also had a Thrift code which ran

Re: how to configure cassandra as multi tenant

2012-06-11 Thread Sasha Dolgy
Arshad, I used google with the following query: apache cassandra multitenant Suggest you do the same? As was mentioned earlier, there has been a lot of discussion about this topic for the past year -- especially on this mailing list. If you want to use Thrift or, to make your life easier,

RE: how to configure cassandra as multi tenant

2012-06-11 Thread MOHD ARSHAD SALEEM
Hi Sasha, one more thing by using API's how to create keyspace and column family dynamically. write now i have to create first through the command prompt then that keyspace and column family used in API's. Regards Arshad From: Sasha Dolgy [sdo...@gmail.com]

RE: Setting column to null

2012-06-11 Thread Leonid Ilyevsky
Thanks, I understand what you are telling me. Obviously deleting the column is the proper way to do this in Cassandra. What I was looking for, is some convenient wrapper on top of that which will do it for me. Here is my scenario. I have a function that takes a record to be saved in Cassandra

Re: Dead node still being pinged

2012-06-11 Thread Nicolas Lalevée
Le 11 juin 2012 à 12:12, Samuel CARRIERE a écrit : Well, I don't see anything special in the logs. Remove token seems to have done its job : accorging to the logs, old stored hints have been deleted. If I were you, I would connect (through JMX, with jconsole) to one of the nodes that

Re: [RELEASE] Apache Cassandra 1.1.1 released

2012-06-11 Thread Omid Aladini
I think the change log for 1.1.1 is missing CASSANDRA-4150 [1]. -- Omid [1] https://issues.apache.org/jira/browse/CASSANDRA-4150 On Mon, Jun 4, 2012 at 9:52 PM, Sylvain Lebresne sylv...@datastax.com wrote: The Cassandra team is pleased to announce the release of Apache Cassandra version

Re: Dead node still being pinged

2012-06-11 Thread Nicolas Lalevée
finally, thanks to the groovy jmx builder, it was not that hard. Le 11 juin 2012 à 12:12, Samuel CARRIERE a écrit : If I were you, I would connect (through JMX, with jconsole) to one of the nodes that is sending messages to an old node, and would have a look at these MBean : -

Possible bug in Cassandra 1.1.1 with NTS

2012-06-11 Thread Carlo Pires
Just installed cassandra 1.1.1 and run: root@carlo-laptop:/tmp# cassandra-cli -h localhost Connected to: Test Cluster on localhost/9160 Welcome to Cassandra CLI version 1.1.1 Type 'help;' or '?' for help. Type 'quit;' or 'exit;' to quit. [default@unknown] create keyspace accounts ... with

Re: Possible bug in Cassandra 1.1.1 with NTS

2012-06-11 Thread Nick Bailey
The property file snitch isn't used by default. Did you change your cassandra.yaml to use PropertyFileSnitch so it reads cassandra-topology.properties? Also the formatting in your dc property file isn't right. It should be 'ip=dc:rack'. So: 127.0.0.1=dc-test:my-notebook On Mon, Jun 11, 2012 at

Re: Possible bug in Cassandra 1.1.1 with NTS

2012-06-11 Thread Carlo Pires
I forgot to change cassandra.yaml to use PropertyFileSnitch AND cassandra-topology syntax was incorrect. Thanks, Nick. I don't know why I got no error in 1.0.8 with PropertyFileSnitch in cassandra.yaml and wrong syntax in cassandra-topology.properties. PS: I had to change JVM_OPTS in

Re: Possible bug in Cassandra 1.1.1 with NTS

2012-06-11 Thread Nick Bailey
I don't know why I got no error in 1.0.8 with PropertyFileSnitch in cassandra.yaml and wrong syntax in cassandra-topology.properties. Not sure either. PS: I had to change JVM_OPTS in /etc/cassandra/cassandra-env.sh to use 160k instead 128k. This has not been fixed? Still marked as

Re: Much more native memory used by Cassandra then the configured JVM heap size

2012-06-11 Thread Jeffrey Kesselman
Btw. I suggest you spin up JConsole as it will give you much more detai kon what your VM is actually doing. On Mon, Jun 11, 2012 at 9:14 PM, Jason Tang ares.t...@gmail.com wrote: Hi We have some problem with Cassandra memory usage, we configure the JVM HEAP 6G, but after runing Cassandra

Re: Much more native memory used by Cassandra then the configured JVM heap size

2012-06-11 Thread Jason Tang
See my post, I limit the HVM heap 6G, but actually Cassandra will use more memory which is not calculated in JVM heap. I use top to monitor total memory used by Cassandra. = -Xms6G -Xmx6G -Xmn1600M 2012/6/12 Jeffrey Kesselman jef...@gmail.com Btw. I suggest you

Re: Offset in slicequeries for pagination

2012-06-11 Thread Rajat Mathur
Hi Cyril, This may help. http://architecturalatrocities.com/post/13918146722/implementing-column-pagination-in-cassandra On Tue, Jun 12, 2012 at 3:18 AM, Cyril Auburtin cyril.aubur...@gmail.comwrote: If my columns are (k1:k2 = data1), (k11:k32 = data211), (k10:k211 = data91) U mean

Re: batch isolation

2012-06-11 Thread aaron morton
Row level deletion information is included in the row level isolation. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 5/06/2012, at 6:05 AM, Todd Burruss wrote: I don't think I'm being clear. I just was wondering if a row delete is

Re: how to configure cassandra as multi tenant

2012-06-11 Thread aaron morton
Check the documentation for you client or http://www.datastax.com/docs/1.0/dml/using_cql Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 11/06/2012, at 11:25 PM, MOHD ARSHAD SALEEM wrote: Hi Sasha, one more thing by using API's how

Re: Setting column to null

2012-06-11 Thread Roshni Rajagopal
Leonid, Are you using some client for doing these operations..? Hector is a java client which provides APIs for adding/deleting columns to a column family in cassandra. I don¹t think you really need to write your wrapper in this format- you are restricting the number of columns it can use etc.I

Re: Much more native memory used by Cassandra then the configured JVM heap size

2012-06-11 Thread Jason Tang
Hi I found some information of this issue And seems we can have other strategy for data access to reduce mmap usage, in order to use less memory. But I didn't find the document to describe the parameters for Cassandra 1.x, is it a good way to use this parameter to reduce shared memory usage and