Hacker News new | ask | show | jobs
by superlupo 2134 days ago
Slightly off-topic: Does anyone have recommendations for self-hosted open source analytics that can handle a large volume site (think 500.000.000 impressions per month)? I can't imagine systems with MySQL/PostgreSQL as database can handle this.
4 comments
gorkemcetin 2122 days ago
Countly can do that, and much, much more.
link
foxhill 2134 days ago
> I can't imagine systems with MySQL/PostgreSQL as database can handle this.

out of curiosity, why so?

link
AlfeG 2134 days ago
500 000 000 requests per month is just about 200 request per second. Why there should be any problem for any DB?

As for question - I saw a lot of great reviews on ClickHouse DB

link
rsa25519 2134 days ago
> 500 000 000 requests per month is just about 200 request per second

Not if you assume that some hours will have more web traffic than others.

link
superlupo 2134 days ago
Yes, there are some peaks with 10-20000 per sec.

Clickhouse seems very suitable as database. Does anybody know open source analytics tools that use it? Two parts would be needed: the client javascript tracker which injects into the database, and a GUI for reports.

link
shermozle 2133 days ago
Snowplow. 500 million events a month is nothing.
link