
One of the quiet lies of self-hosted @ClickHouseDB is that your hot data lives on your hardware. Your backups and cold partitions usually live on AWS S3, and AWS charges $0.09/GB to read your own bytes back.
A 500 TB restore costs tens of thousands of dollars. That's why nobody tests their backups, and the first real test happens mid-outage.
It's really a simple solution.....BACKUP TO S3 and TTL tiering are stock ClickHouse features. Point them at a bucket that doesn't charge egress and the scariest line item in your DR plan drops to zero.
tigrisdata.com/blog/clickhous…
English




