ClickhouseProblem & solution
How Musinsa scaled its audience engine with ClickHouse Cloud and reduced TCO by 71.4%
Summary
Musinsa’s Audience Engine powers a customer data platform that targets audiences across 16.4 million members. It stores each user-to-audience relationship as a separate row, producing roughly 1.1 billion cohort-to-user mappings across 2,500 audiences and potentially 16 million new rows when one audience is added. Its self-hosted ClickHouse deployment coupled storage and compute, forced workloads to share a cluster, and created operational burdens as data and query demands grew. Musinsa migrated to ClickHouse Cloud on AWS, using separated S3-backed storage, workload-specific compute, automatic idling, vertical autoscaling, and ClickPipes for direct real-time ingestion. The company reports an 86.5% reduction in storage costs and a total cost of ownership reduction of up to 71.4%, while shifting engineering effort toward CDP business logic.
Context
Musinsa’s Audience Engine had to scale as its CDP served 16.4 million members and maintained roughly 1.1 billion cohort-to-user mappings. Its self-hosted ClickHouse deployment tied EBS storage to compute, required multiple workloads to share a cluster, made heavy queries disruptive, and imposed increasing infrastructure-management overhead.
Approach / What changed
Musinsa migrated from self-hosted ClickHouse to ClickHouse Cloud in the AWS Seoul region. The cloud setup separates compute from shared Amazon S3 storage, assigns resources by workload, uses automatic idling and vertical autoscaling, and replaces Databricks Auto Loader on an external Spark cluster with ClickPipes for direct real-time ingestion into ClickHouse Cloud.
Takeaways
Musinsa’s exploded audience representation contains roughly 1.1 billion cohort-to-user mappings across more than 16 million users and 2,500 audiences.
Separating compute from shared S3 storage let Musinsa scale storage independently, avoid adding unnecessary storage when adding compute, and reduce existing storage costs by 86.5%.
ClickPipes replaced Databricks Auto Loader on an external Spark cluster, simplifying direct real-time ingestion and reducing operational overhead and Databricks costs.
Source and freshness
- Source
- clickhouse.com
- Published
- Added to Yomu
- Last updated
Summaries are generated from the original by a language model. Check the original before relying on it.
Keep reading
Related reading
The Good Stuff
Paid picks we use ourselves. Links carry a referral code — a subscription through one earns us a commission at no extra cost to you.
The best engineering reads, once a week
One useful email. Unsubscribe anytime.