Re: Cassandra vnodes Streaming Reliability Calculator

2019-02-16 Thread James Briggs
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 Sent: Saturday,

Cassandra vnodes Streaming Reliability Calculator

2019-02-15 Thread James Briggs
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

2018-11-19 Thread James Briggs
://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 Briggs

Re: Jepsen testing

2018-11-13 Thread James Briggs
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

2018-08-20 Thread James Briggs
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

Re: Cassandra Needs to Grow Up by Version Five!

2018-02-19 Thread James Briggs
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:

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

2017-11-06 Thread James Briggs
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)

2017-11-04 Thread James Briggs
> 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

Re: Indexes Fragmentation

2014-09-30 Thread James Briggs
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/cassandra-top

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

2014-09-19 Thread James Briggs
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: Les

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

2014-09-19 Thread James Briggs
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 bur...@spinn3r.com To: user@cassandra.apache.org user@cassandra.apache.org; James

Re: what's cool about cassandra 2.1.0?

2014-09-19 Thread James Briggs
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 Briggs

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

2014-09-16 Thread James Briggs
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

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

2014-09-16 Thread James Briggs
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

Re: backport of CASSANDRA-6916

2014-09-16 Thread James Briggs
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 rc...@eventbrite.com To: user

Announce: top for Cassandra - cass_top

2014-09-16 Thread James Briggs
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, James

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

2014-09-16 Thread James Briggs
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: 10x12x14 From: Robert Coli rc...@eventbrite.com To: user@cassandra.apache.org user

Re: C 2.1

2014-09-15 Thread James Briggs
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. Available

Re: C 2.1

2014-09-15 Thread James Briggs
for C* are greenfield or v2.0 rewrites. Thanks, James Briggs -- Cassandra/MySQL DBA. Available in San Jose area or remote. From: Ram N yrami...@gmail.com To: user user@cassandra.apache.org Sent: Monday, September 15, 2014 1:34 PM Subject: Re: C 2.1 Jack

Re: Cassandra JBOD disk configuration

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

Re: cassandra on own distributed network

2014-09-09 Thread James Briggs
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 Jose area or remote

Re: hardware sizing for cassandra

2014-09-09 Thread James Briggs
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 DBA. Available in San Jose area