> 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.
Not if you assume that some hours will have more web traffic than others.
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.