Migrating Cassandra to New Nodes

2014-04-28 Thread nash
I have a new set of nodes and I'd like to migrate my entire cluster onto them without any downtime. I believe that I can launch the new cluster and have them join the ring and then use nodetool to decommission the old nodes one at a time. But, I'm wondering what is the safest way to update the seed

Re: Recommended Approach for Config Changes

2014-04-28 Thread Phil Burress
Thanks for all the good info. We have found that running drain first before restarting should always be done, even if there is not much data or I/O. Also, we've found that node tool drain returns often before it's finished, so it's important to watch the logs (or opscenter) for it and any compact

row caching for frequently updated column

2014-04-28 Thread Jimmy Lin
I am wondering if there is any negative impact on Cassandra write operation, if I turn on row caching for a table that has mostly 'static columns' but few frequently write columns (like timestamp). The application will frequently write to a few columns, and the application will also frequently que

RE: java.lang.OutOfMemoryError: Java heap space

2014-04-28 Thread Arindam Barua
If you don’t have row caching turned on, you can try changing settings to get your memtables to flush faster (read more at the datastax documention at [1]). Btw, if you are using a pre-1.2 version, your bloom filter might come into play as well. All said and done, if your write request rate is

Can the seeds list be changed at runtime?

2014-04-28 Thread Lu, Boying
Hi, All, I wonder if I can change the seeds list at runtime. i.e. without change the yaml file and restart DB service? Thanks Boying

Re: Load balancing issue with virtual nodes

2014-04-28 Thread Ben Bromhead
Some imbalance is expected and considered normal: See http://wiki.apache.org/cassandra/VirtualNodes/Balance As well as https://issues.apache.org/jira/browse/CASSANDRA-7032 Ben Bromhead Instaclustr | www.instaclustr.com | @instaclustr | +61 415 936 359 On 29 Apr 2014, at 7:30 am, DuyHai Doan w

Re: java.lang.OutOfMemoryError: Java heap space

2014-04-28 Thread Gary Zhao
Yes, they are virtual machines, but we are using KVM. Is there any solutions for this issue or we should use physical machines? On Mon, Apr 28, 2014 at 10:38 AM, Prem Yadav wrote: > Are the virtual machines? The last time I had this issues was because of > VMWare "ballooning". > If not, what ve

Re: JDK 8

2014-04-28 Thread Colin
It seems to run ok, but I havent seen it yet in production on 8. -- Colin Clark +1-320-221-9531 > On Apr 28, 2014, at 4:01 PM, "Ackerman, Mitchell" > wrote: > > I’ve been searching around, but cannot find any information as to whether > Cassandra runs on JRE 8. Any information on that? >

JDK 8

2014-04-28 Thread Ackerman, Mitchell
I've been searching around, but cannot find any information as to whether Cassandra runs on JRE 8. Any information on that? Thanks, Mitchell

Re: Load balancing issue with virtual nodes

2014-04-28 Thread DuyHai Doan
Hello all Some update about the issue. After wiping completely all sstable/commitlog/saved_caches folder and restart the cluster from scratch, we still experience weird figures. After the restart, nodetool status does not show an exact balance of 50% of data for each node : Status=Up/Down |/

Re: Cassandra data retention policy

2014-04-28 Thread Jon Haddad
He said below that he’d like to keep the old data, so that might rule out TTLs in any case. You’ve got a few options that I can think of off the top of my head. The easiest from a management perspective is to use one table per month. WhateverData042014 would be this months. It’s easy enough

Re: Cassandra data retention policy

2014-04-28 Thread tommaso barbugli
TTL is good for this but I have no idea how you will ever be able to restore data removed from disk like that. Perhaps one could make a snapshot and then delete everything with timestamp older than a date and then run compaction on every node to reclaim the disk. 2014-04-28 21:57 GMT+02:00 Donald

Re: Cassandra data retention policy

2014-04-28 Thread Redmumba
Have you looked into using a TTL? You can set this per insert (unfortunately, it can't be set per CF) and values will be tombstoned after that amount of time. I.e., INSERT INTO VALUES ... TTL 15552000 Keep in mind, after the values have expired, they will essentially become tombstones-

RE: Cassandra data retention policy

2014-04-28 Thread Donald Smith
CQL lets you specify a default TTL per column family/table: and default_time_to_live=86400 . From: Redmumba [mailto:redmu...@gmail.com] Sent: Monday, April 28, 2014 12:51 PM To: user@cassandra.apache.org Subject: Re: Cassandra data retention policy Have you looked into using a TTL? You can set

Cassandra data retention policy

2014-04-28 Thread Han Jia
Hi guys, We have a processing system that just uses the data for the past six months in Cassandra. Any suggestions on the best way to manage the old data in order to save disk space? We want to keep it as backup but it will not be used unless we need to do recovery. Thanks in advance! -John

Discount Codes for Cassandra Trainings this week!

2014-04-28 Thread Stephanie Huynh
Hey Cassandra Community, We still have open seats to the Developer trainings this week and are offering discounts if you are interested in attending. 10% off 1 ticket 20% off 2 tickets 30% off 3 tickets http://www.datastax.com/what-we-offer/products-services/training If you are intere

Re: java.lang.OutOfMemoryError: Java heap space

2014-04-28 Thread Prem Yadav
Are the virtual machines? The last time I had this issues was because of VMWare "ballooning". If not, what versions of Cassandra and Java are you using? On Mon, Apr 28, 2014 at 6:30 PM, Gary Zhao wrote: > BTW, the CPU usage on this node is pretty high, but data size is pretty > small. > > PID

Re: java.lang.OutOfMemoryError: Java heap space

2014-04-28 Thread Gary Zhao
BTW, the CPU usage on this node is pretty high, but data size is pretty small. PID USERNAME THR PRI NICE SIZE RES SHR STATE TIMECPU COMMAND 28674 cassandr 89 250 9451M 8970M 525M sleep 32.1H 329% java UN 8.92 GB256 35.4% c2d9d02e-bdb3-47cb-af1b-eabc2eeb503b rac

java.lang.OutOfMemoryError: Java heap space

2014-04-28 Thread Gary Zhao
Hello I have a three nodes cluster. I noticed one node was always down. Restarting Cassandra fixes it but it will go down again after a couple of days. I'm pretty new to Cassandra so I'm wondering how I should troubleshoot it. Logs is as below. INFO [StorageServiceShutdownHook] 2014-04-28 13:21: