Real-time, Exactly-once Data Ingestion from Kafka to ClickHouse at eBay

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.

Case Study. AfterWords – Intelligent Customer Engagement

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

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…