Re: Running sstableloader from every node when migrating?

2015-11-30 Thread anuja jain
Hello George, You can use sstable2json to create the json of your keyspace and then load this json to your keyspace in new cluster using json2sstable utility. On Tue, Dec 1, 2015 at 3:06 AM, Robert Coli wrote: > On Thu, Nov 19, 2015 at 7:01 AM, George Sigletos > wrote: > >> We would like to mig

[no subject]

2015-11-30 Thread Jay Reddy

Re: Running sstableloader from every node when migrating?

2015-11-30 Thread Robert Coli
On Thu, Nov 19, 2015 at 7:01 AM, George Sigletos wrote: > We would like to migrate one keyspace from a 6-node cluster to a 3-node > one. > http://www.pythian.com/blog/bulk-loading-options-for-cassandra/ =Rob

Re: Does the rebuild tools rebuild all each time it start Or rebuild the rest?

2015-11-30 Thread Robert Coli
On Fri, Nov 20, 2015 at 8:54 AM, wateray wrote: > *is it rebuild all rang of tokens which belong to the node or just rebuild > the rest rang of tokens from last rebuild.(since last rebuild we get some > data).* > There is no resume in versions before 2.2.x, it will duplicate-rebuild anything tha

Re: Cassandra 3.0.0 connection problem

2015-11-30 Thread Robert Coli
On Wed, Nov 18, 2015 at 11:13 PM, Enrico Sola wrote: > Hi, I'm new to Cassandra and I've recently upgraded to 3.0.0 on Ubuntu > Linux 14.04 LTS > https://www.eventbrite.com/engineering/what-version-of-cassandra-should-i-run/ =Rob

Re: Strategy tools for taking snapshots to load in another cluster instance

2015-11-30 Thread Robert Coli
On Wed, Nov 18, 2015 at 2:23 AM, Anishek Agarwal wrote: > We have 5 node prod cluster and 3 node test cluster. Is there a way i can > take snapshot of a table in prod and load it test cluster. The cassandra > versions are same. > http://www.pythian.com/blog/bulk-loading-options-for-cassandra/ =

Re: Cassandra Cleanup and disk space

2015-11-30 Thread Robert Coli
On Thu, Nov 26, 2015 at 12:55 AM, Luigi Tagliamonte wrote: > I'd like to understand what cleanup does on a running cluster when there > is no cluster topology change, i did a test and i saw the cluster disk > space shrink of 200GB. > "writes out files 1:1 with their input files" IIRC it does no

Re: Huge ReadStage Pending tasks during startup

2015-11-30 Thread Robert Coli
On Fri, Nov 27, 2015 at 2:52 AM, Vasiliy I Ozerov wrote: > We have some strange troubles with cassandra startup. Cluster consists of > 4 nodes. 32 Gb RAM per node, each node has about 30Gb of data, 8 CPU. > > So, just after start it has 2753202 pending readstage tasks. And it takes > about 11 hou

Re: Moving SSTables from one disk to another

2015-11-30 Thread Robert Coli
On Mon, Nov 30, 2015 at 11:29 AM, S C wrote: > It is inevitable that the repairs are needed to keep consistency > guarantees. Is it worthwhile to consider RAID-0 as we get more storage? One > can treat loss of disk as loss of node and rebuild the node and repair. Any > other suggestions are most

Re: handling down node cassandra 2.0.15

2015-11-30 Thread Robert Coli
On Wed, Nov 18, 2015 at 6:16 AM, Anuj Wadehra wrote: > Suppose, gc grace seconds=10days, max hinted handoff period=3 hrs, 3 nodes > are there A,B & C,RF =3 and my client is reading at CL ONE. C remains down > for 5 hours and misses many updates including those which happened after > max hinted ha

Re: Moving SSTables from one disk to another

2015-11-30 Thread S C
Rob, It is inevitable that the repairs are needed to keep consistency guarantees. Is it worthwhile to consider RAID-0 as we get more storage? One can treat loss of disk as loss of node and rebuild the node and repair. Any other suggestions are most welcome. -Sri _

Re: Questions to StorageServiceMBean.forceRepaireRangeAsync()

2015-11-30 Thread Paulo Motta
Hello Boying, 1. "repairedAt" actually means "fullRepair", so set that to true if you want to run ordinary/full repair or false if you want to run incremental repair. 2. You should use StorageServiceMBean.repairAsync(String, Map), where the options map will be parsed by org.apache.cassandra.repair

Re: Help diagnosing performance issue

2015-11-30 Thread Ryan Svihla
Honestly 20ms for spinning disks is really good, so I think you're just dealing with the reality of having a certain percentage of your reads off disk and not in memory. If you're reading data that is on older SSTables and you're out of buffer cache I'm not sure how else you could improve that. So

Questions to StorageServiceMBean.forceRepaireRangeAsync()

2015-11-30 Thread Lu, Boying
Hi, All, We plan to upgrade Cassandra from 2.0.17 to the latest release 2.2.3 in our product. We use: /** * Same as forceRepairAsync, but handles a specified range */ public int forceRepairRangeAsync(String beginToken, String endToken, final String keyspaceName, boolean isSequential,