News for hackers. Stuff that matters.
Re:Google Analytics alternative that protects your data and ... by XCSme on Sunday May 14, 2023 @02:38PM (#35940220)
What kind of scale are you looking at?

I'm building UXWizz, which is on the same stack, and in my experience on a single server you can track up to 10-15 million sessions total (~1M sessions per month, with 1 year retention). To scale, for now I made it so you can have one database per domain, so the data is sharded by domain (if you are tracking multiple domains).

The biggest bottleneck is querying a large dataset, the storing of data seems to work pretty well. You could of course archive the data and automatically create stats using cron jobs, but this leads to a lot less filtering options and not so fresh data.

Re:Google Analytics alternative that protects your data and ... by jhpacker on Wednesday May 17, 2023 @03:55AM (#35972424)
The scaling issues I'm talking about are on the reporting side, not the measurement side. With Clickhouse you can do complex analytics queries on live data, with MySQL as you say you may need to pre-gen with cronjobs, etc.
Re:Google Analytics alternative that protects your data and ... by XCSme on Wednesday May 17, 2023 @05:24PM (#35981437)
Makes sense. My question was what magnitude of data amount are we talking about? Because for the average website, receiving less than 100k monthly session, a single MySQL instance is more than enough for real-time queries in sub-100ms query times.