ClickHouse Cloud: Gumlet’s key to processing billions of video and image requests daily

Gumlet, a media hosting and streaming solution, handles over 2 billion video and image requests daily, serving more than 100 million users per day. The platform tracks various metrics like playback time, rebuffer rates, and bandwidth usage to fine-tune performance and keep users engaged. However, managing insights across 900 billion rows of data became a costly and complex challenge as the company scaled. Initially relying on BigQuery, Gumlet faced issues with spiraling costs, query limits, and storage costs due to its pricing model. After evaluating alternatives, they opted for ClickHouse Cloud, which offered scalable storage, predictable costs, and excellent performance. The migration required redesigning their ingestion process, taking advantage of built-in integrations, and using materialized views to pre-aggregate data for common analytics requests. By migrating to ClickHouse, Gumlet achieved cost predictability, improved ingestion speed, rapid response times, and simplified operations.