Re: Cassandra vnodes Streaming Reliability Calculator

r message to grep for. 4) Note that Datastax recommends 8 vnodes now. See my blog for the reference. Thanks, James Briggs. -- Cassandra/MySQL DBA. Available in Bay area or remote. cass_top: https://github.com/jamesbriggs/cassandra-top From: Kenneth Brotman To: user@cassandra.apache.org

Cassandra vnodes Streaming Reliability Calculator

Hi folks. Please check out my online vnodes reliability calculator and reply with any feedback:http://www.jebriggs.com/blog/2019/02/cassandra-vnodes-reliability-calculator/ Thanks, James Briggs. -- Cassandra/MySQL DBA. Available in Bay Area or remote. cass_top: https://github.com/jamesbriggs

Re: Long GC Pauses

https://docs.datastax.com/en/cassandra/3.0/cassandra/operations/opsTuneJVM.html http://thelastpickle.com/blog/2018/04/11/gc-tuning.html Your cluster: Which version of Java? How much RAM do your systems have?Is it the same on all nodes?What are your current heap settings?Anything else? Thanks, James B

Re: Jepsen testing

For those relatively new to Cassandra, Riptano is the previous company name for Datastax, back in 2011. :)  http://www.h-online.com/open/news/item/Cassandra-service-company-Riptano-changes-name-to-DataStax.html Thanks, James Briggs. -- Cassandra/MySQL DBA. Available in San Jose area or remote

Re: JBOD disk failure - just say no

Cassandra JBOD has a bunch of issues, so I don't recommend it for production: 1) disks fill up with load (data) unevenly, meaning you can run out on a disk while some are half-full2) one bad disk can take out the whole node3) instead of a small failure probability on an LVM/RAID volume, with JBOD

Re: Cassandra Needs to Grow Up by Version Five!

Kenneth: What you said is not wrong. Vertica and Riak are examples of distributed databases that don't require hand-holding. Cassandra is for Java-programmer DIYers, or more often Datastax clients, at this point. Thanks, James. From: Kenneth Brotman To: user@cassandra.apache.org Cc: d

Re: Reg :- Multiple Node Cluster set up in Virtual Box

Nandan: The original Datastax training classes (when it was still called Riptano) used 3 virtualbox Debian instances to setup a Cassandra cluster. Thanks, James Briggs. -- Cassandra/MySQL DBA. Available in San Jose area or remote. cass_top: https://github.com/jamesbriggs/cassandra-top

Re: cassandra.yaml configuration for large machines (scale up vs. scale out)

> I know that Cassandra is built for scale out on commodity hardware The term "commodity hardware" is not very useful, though the averageserver-class machine bought in 2017 can work. Netflix found that SSD helped greatly with compactions in production.Generally servers use 10 GB networking in 20

Re: Indexes Fragmentation

MySQL Cluster (don't use FKs yet) or Redis (in-memory databases) sound more appropriate for data that churns a lot. Thanks, James Briggs. -- Cassandra/MySQL DBA. Available in San Jose area or remote. cass_top: https://github.com/jamesbriggs/cassandr

Re: Cassandra Data Model design

://planetcassandra.org/blog/getting-started-with-time-series-data-modeling/ Thanks, James Briggs. -- Cassandra/MySQL DBA. Available in San Jose area or remote. cass_top: https://github.com/jamesbriggs/cassandra-top From: Check Peck To: user Sent: Wednesday

Re: what's cool about cassandra 2.1.0?

I'll be blunt. The reason to use the latest 2.0 or soon 2.1 is because Apple has committed 20 patches that make Cassandra operationally useful. Apple is the QA lab for Cassandra. Their conference talk was very exciting. I hope a video of that gets posted in October. Thanks, James B

Re: Blocking while a node finishes joining the cluster after restart.

my cass_top project this week, I'll take a look at scripting what you mentioned in this thread. Thanks, James Briggs. -- Cassandra/MySQL DBA. Available in San Jose area or remote. From: Kevin Burton To: "user@cassandra.apache.org" ; James B

Re: Help with approach to remove RDBMS schema from code to move to C*?

first though. Most companies don't have a budget to re-QA applications a second time. Maybe introduce C* to your organization on a new, small project first? Thanks, James Briggs. -- Cassandra/MySQL DBA. Available in San Jose area or remote. From

Re: no change observed in read latency after switching from EBS to SSD storage

large data loads (compaction is the trade-off for fast writes) Thanks, James Briggs. -- Cassandra/MySQL DBA. Available in San Jose area or remote. Mailbox dimensions: 10"x12"x14" From: Robert Coli To: "user@cassandra.apache.org"

Announce: top for Cassandra - cass_top

un it anywhere nodetool works - uses minimal screen real estate, so several rings can fit on one monitor - free (Apache 2). Please send me your comments and suggestions. The top-like infinite loop is actually a read loop, so adding a few more features like cfstats or flush would be easy. Enjoy,

Re: backport of CASSANDRA-6916

Paulo: Out of curiosity, why not just upgrade to 2.1 if you want the new features? You know you want to! :) Thanks, James Briggs -- Cassandra/MySQL DBA. Available in San Jose area or remote. From: Robert Coli To: "user@cassandra.apache.org&qu

Re: Blocking while a node finishes joining the cluster after restart.

Hi Robert. I just did a test (shutdown all nodes, start one non-seed node.) You're correct that an old non-seed node can start by itself. So startup scripts don't have to be intelligent, but apps need to wait until there's enough nodes up to serve the whole keyspace: cqlsh:my_keyspace> consis

Re: Blocking while a node finishes joining the cluster after restart.

FYI: OpsCenter has a default of sleep 60 seconds after each node restart, and an option of "drain before stopping." I haven't noticed if they do anything special with seeds. (At least one seed needs to be running before you restart other nodes.) I wondered the same thing as Kevin and came to th

Re: C 2.1

it's been done, but most of the apps written for C* are greenfield or v2.0 rewrites. Thanks, James Briggs -- Cassandra/MySQL DBA. Available in San Jose area or remote. From: Ram N To: user Sent: Monday, September 15, 2014 1:34 PM Subject: Re: C

Re: C 2.1

u can read my blog post which is a quick way to get up to speed with CQL: Notes on “Getting Started with Time Series Data Modeling” in Cassandra http://jbriggs.com/blog/2014/09/notes-on-getting-started-with-time-series-data-modeling-in-cassandra/ Thanks, James Briggs -- Cassandra/MySQL DBA. Availab

Re: hardware sizing for cassandra

suming and hard with more than 400 GB per node. c) Are you planning to delete data? If so, that's harder to manage. Other than that, the previous comments on RAM are pretty accurate. I would want more cores with vnodes to do more parallel operations. Thanks, James Briggs. -- Cassandra/MySQL D

Re: cassandra on own distributed network

't do what you're describing. You could setup a test cluster and see what the actual latency is. Most people use 4 nodes per POP with NetworkTopologyStrategy (NTS)for a multi-DC setup with RF=3. Thanks, James Briggs -- Cassandra/MySQL DBA. Available in San

Re: Cassandra JBOD disk configuration

r data size is small compared to the disk size, then it might be ok for you. Thanks, James Briggs. From: Chris Lohfink To: user@cassandra.apache.org Sent: Tuesday, September 9, 2014 12:14 PM Subject: Re: Cassandra JBOD disk configuration It can get really