InMobi が ClickHouse で実現したクエリ20倍高速化と80%のコスト削減

InMobi, a leader in ad tech, optimized its real-time ad reporting API by transitioning from a serverless warehouse to ClickHouse, drastically reducing P99 latency from over 60 seconds to under 3 seconds and cutting monthly costs by 80% from $40,000 to $8,000. This move enabled the system to handle over 400,000 queries daily on 10TB of data, providing a robust and cost-efficient analytical platform that supports InMobi's growth and offers rapid insights into ad performance across various dimensions like device and region. Originally established in India in 2007, InMobi connects over 30,000 brands and publishers to more than 2 billion people in 150 countries, processing around 250 billion ad requests and 30 billion events daily. The "Project Velocity" initiative, presented by engineers Anand Tirthgirikar and Amber Vaid, demonstrated how ClickHouse improved query performance threefold, achieving a 5:1 compression ratio and reducing scanned rows by 70%, all while maintaining strict SLAs. Challenges such as atomic ingestion, concurrent connection limits, and ensuring zero downtime were addressed by implementing a staging-validation-production pattern, asynchronous connection management, and an automatic fallback system. The success of Project Velocity not only enhanced publisher reporting but also established a reusable analytical framework across the company, allowing InMobi's developers to easily leverage ClickHouse's capabilities without deep technical knowledge.