R: Re: Schema clone ...

2012-01-11 Thread cbert...@libero.it
I got it :-)Thanks for your patience Aaron ... the problem was that the cluster-name in yaml was different.Now it works, I've cloned the schema Regards Carlo Messaggio originale Da: aa...@thelastpickle.com Data: 10/01/2012 20.13 A: Ogg: Re: Schema clone ... * Grab the sy

multiple datastax opscenter?

2012-01-11 Thread Jeesoo Shin
Hi, I know OpsCenter doesn't support multiple cluster yet. I tried to install & run multiple OpsCenter in a server with different port. different port for web and agent. same cassandra jmx, thrift port. But second OpsCenter doesn't show any cluster node number. (web is working) Am I missing a conf

Re: multiple datastax opscenter?

2012-01-11 Thread Jeesoo Shin
never mind. it works. my second cluster didn't have any keyspace, that why. On 1/11/12, Jeesoo Shin wrote: > Hi, > I know OpsCenter doesn't support multiple cluster yet. > I tried to install & run multiple OpsCenter in a server with different > port. > different port for web and agent. same cass

Re: AW: AW: How to control location of data?

2012-01-11 Thread Andreas Rudolph
Hi! > ... > So actually if you use Cassandra – for the application the actual storage > location of the data should not matter. It will be available anywhere in the > cluster if it is stored on any reachable node. I suspected it so, that is Cassandra does not provide a mechanism to strictly co

Re: How to control location of data?

2012-01-11 Thread Andreas Rudolph
Hi! > ... > Again, it's probably a bad idea. I agree on that, now. Thank you. > > Cheers > > - > Aaron Morton > Freelance Developer > @aaronmorton > http://www.thelastpickle.com > > On 11/01/2012, at 4:56 AM, Roland Gude wrote: > >> >> Each node in the cluster is assigned

Rebalance cluster

2012-01-11 Thread Daning Wang
Hi All, We have 5 nodes cluster(on 0.8.6), but two machines are slower and have less memory, so the performance was not good on those two machines for large volume traffic.I want to move some data from slower machine to faster machine to ease some load, the token ring will not be equally balanced

Re: Syncing across environments

2012-01-11 Thread aaron morton
Nothing Cassandra specific that I am aware of. Do you have any ops automation such as chef or puppet ? Data Stax make their chef cook books available here https://github.com/riptano/chef Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 11

Re: Rebalance cluster

2012-01-11 Thread David McNelis
Daning, You can see how to do this basic sort of thing on the Wiki's operations page ( http://wiki.apache.org/cassandra/Operations ) In short, you'll want to run: nodetool -h hostname move newtoken Then, once you've update each of your tokens that you want to move, you'll want to run nodetool -h

Re: Syncing across environments

2012-01-11 Thread David McNelis
Not currently using any of those tools (though certainly an option, just never looked into them). Those tools seem more based around configuration of your environments...where I'm more concerned with backfilling data from production to early-stage environments to help facilitate development. Stil

Re: Rebalance cluster

2012-01-11 Thread aaron morton
I have good news and bad. The good news is I have a nice coffee. The bad news is it's pretty difficult to have some nodes with less load. In a cluster with 5 nodes and RF 3 each node holds the following token ranges. node1: node 1, 5 and 4 node 2: node 2, 1, 5 node 3: node 3, 2, 1 node 4: no

Re: Syncing across environments

2012-01-11 Thread aaron morton
You can use chef for setting up the cluster and pull snapshots down for the data. That will require a 1 to 1 mapping between the prod and dev / QA clusters. That way you can also test the DevOps processes for deployment and disaster recovery. Cheers - Aaron Morton Freelance

Re: Syncing across environments

2012-01-11 Thread David McNelis
Right. One of the challenges though is if the key's wouldn't necessarily directly translate. Say I've got a MySQL instance in my Dev VM and my keys are based on PKs in that database...but my MySQL instance by nature of what I'm working on has some different IDs...so in some way I'd need to mu

Exception thrown during repair, contains jmx classes -- why?

2012-01-11 Thread Maxim Potekhin
As per below trace, there is jmx.mbeanserber involved. What I ran was a common repair. Is that right? What does this failure indicate? at org.apache.cassandra.service.StorageService.forceTableRepair(StorageService.java:1613) at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ

Re: Rebalance cluster

2012-01-11 Thread Antonio Martinez
There is another possible approach that I reference from the original Dynamo paper. Instead of trying to manage a heterogeneous cluster at the cassandra level, it might be possible to take the approach Amazon took. Find the smallest common denominator of resource for your nodes(most likely your sma

Re: Exception thrown during repair, contains jmx classes -- why?

2012-01-11 Thread aaron morton
You are missing the name of the exception from the top of the stack trace. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 12/01/2012, at 10:12 AM, Maxim Potekhin wrote: > As per below trace, there is jmx.mbeanserber involved. What I ran w

Re: multiple datastax opscenter?

2012-01-11 Thread Jeesoo Shin
hmmm.. just an update. sorry, it doesn't work. I did get multiple web port listen, but opscenter seem to be using same resource or what and it can not have multiple running. On 1/11/12, Jeesoo Shin wrote: > never mind. > it works. > > my second cluster didn't have any keyspace, that why. > > On

Re: How to control location of data?

2012-01-11 Thread Viktor Jevdokimov
The idea behind client that controls location of a data is performance, to avoid unnecessary network round-trips between nodes and unnecessary caching of backup ranges. All of this mostly is true for reads at CL.ONE and RF>1. How it works (in our case): Our client uses describe_ring that returns