Hello, I am trying to deploy MySQL 8 using the Kubernetes Operator (v1.7.0), but I cannot get it to run properly. After I kubectl apply my cluster-cr.yaml, The first database pod (cluster1-pxc-0) spins up and with
cat /var/lib/mysql/grastate.dat inside the container can I see that
safe_to_bootstrap is set to 1. After the first pod is successfully deployed, the second pod (cluster1-pxc-1) spins up and the
safe_to_bootstrap value of
cluster1-pxc-0 turns to 0. After the second pod is ready, a third pod spins up, and I end up with 3 nodes with
safe_to_bootstrap: 0, which to my understanding means the cluster is not functional, as there is no replication between the nodes.
I played this through several times, with fresh nodes & volumes, I always get the same result.
This also shows in the backups, which fail similarly to the issue shown in this thread. In fact, I can also see that all 3 nodes are in “Donor/Desynced:” state.
When I describe my cluster crd, I see:
My cr.yaml is pasted here.
If anyone can give me a hint what I might be doing wrong, I would be very happy!