RE: Migration from Cassandra 1.2.5 to Cassandra 2.0.8 with changed partitioner settings

2014-07-29 Thread Paco Trujillo
Hi tsi We faced a similar situation a few months ago. At the end what we make is developed a service in our application to migrate the data from the old cassandra 1.2 to the new cassandra 2.0 using cql (with normal SELECT and UPDATE commands) (our application at that moment have two cassandra s

Re: Authentication exception

2014-07-29 Thread Or Sher
Did you ran a repair after changing replication factor for system_auth ? On Tue, Jul 29, 2014 at 5:48 PM, Jeremy Jongsma wrote: > This is still happening to me; is there anything else I can check? All > nodes have NTP installed, all are in sync, all have open communication to > each other. But

Re: unable to load data using sstableloader

2014-07-29 Thread Akshay Ballarpure
Yes Rahul, i didn't created any ring. just a stand alone setup (single node cluster) Issue got resolved after creating sstable file properly...i mean, Keyspace/ColumnFamily folder manually and keeping sstable file in it. Somehow java api is not creating column family folder under keyspace, did

bootstrapping new nodes on 1.2.12

2014-07-29 Thread Parag Patel
Hi, It's taking a while to boostrap a 13th node into a 12 node cluster. The average node size is about 1.7TB. At the beginning of today we were close to .9TB on the new node and 12 hours later we're at 1.1TB. I figured it would have finished by now because when I was looking on OpsCenter, th

Re: Measuring WAN replication latency

2014-07-29 Thread Laing, Michael
I saw this awhile back: With requests possibly coming in from either US region, we need to make > sure that the replication of data happens within an acceptable time > threshold. This lead us to perform an experiment where we wrote 1 million > records in one region of a multi-region cluster. We th

Re: Measuring WAN replication latency

2014-07-29 Thread Rahul Neelakantan
Here is the use case ... The Cassandra ring is going to span 6 data centers. The client can write in any data center (the client is also in 6 DCs) and turn back around and read from any other data center for this I assume you will tell me to use each quorum for the writes, however that is going

Re: Measuring WAN replication latency

2014-07-29 Thread Robert Coli
On Tue, Jul 29, 2014 at 3:15 PM, Rahul Neelakantan wrote: > Does anyone know of a way to measure/monitor WAN replication latency for > Cassandra? No. [1] =Rob [1] There are ways to do something like this task, but you probably don't actually want to do them. Trying to do them suggests that yo

Measuring WAN replication latency

2014-07-29 Thread Rahul Neelakantan
Does anyone know of a way to measure/monitor WAN replication latency for Cassandra? For example I make a write to DC 1 of a multi DC setup using local_quorum , how long before that write is available for a read either locally in DC1 or remotely in DC2 using local_quorum. Rahul Neelakantan

Re: nodetool status returning negative load values on 2.1.0-rc4

2014-07-29 Thread Jeronimo de A. Barros
Mark, Thank you. The "initial_token:" was commented and I didn't notice it. regards, Jero On Tue, Jul 29, 2014 at 1:37 PM, Mark Reddy wrote: > Looks like you are running into this issue: > https://issues.apache.org/jira/browse/CASSANDRA-7239 > > > Mark > > > > > On Tue, Jul 29, 2014 at 5:32 P

nodetool status returning negative load values on 2.1.0-rc4

2014-07-29 Thread Jeronimo de A. Barros
Hi everyone, After upgrade and clean install on a 5 nodes cluster: Datacenter: datacenter1 === Status=Up/Down |/ State=Normal/Leaving/Joining/Moving -- Address Load Tokens Owns (effective) Host ID Rack UN 192.168.3.50 -123645 bytes 256 6

Re: nodetool status returning negative load values on 2.1.0-rc4

2014-07-29 Thread Mark Reddy
Looks like you are running into this issue: https://issues.apache.org/jira/browse/CASSANDRA-7239 Mark On Tue, Jul 29, 2014 at 5:32 PM, Jeronimo de A. Barros < jeronimo.bar...@gmail.com> wrote: > Hi everyone, > > After upgrade and clean install on a 5 nodes cluster: > > Datacenter: datacenter

Re: Authentication exception

2014-07-29 Thread Jeremy Jongsma
This is still happening to me; is there anything else I can check? All nodes have NTP installed, all are in sync, all have open communication to each other. But usually first thing in the morning, I get this auth exception. A little while later, it starts working. I'm very puzzled. On Tue, Jul 22

Re: Thrift vs CQL3 performance

2014-07-29 Thread Vivek Mishra
Checkout differentiators between thrift n cql3. Storage engine is same but they differs in metadata. Prior to 2.0 it was mix of both. I would still suggest the same. Checkout earlier threads around map collection support, bulk loading, dynamic column support comparison b/w thrift and cql3. Ease of

Re: Migration from Cassandra 1.2.5 to Cassandra 2.0.8 with changed partitioner settings

2014-07-29 Thread DuyHai Doan
No, I meant why don't you set the partitioner of 2.0.8 cluster to RandomPartitioner instead of Mumur3 ? On Tue, Jul 29, 2014 at 2:53 PM, tsi wrote: > We are moving our application to a plattform with this partitioner setting > and as far as I know there is no way to specify a partitioner on key

Re: Migration from Cassandra 1.2.5 to Cassandra 2.0.8 with changed partitioner settings

2014-07-29 Thread tsi
We are moving our application to a plattform with this partitioner setting and as far as I know there is no way to specify a partitioner on keyspace level. -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Migration-from-Cassandra-1-2-5-to-Cassand

Re: Migration from Cassandra 1.2.5 to Cassandra 2.0.8 with changed partitioner settings

2014-07-29 Thread DuyHai Doan
Why don't you stay with random partitioner ? On Tue, Jul 29, 2014 at 2:30 PM, tsi wrote: > We are planning to migrate data from a Cassandra 1.2.5 to a new Cassandra > 2.0.8 cluster with changed partitioner settings (1.2.5: > org.apache.cassandra.dht.RandomPartitioner, 2.0.8: > org.apache.cassa

Migration from Cassandra 1.2.5 to Cassandra 2.0.8 with changed partitioner settings

2014-07-29 Thread tsi
We are planning to migrate data from a Cassandra 1.2.5 to a new Cassandra 2.0.8 cluster with changed partitioner settings (1.2.5: org.apache.cassandra.dht.RandomPartitioner, 2.0.8: org.apache.cassandra.dht.Murmur3Partitioner). Restoring a snapshot via BulkLoader fails with error message SSTableRe

Re: Thrift vs CQL3 performance

2014-07-29 Thread Kumar Ranjan
Stick with cql3 going forward. Last i checked, there is no further dev on thrift. I had worked with Thrift based c* api for 2 years in Python based pycassa and experience was not very satisfactory. I had not done comparisions between pycassa and cql so cant say. Cql isvery simple any way.— Sent

Re: unable to load data using sstableloader

2014-07-29 Thread Rahul Neelakantan
Sstabloader and Cassandra can't use the same network interface, clearly mentioned in the Cassandra documentation on DataStax. If you are running both Cassandra and SStableloader locally, you have to take some extra steps. Look at the post. pushpalankajaya.blogspot.com/2012/06/bulk-loading-data-

Re: unable to load data using sstableloader

2014-07-29 Thread Rahul Neelakantan
Is SStable loader being run on the same host as the Cassandra node 127.0.0.1 (I see your ring is made up of all loop back IPs). Rahul Neelakantan 678-451-4545 > On Jul 29, 2014, at 4:55 AM, Akshay Ballarpure > wrote: > > Thanks Duncan for quick help > now i am trying sstableloader but it

Re: unable to load data using sstableloader

2014-07-29 Thread Akshay Ballarpure
Thanks Duncan for quick help now i am trying sstableloader but its not loading data...any suggestion ? [root@CSL-simulation conf]# ps -eaf | grep -i cass root 20322 1 0 Jul28 ?00:04:27 /usr/java/jdk1.7.0_60/bin/java -ea -javaagent:./../lib/jamm-0.2.5.jar -XX:+CMSClassUnload

Re: unable to load data using sstableloader

2014-07-29 Thread Duncan Sands
Hi Akshay, On 29/07/14 09:14, Akshay Ballarpure wrote: Yes, I have created keyspaces, but still i am getting error. cqlsh:sample_new> DESCRIBE KEYSPACES ; system sample mykeyspace test *sample_new* system_traces [root@CSL-simulation conf]# ../bin/sstableloader /root/Akshay/Cassandra/apache

Re: unable to load data using sstableloader

2014-07-29 Thread Akshay Ballarpure
Yes, I have created keyspaces, but still i am getting error. cqlsh:sample_new> DESCRIBE KEYSPACES ; system sample mykeyspace test sample_new system_traces [root@CSL-simulation conf]# ../bin/sstableloader /root/Akshay/Cassandra/apache-cassandra-2.0.8/conf/SAMPLE_NEW/DATA_NEW/ -d localhos