3 ms·
You can also keep persistent connections with HTTP to avoid the overhead, which is what Tinybird does. (I used to work there)
by eclbg 21d ago
You can also keep persistent connections with HTTP to avoid the overhead, which is what Tinybird does. (I used to work there)
- solatic 20d agoBut ClickHouse has its own concept of sessions that is completely independent of HTTP: https://clickhouse.com/docs/concepts/features/interfaces/http#using-clickhouse-sessions-in-the-http-protocol https://clickhouse.com/docs/concepts/features/interfaces/htt... If you throw something like nginx in front to try to better guarantee the "balance" part of load balancing, as an improvement over TCP connections that are sticky to the initial server they reach, then you're asking different CH servers to handle the same original session. So what did the load balancer give you? Now, CH added session-aware routing for the HTTP client... but it's a beta feature, and it requires an Enterprise license anyway: https://clickhouse.com/docs/products/cloud/features/infrastructure/replica-aware-routing https://clickhouse.com/docs/products/cloud/features/infrastr... Why go against the tide?