How We Stopped Our ClickHouse DB From Exploding
Read about how Dittofeed, an Altinity.Cloud customer, is using ClickHouse as their primary store of user events and to calculate live user segments.
Momentum Dash is Building a More Centered Work Environment with PostHog and Altinity
Momentum Dash uses PostHog and Altinity to understand the needs of their two million users. Read how ClickHouse analytics drive product development.
Real-time, Exactly-once Data Ingestion from Kafka to ClickHouse at eBay
eBay depends on Kafka to solve the impedance mismatch between rapidly arriving messages in event streams and efficient block insert into ClickHouse clusters. Naïve loading procedures from Kafka to ClickHouse generate non-deterministic blocks, leading to data loss and incorrect results…
Analytics That Really Bring the Heat
Read why and how Pepper.com, the largest shopping community, chose ClickHouse over BigQuery to provide personalized customer experiences to 25 Million+ shoppers.
ClickHouse at LifeStreet: Performance Marketing is as Strong as Your Data Platform
We live in a rapidly changing world. The ability to discover and apply business-critical insights from petabyte datasets in real-time is now a key factor in many businesses. Digital marketing is no exception. In fact, digital marketing is now one…
ClickHouse Cost-Efficiency in Action: Analyzing 500 Billion Rows on an Intel NUC
Jan 1, 2020Cost-efficiency and performance are critical for big data analytics. For this reason a recent blog post from ScyllaDB guys caught our attention. They collected over 500 billion data points and were able to query it with 1B rows/sec…
Case Study. AfterWords – Intelligent Customer Engagement
Aug 1, 2018AfterWords is an intelligent customer engagement and survey system that delivers users transactional history and customer feedback to create actionable data to improve operations, sales and profitability. In this article, our guest author Oleg Khozyainov shares his experience…
ClickHouse and ProxySQL queries rewrite
ProxySQL is a popular open source, high performance and protocol-aware proxy server for MySQL and its forks. Since September 2017 ProxySQL supports ClickHouse as a backend, so clients can connect to ClickHouse via MySQL protocol. In practice, this helps MySQL-aware…
Realtime replication from MySQL to ClickHouse in practice
July 2, 2018Vladislav Klimenko from Altinity and Valery Panov from Ivinco presented a talk at HighLoad Siberia 2018 conference recently. They described the real problem that Ivinco faced and how it has been solved with migration of analytics from MySQL…
Big Data Analysis in Digital Marketing Research
Dec 6, 2017Christian Hotz-Behofsits, Teaching & Research Associate at Vienna University of Business and Economics, is one of the creators of RClickhouse package for R that we have recently introduced on our blog. In this article he describes data analysis…