# How LINE MANGA used ClickHouse to enable real-time analysis without moving a single row

DevFeed: [How LINE MANGA used ClickHouse to enable real-time analysis without moving a single row](<https://devfeed.tech/articles/how-line-manga-used-clickhouse-to-enable-real-time-analysis-without-moving-a-single-row-5384.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/line-manga>)

Author: ClickHouse

Published: 2025-06-16T00:00:00Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [data](<https://devfeed.tech/topics/data.md>), [Back end](<https://devfeed.tech/topics/backend.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [backend](<https://devfeed.tech/tags/backend.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [databases](<https://devfeed.tech/tags/databases.md>), [integration](<https://devfeed.tech/tags/integration.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [real-time](<https://devfeed.tech/tags/real-time.md>)

## AI overview

LINE MANGA used ClickHouse to query its sharded MySQL data directly for real-time analysis, avoiding data movement and reducing reliance on custom scripts.

## Source excerpt

"We rely on numerous MySQL servers but faced challenges with real-time analysis. Before introducing ClickHouse, we relied on custom scripts for each analysis. This was difficult to develop and review, and execution was slow. ClickHouse's integration engin