Stop/Start a MySQL cluster

You can stop/start a cluster to save computing resources. When a cluster is stopped, the computing resources of this cluster are released, which means the pods of Kubernetes are released, but the storage resources are reserved. You can start this cluster again to restore it to the state it was in before it was stopped.

Stop a cluster

Configure the name of your cluster and run the command below to stop this cluster.

Apply an OpsRequest to stop a cluster.

kubectl apply -f - <<EOF
apiVersion: apps.kubeblocks.io/v1alpha1
kind: OpsRequest
metadata:
  name: ops-stop
  namespace: demo
spec:
  clusterName: mycluster
  type: Stop
EOF

kubectl edit cluster mycluster -n demo

Configure replicas as 0 to delete pods.

...
spec:
  clusterDefinitionRef: mysql
  clusterVersionRef: mysql-8.0.33
  terminationPolicy: Delete
  componentSpecs:
  - name: mysql
    componentDefRef: mysql
    disableExporter: true  
    replicas: 0 # Change this value
...

kbcli cluster stop mycluster -n demo

Check the status of the cluster to see whether it is stopped.

kubectl get cluster mycluster -n demo

kbcli cluster list mycluster -n demo

Start a cluster

Configure the name of your cluster and run the command below to start this cluster.

Apply an OpsRequest to start a cluster.

kubectl apply -f - <<EOF
apiVersion: apps.kubeblocks.io/v1alpha1
kind: OpsRequest
metadata:
  name: ops-start
  namespace: demo
spec:
  clusterName: mycluster
  type: Start
EOF

kubectl edit cluster mycluster -n demo

Change replicas back to the original amount to start this cluster again.

...
spec:
  clusterDefinitionRef: mysql
  clusterVersionRef: mysql-8.0.33
  terminationPolicy: Delete
  componentSpecs:
  - name: mysql
    componentDefRef: mysql
    disableExporter: true  
    replicas: 2 # Change this value
...

kbcli cluster start mycluster -n demo

Check the status of the cluster to see whether it is running again.
```
kubectl get cluster mycluster -n demo
```
```
kbcli cluster list mycluster -n demo
```