Re: question about replicas & dynamic response to load

You can remove a node from the ring use nodetool removetoken (see http://wiki.apache.org/cassandra/Operations), this will not stream data to the other nodes. You would prob want to run repair to make sure everything was ok. Not sure what your last question is. Hope that helps. Aaron On 7/03

Re: What would be a good strategy for Storing the large text contents like blog posts in Cassandra.

Thanks Aaron!! I didnt knew about the upcoming facility for inbuilt counters. This sounds really great for my use-case!! Could you let me know where can I read more about this, if this had been blogged about, somewhere ? I'll go forward with the one (entire)blog per column design. Thanks On M

Re: Secondary indexes

Info on secondary indexes http://www.datastax.com/dev/blog/whats-new-cassandra-07-secondary-indexes Some answers to your other questions are also in there as well as a discussion about the limitations. Hope that helps. Aaron On 7/03/2011, at 3:54 PM, Mark wrote: > I haven't looked at Cass

Re: question about replicas & dynamic response to load

Thanks for the answers, Dan, Aaron. ... Ok, so one question is, if I haven't made any writes at all, can I decommission without delay? (Is there a "force drop" option or something, or will the cluster recognize the lack of writes)? I may be able to segregate writes to the "reference collection

Secondary indexes

I haven't looked at Cassandra since 0.6.6 and now I notice in 0.7+ there is support for secondary indexes. I haven't found much material on how these are used and when one should use one. Can someone point me in the right direction. Also can these be created (and deleted) as needed without aff

Re: Designing a decent data model for an online music shop...confused/stuck on decisions

Regarding PHP performance with Cassandra, THRIFT-638was recently resolved and it shows some big performance improvements. I'll be upgrading the Thrift package that ships with phpcassa soon to include this fix, so you may want to compare performance

Designing a decent data model for an online music shop...confused/stuck on decisions

We're in a bit of a predicament, we have an e-music store currently built in PHP using codeigniter/mysql... The current system has 100+K users and a decent song collection. Over the last few months I've been playing with Cassandra... needless to say I'm impressed but I have a few questions. First

Re: cant seem to figure out secondary index definition

On Sun, Mar 6, 2011 at 4:49 PM, Jürgen Link wrote: > Hi Roshan, > thanks for your post. I quickly ran over it, and the only difference I can > actually see is the compare_with type (we use TimeUUIDType). > > Any other suggestions, anyone? > You want to add an index on a CF with TimeUUIDType colu

Re: OOM exceptions

Sorry, I forgot to mention. I am running 0.6.6 On 3/6/11 3:27 PM, Aaron Morton wrote: Under 0.6 am not sure off the top of my head. Would need to dig into it, its probably been discussed here though. Check the row size and let us know what version you are using first. Aaron On 7/03/2011, at

Re: What would be a good strategy for Storing the large text contents like blog posts in Cassandra.

Sounds reasonable, one CF for the blog post one CF for the comments. You could also use a single CF if you will often read the blog and the comments at the same time. The best design is the one that suits how your app works, try one and be prepared to change. Note that counters are only in the

Re: OOM exceptions

Under 0.6 am not sure off the top of my head. Would need to dig into it, its probably been discussed here though. Check the row size and let us know what version you are using first. Aaron On 7/03/2011, at 5:50 AM, Mark wrote: > If its determined that this is due to a very large row, what are

Re: cant seem to figure out secondary index definition

Hi Roshan, thanks for your post. I quickly ran over it, and the only difference I can actually see is the compare_with type (we use TimeUUIDType). Any other suggestions, anyone? Am 06.03.2011 12:24, schrieb Roshan Dawrani: Hi, Sure. Here is a sample of how we define it at the end of cassan

Re: how large can a cluster over the WAN be?

Hi, Please, can you help with the following? it will lead us in some design decisions. Are you familiar with Cassandra cluster that is installed in datacenters that are spread across the WAN? can you comment on the perfromance of such installation? What is the largest size of of such a cluster you

What would be a good strategy for Storing the large text contents like blog posts in Cassandra.

What would be a good strategy to store large text content/(blog posts of around 1500-3000 characters) in cassandra? I need to store these blog posts along with their metadata like bloggerId, blogTags. I am looking forward to store this data in a single row giving each attribute a single column. So

Re: OOM exceptions

If its determined that this is due to a very large row, what are my options? Thanks On 3/5/11 7:11 PM, aaron morton wrote: First question is which version are you running ? Am guessing 0.6 something If you have OOM in the compaction thread it may be because of a very large row. The CF inform

Re: Nodes frozen in GC

Do you have row cache enabled? Disable it. If it fixes it and you want it, re-enable but consider row sizes and the cap on the cache size.. -- / Peter Schuller

Re: confirm unsubscribe from user@cassandra.apache.org

On 03/06/2011 08:08 AM, user-h...@cassandra.apache.org wrote: > Hi! This is the ezmlm program. I'm managing the > user@cassandra.apache.org mailing list. > > To confirm that you would like > >cm...@thecommandline.net > > removed from the user mailing list, please send a short reply > to thi

Re: cant seem to figure out secondary index definition

On Sun, Mar 6, 2011 at 4:54 PM, Roshan Dawrani wrote: > > > -- > keyspaces: > - name: firstname > validator_class: UTF8Type > index_type: KEYS

Re: cant seem to figure out secondary index definition

Hi, Sure. Here is a sample of how we define it at the end of cassandra.yaml. In the keyspace MyApp, it defines a column family MyUser, that has secondary indexes on 2 String columns - firstname, and lastname. Does it help?

Re: cant seem to figure out secondary index definition

Hi Roshan, could you please post a small sample from your yaml file? As documentation of indexes is quite sparse, we're grateful for any working example. Cheers Jürgen Am 04.03.2011 19:27, schrieb Roshan Dawrani: On Fri, Mar 4, 2011 at 11:52 PM, Jürgen Link mailto:juergen.l...@googlemail.com>

Re: Nodes frozen in GC

2011/3/6 aaron morton > Your node is under memory pressure, after the GC there is still 5.7GB in > use. In fact it looks like memory usage went up during the GC process. > > Can you reduce the memtable size, caches or the number of CF's or increase > the JVM size? Also is this happening under hea