Join Alkin Tezuysal's session "Unified Observability: Leveraging ClickHouse as a Comprehensive Telemetry Database" at #FOSSASIASummit2025 to learn how #ClickHouse simplifies observability, giving engineers deep system insights while minimizing infrastructure complexity.

Click here https://youtu.be/sCRXGqOPtOU?si=lWcjSCpKkuD_gLHW to watch on the FOSSASIA YouTube channel.

Unraveling the Mystery of CPU Spikes in ClickHouse Cloud: A Deep Dive into Linux Kernel Debugging

A perplexing CPU spike in ClickHouse Cloud led to an extensive investigation, revealing a hidden bug in the Linux kernel's memory management. This article chronicles the journey through kernel interna...

https://news.lavx.hu/article/unraveling-the-mystery-of-cpu-spikes-in-clickhouse-cloud-a-deep-dive-into-linux-kernel-debugging

Telescope – an open-source web-based log viewer for logs stored in ClickHouse — https://github.com/iamtelescope/telescope
#HackerNews #Telescope #ClickHouse #OpenSource #LogViewer #WebApp

(excellent #observability talk at FOSDEM using #clickhouse for observability - basically pretty much what I'm doing atm :))

looking forward to tomorrow's #clickhouse for #observability talk because that's precisely what I'm having and doing https://fosdem.org/2025/schedule/event/fosdem-2025-5960-o11y-in-one-exploring-a-unified-telemetry-database/

interestingly #bluesky seems to have an #sqlite db per user as mentioned in this article about how they use #clickhouse https://clickhouse.com/blog/building-a-medallion-architecture-for-bluesky-json-data-with-clickhouse

TIL about #clickhouse local and tried out with JSON #zeek data as I'd been doing with #duckdb https://gist.github.com/mdfranz/55c9d0f4a4a2f58acbc57144628ac1dc

Modern Database Architecture: #Cloud Storage Evolution

#ZeroDisk architecture leverages #AWS #S3 as primary storage, eliminating need for traditional disk management

#Database systems gain instant scalability and elasticity through separation of compute and storage

New approach enables three deployment options:
- Direct #S3 writes
- #S3Express as cache layer
- #Raft cluster with S3 backend

Major platforms adopting this architecture:
#Snowflake, #Clickhouse, #Neon, #TiDB

Trade-offs balance between latency, cost, and durability metrics

Benefits include serverless operation, instant failover, and unlimited storage capacity

https://avi.im/blag/2024/zero-disk-architecture/

fourth #clickhouse cluster in the making it's called sadhouse because it's for broken stuff (which is actually not easy to process) and hooked the fifth team on it to give it a serious try themselves.

All benchmarks are liars.

Also, here’s a set of db benchmarks from #clickhouse:

https://benchmark.clickhouse.com/

Various DBs including:
- #mysql
- #postgres
- #sqlite
- #timescaledb
- #alloydb
- #mariadb

spending the week counting stuff to once and for all answer ALL of the "how many" and "how often" and "how big" and the group noun for #clickhouse is of course block and not cluster

(I'm taking bets that I can build this based on SQLite if I set my mind to it I learned a lot of creative database stunts at #postgres meetups and now from #clickhouse and I'm telling you folks a database is a framework to be used to build platforms not to just passively sit there in a corner hidden behind a cache databases aren't some mimimi :)

200 mio rows in my toy #clickhouse feeding on my prod #kafka for 8 months now without fail

b. pointed me to crossplane let's see if I can build a local #crossplane thing to deploy a #clickhouse into my local infra :)

So, it feels like it's time for an #introduction

So, I am a former #sysadmin from #yandex and #innogames, now an infrastructure engineer at #ClickHouse. It's my private account for anything, and I have another one for the technical stuff, @ClickHouseCI

I live in #Hamburg #Germany for 6 years so far, and my wife and I have the best two girls.

Passionate about #technology, #OSS, and #Linux.

I don't think I ever did an #introduction!

Hi, I'm brad. I work in tech doing #clickhouse, #k8s, #perl, #security, #ansible, #o11y, and more. I was diagnosed at 41yrs old with #ADHD explaining so many things in my life! I managed to #burnout hard in 2018 and 2024 and am still actively working to maintain my mental health.

I am learning to #sail with my wife. I spend my nights and weekends with my wife and #dogs. I am the Lead Mechanic and a board member for https://badbusinessbikes.org #bikes, #community