Re:Building the world’s fastest website analytics (2021)
by dravita on Saturday October 15, 2022 @09:38AM
(#33214700)
That one was tried, among many others covered in the article.
Re:Building the world’s fastest website analytics (2021)
by JackWritesCode on Saturday October 15, 2022 @09:53AM
(#33214839)
Clickhouse isn’t really relevant for a lot of us. SingleStore outperforms clickhouse and the latter isn’t MySQL wire compatible. Far more features come with SingleStore too. And if you speak to people running Clickhouse, they’re also maintaining a Postgres set-up. With SingleStore, you get your OLTP and OLAP in one database. So our users & sites table sit in memory (backed up by disk), meaning ultra fast read/write speeds (comparable to clustered/high availability Redis). And then we put our pageviews/events in columnstore (disk) which offers rapid performance for analytical queries.
Though, I’d be sorely tempted to spin up a bfc of clickhouse on bare metal.