# loadBalancerIP being ignored for proxysql when applying cr.yaml change for xtradb operator 1.13.0

**URL:** <https://forums.percona.com/t/loadbalancerip-being-ignored-for-proxysql-when-applying-cr-yaml-change-for-xtradb-operator-1-13-0/25874>\
**Category:** Percona Operator for MySQL\
**Created:** [October 12, 2023, 6:20pm UTC](https://forums.percona.com/t/loadbalancerip-being-ignored-for-proxysql-when-applying-cr-yaml-change-for-xtradb-operator-1-13-0/25874 "2023-10-12T18:20:44Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![jeff.plewes](https://avatars.discourse-cdn.com/v4/letter/j/7bcc69/32.png) [@jeff.plewes](https://forums.percona.com/u/jeff.plewes)\
**Post date:** [October 12, 2023, 6:20pm UTC](https://forums.percona.com/t/loadbalancerip-being-ignored-for-proxysql-when-applying-cr-yaml-change-for-xtradb-operator-1-13-0/25874/1 "2023-10-12T18:20:44Z")

</div>

## Description:

When applying a change to cr.yaml using operator 1.13.0 it appears that the loadBalancerIP is ignored. The field does not get applied to the spec within the PerconaXtraDBCluster object, but it does list it within the “[kubectl.kubernetes.io/last-applied-configuration](http://kubectl.kubernetes.io/last-applied-configuration)” metadata on the object.

This behaviour started to appear once applying taint tolerances to proxysql. Not exactly sure if adding this config conflicts with loadbalancerip logic. removing the taint tolerances has no impact.

## Steps to Reproduce:

- edit cr.yaml for an existing cluster deplyoment.
- add a loadBalancerIP value to proxysql
- apply the cr.yaml to the cluster

## Version:

1.13.0

## Logs:

## Expected Result:

The proxysql service should be assigned the loadBalancerIP specified in the cr.yaml

## Actual Result:

The result is the LoadBalancer service picks another IP address from the pool vs the static IP specified.

## Additional Information:

- EKS Anywhere platform, cilium 1.12.11
- metallb controller 0.13.11

---

<div class="post-metadata">

**Author:** ![jeff.plewes](https://avatars.discourse-cdn.com/v4/letter/j/7bcc69/32.png) [@jeff.plewes](https://forums.percona.com/u/jeff.plewes)\
**Post date:** [October 12, 2023, 6:32pm UTC](https://forums.percona.com/t/loadbalancerip-being-ignored-for-proxysql-when-applying-cr-yaml-change-for-xtradb-operator-1-13-0/25874/2 "2023-10-12T18:32:22Z")

</div>

Please ignore… CRD version mismatch.

---

<div class="post-metadata">

**Author:** ![Sergey\_Pronin](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sergey_pronin/32/14887_2.png) [@Sergey\_Pronin](https://forums.percona.com/u/Sergey_Pronin)\
**Post date:** [October 17, 2023, 8:06am UTC](https://forums.percona.com/t/loadbalancerip-being-ignored-for-proxysql-when-applying-cr-yaml-change-for-xtradb-operator-1-13-0/25874/3 "2023-10-17T08:06:03Z")

</div>

@jeff.plewes hey, great you resolved it. Could you please elaborate on what went wrong? I’m thinking about how we can enforce some behavior to avoid this situation.

---

<div class="post-metadata">

**Author:** ![jeff.plewes](https://avatars.discourse-cdn.com/v4/letter/j/7bcc69/32.png) [@jeff.plewes](https://forums.percona.com/u/jeff.plewes)\
**Post date:** [October 17, 2023, 11:56am UTC](https://forums.percona.com/t/loadbalancerip-being-ignored-for-proxysql-when-applying-cr-yaml-change-for-xtradb-operator-1-13-0/25874/4 "2023-10-17T11:56:12Z")

</div>

@Sergey_Pronin

What went wrong is that I had upgraded the operator using the helm chart to 1.13.0 but I missed upgrading the CRDs following that. The CRD upgrade is a manual step.

> **[Percona Operator for MySQL based on Percona XtraDB Cluster - Upgrade Database...](https://docs.percona.com/percona-operator-for-mysql/pxc/update.html#upgrade-via-helm)**
>
> Starting from the version 1.1.0, Percona Operator for MySQL based on Percona XtraDB Cluster
> allows upgrades to newer versions. The upgradable components of the cluster are
> the following ones:

---

<div class="post-metadata">

**Author:** ![Sergey\_Pronin](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sergey_pronin/32/14887_2.png) [@Sergey\_Pronin](https://forums.percona.com/u/Sergey_Pronin)\
**Post date:** [October 17, 2023, 3:00pm UTC](https://forums.percona.com/t/loadbalancerip-being-ignored-for-proxysql-when-applying-cr-yaml-change-for-xtradb-operator-1-13-0/25874/5 "2023-10-17T15:00:34Z")

</div>

@jeff.plewes thanks! Yeah, it is coming from a helm chart limitation. Glad you solved it.