Cassandra consulting · Redshots blog
Redshots blog
Practical write-ups on tuning, data modelling, repairs, upgrades and moving clusters without downtime, from nearly a decade of running Apache Cassandra at scale.
Need a hand with your cluster?
Fractional Cassandra support for smaller teams. Health Checks from £3,950 (ex VAT).
When I have had to investigate a slow node in production, the metrics and logs only take me so far. They show that latency has gone up, but not what the threads inside Cassandra are doing at the time. To answer that…
I have now had a chance to experiment with the Cassandra Auto Repair setup, I have been using Cassandra 6 alpha for this, but it should be the same in Cassandra 5.0.8. Here are some of my observations. 1) You can setup…
Cassandra 5.0.8 was released on Friday, I think, as far as a Cassandra operator is concerned, it is the most significant minor release for many years. Cassandra now has repairs build into the individual nodes, in the form of auto repairs. This…
I have been trying to test the new Cassandra 6 alpha release for the last few days, but have been a bit stuck. Firstly I encountered some issues running multiple nodes within one machine, TCM does not seem to like that and…
The Last Pickle did a great blog post on TWCS a little while ago, explaining how Time Window Compaction is great for certain time series data. To recap TWCS is suitable for Data should only be inserted and not updated afterwards Data…
This is a post to go with a recent presentation at the Datastax Accelerate conference, and describes the process used to move clusters from Rackspace to Google cloud. In part 1 we looked at setting up the new datacenter and migrating the…
In part 1 we successfully migrated the data within the cluster to a second datacenter, completing this without downtime to the cluster. Now we will look at decommissioning the original RS_UK datacenter. Firstly we need to ensure all the applications are now…
This is a post to go with a recent presentation at the Datastax Accelerate conference, and describes the process used to move clusters from Rackspace to Google cloud. Our requirement was to move multiple clusters, but one at a time, from the…
Recently I have needed to track down what queries were being run against a cluster. We were needing queries to be run with a consistency of LOCAL_QUORUM but it appeared that some where being run with QUORUM instead. So I needed to…
Recently I was looking at the performance of a cluster, and discovered the development team were performing a lot of count(*) additional on a specific table. This was quite easy to spot as it was a Datastax cluster and the queries were…