Using ClickHouse to scale an events engine

Re:Using ClickHouse to scale an events engine by zX41ZdbW on Thursday April 11, 2024 @03:54PM (#40006130)

Interesting about "Timeouts (only 30s???)" - most likely, this is a limitation configured explicitly for a user on your server. You can set it up with the `max_execution_time`, and by default, it is unlimited.

For example, I've set it up, along with many more limitations for my public playground https://play.clickhouse.com/, and it allows me to, at least, make it public and not worry much.

It could also be a configuration of a proxy if you connect through a proxy. ClickHouse has built-in HTTP API, so you can query it directly from the browser or put it behind Cloudflare, etc... Where do you host ClickHouse?

[ Parent | on HN ]

Re:Using ClickHouse to scale an events engine by joshstrange on Thursday April 11, 2024 @04:00PM (#40006204)

I can believe it's a config issue, I'll have to look into it. I didn't setup the cluster/dbs and when I asked about I was told "use the cli". I'll try to see if I can get that fixed.

[ Parent | on HN ]

Re:Using ClickHouse to scale an events engine by michaelbuckbee on Thursday April 11, 2024 @10:47PM (#40008947)

Any chance you CH is proxied through a Heroku app? Heroku has 30s timeouts.

[ Parent | on HN ]