How to use Ingress HAProxy to load balance a SQL Server deployment?

Asking for help? Comment out what you need so we can get more information to help you!

Cluster information:

Kubernetes version: 1.17.5
Cloud being used: (put bare-metal if not on a public cloud) bare-metal
Installation method: Kubespray
Host OS: CentOS 7
CNI and version: Calico
CRI and version: Docker 19.03.8

Hi. So I am new to K8s. I’m trying to Load Balance two MSSQL 2019 pods with an Ingress HAProxy controller. I tried this link: https://www.haproxy.com/blog/dissecting-the-haproxy-kubernetes-ingress-controller/, but no luck.

Is what I’m trying to do reasonable? What is the best practice for loadbalancing MSSQL pods in a deployment?
I was wondering I could get a help here.
Thanks in advance.

MSSQL doesn’t really support load-balacing that way (neither do most databases) whether in a container or just deployed with a straight install on a server. You’ll need to look up general MSSQL best practices for it and see if it can be adapted to a container environment.

1 Like