[K8SPG-188] Provide static IP-address for LoadBalancer

[spron-in]

Community Note

• Please vote on this issue by adding a :thumbsup: reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or "me too" comments, they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment

Tell us about the feature

We allow users to expose database clusters and its components through various Service Types, including load balancers.

There is a use case, where user wants to have a static IP-address for the load balancer. This also includes internal load balancers in the clouds.

 

This can be done through loadBalancerIP field. {code:java} spec:   loadBalancerIP: 1.2.3.4   type: LoadBalancer{code}  

• We are going to pass through loadBalancerIP parameter to the service spec.
• If exposeType is not LoadBalancer, we still pass through loadBalancerIP parameter to the spec
• We rely on Kubernetes logic to parse and make a decision about loadBalancerIP valid inputs ** We return the error if service creation fails
• We are not adding loadBanacerIP to pgReplicas exposure, as these are exposed as a service per Pod.
• We are going to introduce loadBalancerIP into the custom resource in the following places:

{code:java} spec: pgPrimary: expose: serviceType: LoadBalancer loadBalancerIP: 1.2.3.4 pgReplicas: expose: serviceType: LoadBalancer pgBouncer: expose: serviceType: LoadBalancer loadBalancerIP: 1.2.3.4 {code}

Link to JIRA