Search Articles — Sudonull

Search Results

In this project

MergeTree in ClickHouse: granules, parts, and sparse index

https://sudonull.com/mergetree-in-clickhouse-granules-parts-and-sparse-index

MergeTree structure using a bids table example: part, granule, mark, merge of parts, ORDER BY vs PRIMARY KEY, partitioning, EXPLAIN indexes, partition management.

Redis Lua Queue: partition order and worker pool

https://sudonull.com/redis-lua-queue-partition-order-and-worker-pool

Implementation of Redis queue on Lua for strict order in partitions, shared worker pool, retries. Benchmarks, diagrams, code. For middle/senior dev — study and implement.

Partitioning in ClickHouse: Strategies and Operations

https://sudonull.com/partitioning-in-clickhouse-strategies-and-operations

How partitioning in ClickHouse accelerates DROP and data management. Choosing partition size, system.parts, DETACH/ATTACH, FREEZE, MOVE to SSD/HDD, and a script for deleting old data.

Kafka in Node.js: reliable consumers and scaling

https://sudonull.com/kafka-in-node-js-reliable-consumers-and-scaling

How to properly configure Kafka consumers in Node.js: partitions, offsets, rebalancing, and parallel processing. Practical recommendations for developers.

Trending Now