Re: Rebuilding with vnodes

On Wed, Nov 2, 2016 at 8:59 PM, Anubhav Kale wrote: > Hello, > > > > I am trying to rebuild a new Data Center with 50 Nodes, and expect 1 TB / > node. Nodes are backed by SSDs, and the rebuild is happening from another > DC in same physical region. This is with 2.1.13. > > > > I am doing this wit

Re: Secondary Index on Boolean column with TTL

Thanks a lot, DuyHai! 2016-10-31 19:53 GMT+03:00 DuyHai Doan : > Technically TTL should be handled properly. However, be careful of expired > data turning into tombstones. For the original table, it may be a tombstone > on a skinny partition but for the 2nd index, it may be a tombstone set on a >

Re: failing bootstraps with OOM

Hi Alex - I do monitor sstable counts and pending compactions, but probably not closely enough. In 3/4 regions the cluster is running in, both counts are very high - ~30-40k sstables for one particular CF, and on many nodes >1k pending compactions. I had noticed this before, but I didn't have a

Re: failing bootstraps with OOM

On Thu, Nov 3, 2016 at 2:32 PM, Mike Torra wrote: > Hi Alex - I do monitor sstable counts and pending compactions, but > probably not closely enough. In 3/4 regions the cluster is running in, both > counts are very high - ~30-40k sstables for one particular CF, and on many > nodes >1k pending com

Improving cassandra documentation

Hi, from time to time I find errors in datastax cassandra docs. Is there a right & easy way to report them? Thanks. -- Oleg Krayushkin

Issue with Unexpected exception

Hi, about month ago I already asked about my problem here (with subject "Error while read after upgrade from 2.2.7 to 3.0.8") and also at stackoverflow . Unfortunately, I still didn't find a solution. It's "Unexpected exception" -- maybe it's a good ide

Re: Issue with Unexpected exception

>From the trace, "Connection reset by peer" simply mean the client disconnected, which isn't necessary a problem/abnormal per se (and if it is, it sounds more like a client issue than anything else). That said, I'm not sure why 3.0.8 log this at INFO now, as that's not really a problem, so if you c

Re: Handle Leap Seconds with Cassandra

You're able to set the timestamp of the write in the client application. If you have a table which is especially sensitive to out of order writes and want to deal with the repeated second correctly, you could do slewing at your client application layer and be explicit with the timestamp for those s

Re: Schema not translated completely from Thrift protocol to CQL protocol

bump. On Tue, Nov 1, 2016 at 1:16 PM, Nitin Pasari wrote: > Hi, > > I am trying to move from using pycassa to native protocol in my project > (which will let us upgrade the version of cassandra). My schema was defined > using pycassa so it created a Column family using compact storage and it > h

Re: Backup restore with a different name

Hi Jens, Looks like what you need is an "any point in time" recovery solution. I suggest that you go back to the snapshot that you issued that was closest to "20161102" and restore that snapshot using the bulk loader to a new table called "users_20161102". If you need to recover precisely to a par

Re: Improving cassandra documentation

http://docs.datastax.com/en/landing_page/doc/landing_page/contact.html Looks like it is still just email d...@datastax.com On Thu, Nov 3, 2016 at 9:34 AM, Oleg Krayushkin wrote: > Hi, from time to time I find errors in datastax cassandra docs. Is there a > right & easy way to report them? > > Th

Re: Improving cassandra documentation

Maybe a little off-tangent, but there is also a set of open source documentation now available on the Apache Cassandra website: http://cassandra.apache.org/doc/latest/ You can contribute to them directly via git On Thu, 3 Nov 2016 at 12:11 SmartCat - Scott Hirleman wrote: > http://docs.datastax

Re: Improving cassandra documentation

Hi Oleg, I highly recommend to contribute to Apache documentation. I think C* needs lot more non-datastax documentation. Lahiru On Thu, Nov 3, 2016 at 1:24 PM, Justin Cameron wrote: > Maybe a little off-tangent, but there is also a set of open source > documentation now available on the Apache

Re: Improving cassandra documentation

Totally agree, I just saw DataStax + docs so I figured it was about DSE, not OSS C* *shrug*. On Thu, Nov 3, 2016 at 2:24 PM, Justin Cameron wrote: > Maybe a little off-tangent, but there is also a set of open source > documentation now available on the Apache Cassandra website: > http://cassandr

RE: Question on Read Repair

Does it work the same way for writes as well ? If “nodetool status” shows that a node is DN, would writes fail right away assuming enough nodes are down to fail QUORUM ? From: Jeff Jirsa [mailto:jeff.ji...@crowdstrike.com] Sent: Tuesday, October 11, 2016 1:13 PM To: user@cassandra.apache.org Sub

Cassandra on Cloud platforms experience

I would like to hear from the community on their experiences or lesson learnt on hosting Cassandra in cloud platforms like 1. Google Cloud Platform 2. AWS 3. Azure 1. Which cloud hosting is better and Why? 2. What differences of C* over vendor provided NoSQL DB like (Bigtable, Dynamo,Azure Docu

Commercial Support Providers?

Hello - We’re rolling out a small cluster at my work (2 DCs of 3 nodes each — hosted on-premises), and my boss has asked us to look into commercial support offerings. The main thing we’re looking for is a company that we can call day or night if/when things go “kaboom” and I can’t figure out w

Re: Commercial Support Providers?

I can confirm that we do offer support contracts for OSS Apache Cassandra at Instaclustr (in addition to our managed service) - either drop me an email direct (signature below) or contact sa...@instaclustr.com and would be happy to discuss details. Cheers Ben On Fri, 4 Nov 2016 at 14:02 Max C wr

Re: Backup restore with a different name

On 2 November 2016 at 22:10, Jens Rantil wrote: > I mean "exposing that state for reference while keeping the (corrupt) > current state in the live cluster". The following should work: 1. Create a new table with the same schema but different name (in the same or a different keyspace).

RE: Backup restore with a different name

Hi Jens – I put together a couple of simple scripts a couple of years ago that might do exactly what you need. These leverage nodetool snapshot and sstableloader to create keyspace snapshots, collect up all the necessary SSTable files in an easy-to-move file, rename the keyspace, restore it to the

Re: failure node rejoin

Thanks Ben, When I added `nodetool flush` on all nodes after step 2, the problem didn't happen. Did replay from old commit logs delete rows? Perhaps, the flush operation just detected that some nodes were down in step 2 (just after truncating tables). (Insertion and check in step2 would succeed i