samrose3
4/12/2018 - 6:16 PM

Interacting with a DB in a Kubernetes cluster

These commands are specific to the Bitnami MariaDB

restore
content_copyfile_download
RELEASE_NAME="release"
DB_USER="bn_wordpress"
DB_NAME="bitnami_wordpress"

POD_NAME=$(kubectl get pods --namespace default -l "app=$RELEASE_NAME-mariadb" -o jsonpath="{.items[0].metadata.name}")
MARIADB_PASSWORD=$(kubectl get secret --namespace default $RELEASE_NAME-mariadb -o jsonpath="{.data.mariadb-password}" | base64 --decode)

kubectl exec $POD_NAME -- mysql -u $DB_USER -p$MARIADB_PASSWORD $DB_NAME > restore.sql
backup
content_copyfile_download
RELEASE_NAME="release"
DB_USER="bn_wordpress"
DB_NAME="bitnami_wordpress"

POD_NAME=$(kubectl get pods --namespace default -l "app=$RELEASE_NAME-mariadb" -o jsonpath="{.items[0].metadata.name}")
MARIADB_PASSWORD=$(kubectl get secret --namespace default $RELEASE_NAME-mariadb -o jsonpath="{.data.mariadb-password}" | base64 --decode)

kubectl exec $POD_NAME -- mysqldump -u $DB_USER -p$MARIADB_PASSWORD $DB_NAME > backup.sql