Rebalancing thousands of tenants across ClickHouse shards without zero-copy replication
After two years of manual ClickHouse shard migrations, we tried an experiment: cold data in S3 as pointer files. Moving 5 days of a tenant meant copying 7.7 KB instead of 13 MB.