https://www.percona.com/doc/kubernetes-operator-for-pxc/pause.html
Pause/resume Percona XtraDB Cluster
Pause/resume Percona XtraDB Cluster
www.percona.com
Pause - DB Cluster 를 일시중지해야할일이 있을경우 사용
기본 설치값은 false 로 되어있음
values.yaml -> 설치파일
...
pause: false
...
./templates/cluster.yaml -> Cluster CR 정의 파일
pause: {{ .Values.pause }}
### CR 편집
kubectl edit perconaxtradbclusters.pxc.percona.com
pause: false -> pause: true
$ kubectl get pod
NAME READY STATUS RESTARTS AGE
my-db-pxc-db-pxc-0 3/3 Running 0 12d
my-db-pxc-db-pxc-1 3/3 Running 0 12d
my-db-pxc-db-pxc-2 3/3 Running 0 12d
my-op-pxc-operator-7578776fd6-ttms8 1/1 Running 0 12d
testpod1 1/1 Running 0 12d
testpod2 1/1 Running 0 12d
testpod3 1/1 Running 0 12d
xb-cron-my-db-pxc-db-fs-pvc-2022611000-372f8-m7v75 0/1 Completed 0 4d6h
xb-cron-my-db-pxc-db-fs-pvc-2022612000-372f8-ws9x9 0/1 Completed 0 3d6h
xb-cron-my-db-pxc-db-fs-pvc-2022613000-372f8-tdtcm 0/1 Completed 0 2d6h
xb-cron-my-db-pxc-db-fs-pvc-2022614000-372f8-nld5t 0/1 Completed 0 30h
xb-cron-my-db-pxc-db-fs-pvc-2022615000-372f8-5d7gp 0/1 Completed 0 6h54m
->
$ kubectl get pod
NAME READY STATUS RESTARTS AGE
my-op-pxc-operator-7578776fd6-ttms8 1/1 Running 0 12d
testpod1 1/1 Running 0 12d
testpod2 1/1 Running 0 12d
testpod3 1/1 Running 0 12d
xb-cron-my-db-pxc-db-fs-pvc-2022611000-372f8-m7v75 0/1 Completed 0 4d6h
xb-cron-my-db-pxc-db-fs-pvc-2022612000-372f8-ws9x9 0/1 Completed 0 3d6h
xb-cron-my-db-pxc-db-fs-pvc-2022613000-372f8-tdtcm 0/1 Completed 0 2d6h
xb-cron-my-db-pxc-db-fs-pvc-2022614000-372f8-nld5t 0/1 Completed 0 30h
xb-cron-my-db-pxc-db-fs-pvc-2022615000-372f8-5d7gp 0/1 Completed 0 6h55m
$ kubectl get sts
NAME READY AGE
my-db-pxc-db-haproxy 0/0 12d
my-db-pxc-db-pxc 0/0 12d
$ kubectl get pxc -A
NAMESPACE NAME ENDPOINT STATUS PXC PROXYSQL HAPROXY AGE
default my-db-pxc-db my-db-pxc-db-haproxy.default paused 12d
### Pause 값을 true -> false 로 다시 수정
$ kubectl edit perconaxtradbclusters.pxc.percona.com
perconaxtradbcluster.pxc.percona.com/my-db-pxc-db edited
pause: true -> pause: false
# kubectl get pxc -A
NAMESPACE NAME ENDPOINT STATUS PXC PROXYSQL HAPROXY AGE
default my-db-pxc-db my-db-pxc-db-haproxy.default initializing 12d
$ kubectl get sts
NAME READY AGE
my-db-pxc-db-haproxy 3/3 12d
my-db-pxc-db-pxc 3/3 12d
$ kubectl get pod
NAME READY STATUS RESTARTS AGE
my-db-pxc-db-haproxy-0 2/2 Running 0 6m23s
my-db-pxc-db-haproxy-1 2/2 Running 0 5m12s
my-db-pxc-db-haproxy-2 2/2 Running 0 4m52s
my-db-pxc-db-pxc-0 3/3 Running 0 6m24s
my-db-pxc-db-pxc-1 3/3 Running 0 5m23s
my-db-pxc-db-pxc-2 3/3 Running 0 4m23s
my-op-pxc-operator-7578776fd6-ttms8 1/1 Running 0 12d
testpod1 1/1 Running 0 12d
testpod2 1/1 Running 0 12d
testpod3 1/1 Running 0 12d
xb-cron-my-db-pxc-db-fs-pvc-2022611000-372f8-m7v75 0/1 Completed 0 4d7h
xb-cron-my-db-pxc-db-fs-pvc-2022612000-372f8-ws9x9 0/1 Completed 0 3d7h
xb-cron-my-db-pxc-db-fs-pvc-2022613000-372f8-tdtcm 0/1 Completed 0 2d7h
xb-cron-my-db-pxc-db-fs-pvc-2022614000-372f8-nld5t 0/1 Completed 0 31h
xb-cron-my-db-pxc-db-fs-pvc-2022615000-372f8-5d7gp 0/1 Completed 0 7h5m