what is best way to do load balance if cluster has Imbalance load

2010-09-11 Thread maneela a
we have a Cassandra set up running with 4 nodes with Reflicationfactor:2 and OrderPreservingPartitioner as partitioner but we have not provided InitialToken values. Could some one suggest me what is best way to balance my cluster because some of user threads have suggested do not ever run

Re: what is best way to do load balance if cluster has Imbalance load

2010-09-11 Thread aaron morton
See the section on Moving or Removing nodes here http://wiki.apache.org/cassandra/Operations you should also read the bootstrapping section as that is essentially what you are doing. AFAIK you should use nodetool move to assign a new token to the nodes. As you say, loadbalance is not

Re: 4k keyspaces... Maybe we're doing it wrong?

2010-09-11 Thread samal gorai
Lot of memtables means lot of sstables means lot of disk io. On 9/7/10, Benjamin Black b...@b3k.us wrote: On Mon, Sep 6, 2010 at 12:41 AM, Janne Jalkanen janne.jalka...@ecyrd.com wrote: So if I read this right, using lots of CF's is also a Bad Idea(tm)? Yes, lots of CFs is bad means lots

Re: what is best way to do load balance if cluster has Imbalance load

2010-09-11 Thread March, Andres
It should be simpler than that if the wiki is correct. Search the list archives or wiki for the small script that calculates what the token should be for each node. After that it should be as simple as using nodetool move on one node at a time. On Sep 11, 2010, at 2:00 AM, aaron morton

get_indexed_slices sorting

2010-09-11 Thread Petr Odut
Hi, I can't test new IndexOperators so I would like to ask you whether new Cassandra 0.7 sorts the results - i.e. I have an secondary index on age of user cf and I want to get top 10 oldest users. Can cassandra do this? Thanks, Petr

Re: get_indexed_slices sorting

2010-09-11 Thread Frank LoVecchio
I actually need a similar query; can someone update the wiki on adding a secondary index in 0.7? http://wiki.apache.org/cassandra/SecondaryIndexes Thanks, Frank On Sat, Sep 11, 2010 at 2:35 PM, Petr Odut petr.o...@gmail.com wrote: Hi, I can't test new IndexOperators so I would like to ask

Re: get_indexed_slices sorting

2010-09-11 Thread Jonathan Ellis
Not until https://issues.apache.org/jira/browse/CASSANDRA-1339 is done On Sat, Sep 11, 2010 at 3:35 PM, Petr Odut petr.o...@gmail.com wrote: Hi, I can't test new IndexOperators so I would like to ask you whether new Cassandra 0.7 sorts the results - i.e. I have an secondary index on age of