4 ms·
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 pe
by superlupo 6y 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.
- gorkemcetin 6y agoCountly can do that, and much, much more.
- foxhill 6y ago> I can't imagine systems with MySQL/PostgreSQL as database can handle this. out of curiosity, why so?
- AlfeG 6y ago500 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
- rsa25519 6y 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.
- superlupo 6y agoYes, 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.
- shermozle 6y agoSnowplow. 500 million events a month is nothing.