https://questdb.io logo
Title
b

Brandon E.

03/13/2023, 3:24 PM
Hi all, the questdb kubernetes is able to allocate more than one pod?
j

javier ramirez

03/13/2023, 4:52 PM
As of today QuestDB scales only vertically and it doesn’t support horizontal scalability/read replicas just yet. That is true no matter if you are running on a physical server, a virtual machine, or a container. For now it is only one pod https://github.com/questdb/questdb-kubernetes/blob/master/charts/questdb/templates/statefulset.yaml#L8
b

Brandon E.

03/13/2023, 5:10 PM
So it means that I need to deploy 2 servers to use 2 pods? (not a k8s expert here sorry)
j

javier ramirez

03/13/2023, 5:35 PM
But then you would be using different instances. Why do you want to use 2 pods?
b

Brandon E.

03/13/2023, 5:40 PM
I was wondering if it can improve handling multiple connections at the same time (longer ones), when downloading data from questdb I am running a parallel process
j

javier ramirez

03/14/2023, 9:18 AM
Unfortunately at this point you wouldn’t be able to do that, as what you are describing is a read-replica set up, which will be available later this year. As of today the way to achieve better performance on reads is to increase the number of CPUs, so the shared workers pool/http workers pool will have more capacity to process things in parallel. Or if you see the bottleneck is memory or disk throughput, adding some extra capacity there
b

Brandon E.

03/14/2023, 9:29 AM
So would u recommend using K8s, or due to the limitations going to a simple instance is better by now?
j

javier ramirez

03/14/2023, 9:53 AM
Same limitations on Kubernetes than on an instance running on a virtual machine. A database = an installation
Many questdb users run happily on docker containers, many run happily on docker containers orchestrated by K8s, and many run happily on virtual machines or dedicated hardware. It is really up to you, but in all cases you scale vertically rather than horizontally as of today
b

Brandon E.

03/14/2023, 10:30 AM
Ok, got it, is horizontal scaling in the roadmap?
j

javier ramirez

03/14/2023, 10:55 AM
Yes it is. Release 7.0 introduced WAL tables, which were the mandatory intermediate step towards replication. We hope to have read replication ready in the next few months
b

Brandon E.

03/14/2023, 12:27 PM
Oh ok, good to know, thank you for your help @javier ramirez!
By the way, last question, for the kubernetes ingress you are using Haproxy too?
j

javier ramirez

03/14/2023, 3:28 PM
On the repository I see the default value is using no ingress at all, and there is some commented out code in case you want to add a specific ingress, like nginx. But no, no Haproxy config provided in that helm chart https://github.com/questdb/questdb-kubernetes/blob/master/charts/questdb/values.yaml
b

Brandon E.

03/14/2023, 3:38 PM
Ok got it, i thought you were using haproxy for k8s too
Well it makes sense since for kubernetes there is SSL termination support for TCP using ngnix