João Manso

We are the sum of our actions, and therefore our habits make all the difference - Aristotle

less than 1 minute read

Cassandra is a popular NoSQL database that is designed for large scale data storage and retrieval. One of the key factors that make Cassandra a great choice for large data sets is its partitioning strategy. Partitioning helps to distribute the data evenly across multiple nodes and avoid hotspots, which can result in performance degradation. Here are some thumb rules that can help you design a good Cassandra partition:

  • Choose the right partition key
  • Store together what you retrieve together
  • Make use of clustering columns
  • Avoid big partitions
    • Up to 2 billion cells per partition
    • Up to ~100k rows in a partition
    • Up to ~100MB in a partition
  • Avoid hot partitions
  • Monitor your partitions using tools like nodetool to monitor the data distribution and identify any potential issues.

By following these thumb rules, you can design a good Cassandra partition that will provide fast and reliable data retrieval while avoiding hotspots and performance degradation. With a well-designed partition, you can ensure that your Cassandra cluster is able to handle large data sets and provide fast and efficient data retrieval.

You may also enjoy

CAP theorem

2 minute read

Introduction The CAP theorem, also known as Brewer’s theorem, is a fundamental concept in distributed computing that provides insights into the tradeoffs tha...

Introduction to Big O Notation

4 minute read

Understanding Algorithm Complexity Big O notation is a mathematical tool that allows us to express the time and space complexity of algorithms in a clear and...

Glenn Santos’ Senior Developer Roadmap

less than 1 minute read

If you’re a software developer looking to advance your career to the senior level, you might find Glenn Santos’ Senior Developer Roadmap helpful. This roadm...