In this tutorial video, we will highlight the crucial role of sharding and partitioning in storing time series data using CrateDB. We will demonstrate how partitioning subdivides data into smaller, more manageable pieces, improving read and write performance. We will also discuss sharding, a strategy that distributes data horizontally across multiple nodes to enhance the speed of queries and updates.
00:00 - Introduction
00:23 - Partitioning
02:19 - Sharding
04:26 - Replication
05:21 - Implementing Partitioning & Sharding
06:53 - Effective Sharding for Time Series Use Cases
09:58 - Replication and High Availability