Cloud CIRCUSがClickHouseを使用してログ分析をシンプルかつ高速化

Cloud CIRCUS, a SaaS company based in Tokyo, enhances business marketing efficiency in Japan with digital tools, including the CMS platform BlueMonkey, which hosts over 2,000 websites on AWS. Due to the increasing volume of access logs generated by CloudFront distributions, the company faced challenges with Amazon Athena's slow query performance and high costs. To address this, infrastructure engineer Zhu Jiulin presented a solution at the 2025 ClickHouse Tokyo meetup, where Cloud CIRCUS transitioned to ClickHouse for log analysis. The self-managed, open-source ClickHouse system enabled faster, more cost-effective data processing by consolidating logs into a single table and automating the import pipeline with Amazon EventBridge and ECS. This switch resulted in significant performance improvements, reducing query times from 16 seconds with Athena to 0.043 seconds with ClickHouse, while also lowering monthly costs to approximately $300. The transition allowed Cloud CIRCUS to support thousands of customer websites efficiently and scale its operations to meet growing traffic demands, offering a streamlined and cost-predictable analytics solution.

No tracked trend matches for this post yet.