Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Cassandra Tuning: Getting the Extra 0.999% [Video]

DZone's Guide to

Cassandra Tuning: Getting the Extra 0.999% [Video]

When database tuning, getting consistent results for 99% of Cassandra queries is easy. It's that extra 0.999% that means digging into the guts of your database.

· Database Zone
Free Resource

Learn how to create flexible schemas in a relational database using SQL for JSON.

This September one of our co-founders and senior consultants Matija Gobec held a presentation on Cassandra Summit 2016 about tuning Apache Cassandra for low latency while deployed on AWS.

This is the abstract of the presentation:

There are many aspects of tuning Cassandra for production and a lot can go wrong: network splits and latency, hardware issues and failure, data corruption, etc. Most are mitigated with Cassandra's architecture but there are use cases where we need to dig deep and tune all layers to get the result we need to achieve specific business goals. 

We will explore such case where we had to tune Cassandra for performance but also have consistent results on 99.999% of the queries. Getting even to 99 percent was relatively easy, but pushing those extra nines involved a lot of work. There are many nuts and bolts to turn and tune in order to get consistent results. 

We will cover biggest latency-inducing factors and see how to set up metrics and tackle inevitable issues when doing cloud-based deployments. We will get into one of the major "sins" regarding AWS deployment by demystifying EBS based storage and talk about how we can leverage OS properties while tuning for high read performance.

Here is a link to the video:

And here are the slides.

Create flexible schemas using dynamic columns for semi-structured data. Learn how.

Topics:
apache cassandra ,database performance ,database ,database tuning

Published at DZone with permission of Matija Gobec, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}