Upgrading the Tanzu SQL for Kubernetes Operator

This topic describes how operators upgrade the VMware Tanzu™ SQL with MySQL for Kubernetes Operator.

Use the Helm CLI to Upgrade the Operator

To upgrade Tanzu MySQL for Kubernetes, you must download resources and upgrade the Tanzu MySQL for Kubernetes Operator using Helm.

To upgrade the Operator using the Helm CLI:

Set the environment variable to enable OCI support in the Helm v3 client by running:
```
export HELM_EXPERIMENTAL_OCI=1
```
If you skip this step, the following error message might appear: Error: this feature has been marked as experimental and is not enabled by default.
Use Helm to log in to the Tanzu Network Registry by running:
```
helm registry login registry.tanzu.vmware.com
```
Follow the prompts to enter the email address and password for your VMware Tanzu Network account.

Verify that you have a running Tanzu MySQL for Kubernetes Operator by running:

helm -n tanzu-mysql-for-kubernetes-system ls

For example:

helm -n tanzu-mysql-for-kubernetes-system ls
NAME                    NAMESPACE                               REVISION        UPDATED                                 STATUS          CHART                                   APP VERSION
tanzu-mysql-operator    tanzu-mysql-for-kubernetes-system       1               2021-04-01 12:15:07.16966 -0500 CDT     deployed        tanzu-sql-with-mysql-operator-1.0.0     1.0.0

Download the Helm chart to your current working directory on your local machine by running these commands:
```
helm chart pull REGISTRY-URL
```
```
helm chart export REGISTRY-URL
```
Where REGISTRY-URL is the reference to the Tanzu MySQL for Kubernetes Helm chart. The value of REGISTRY-URL has the following pattern:
```
registry.tanzu.vmware.com/tanzu-mysql-for-kubernetes/tanzu-mysql-operator-chart:VERSION-NUMBER-TAG
```
Where VERSION-NUMBER-TAG is the version of the Helm chart.

This downloads a directory named tanzu-sql-with-mysql-operator/ into your current working directory
Go to where the new release has been downloaded and apply the new CRDs by running:
```
kubectl apply -f ./tanzu-sql-with-mysql-operator/crds/
```
Note: You can ignore the warnings in the output.

Upgrade the Operator by running:

helm upgrade tanzu-mysql-operator ./tanzu-sql-with-mysql-operator

When you see deployed in the STATUS column, the Tanzu MySQL for Kubernetes Helm chart has upgraded:

helm -n tanzu-mysql-for-kubernetes-system history tanzu-sql-with-mysql-operator

REVISION    UPDATED                     STATUS        CHART                                  APP VERSION    DESCRIPTION
1           Thu Jan 14 17:47:53 2021    superseded    tanzu-sql-with-mysql-operator-1.0.0     1.0.0          Install complete
2           Thu Jan 14 18:09:05 2021    deployed      tanzu-sql-with-mysql-operator-1.0.1     1.0.1          Upgrade complete