mariadb 백업(on k8s)

mariadb pod 찾기

# kubectl get [pod | po] [--all-namespaces | -n {NAMESPACE}] | grep {keyword}
$ kubectl get po -n database | grep maria

pod execute

# kubectl exec [po | pod] -n {NAMESPACE} -it {POD_NAME} /bin/bash
$ kubectl exec po -n database mariadb-master-0

# Kubectl exec -n {NAMESPACE} -it {POD_NAME} -- /bin/bash
$ kubectl exec po -n database -it mariadb-master-0 -- /bin/bash

Backup mariaDB in pod

# mysqldump -u{USER_NAME} -p -A > {FILE_PATH(NAME)}
$ mysqldump -uroot -p -A > /tmp/dump.sql

Transfer node(local)

# kubectl cp {NAMESPACE}/{POD_NAME}:{SOURCE_FILE_PATH} {TARGET_FILE_PATH}
$ kubectl cp database/mariadb-master-0:/tmp/dump.sql ~/mariadb-master-dump.sql

Compression

# tar zcvf {FILE_NAME}.tar.gz [ * | {FILE(DIR)_NAME}]
$ tar zcvf mariadb-master-dump.tar.gz ~/mariadb-master-dump.sql