Standard way to take backup of mysql running inside Kubernetes pod?

Question

i am having Kubernetes cluster on digital ocean and running database inside k8s pod.

I am planning for schedule backup eveyday so what is best way for everyday auto backup. JOB or JENKINS ?

Database is not exposed outside using any service

if i use K8s job how to store backup in PVC and how to delete old one?

I am already running script to take snapshot of volume via jenkin is good way to restore?

https://stackoverflow.com/questions/41014085/backup-recover-kubernetes-current-state-namespaces-pods-controllers-etc, https://medium.com/@pmvk/kubernetes-backups-and-recovery-efc33180e89d — sulabh chaturvedi, Feb 22 '19 at 08:34

P Ekambaram · Accepted Answer · 2019-02-22T08:36:17.560

1

you can consider one of the below approach

Create a CronJob in k8s and run backup using mysql service dns.
install cron inside mysql container ( update mysql image with cron) and run mysql backup at scheduled interval. archive the backup and push it to s3 storage.

edited Feb 22 '19 at 08:36

answered Feb 22 '19 at 08:27

P Ekambaram

can't i run JOB in k8s ? – Harsh Manvar Feb 22 '19 at 08:33
1

you can. but you might want to run backup at regular intervals. so cron is preferred – P Ekambaram Feb 22 '19 at 08:35
i think i can also setup cron in K8s job – Harsh Manvar Feb 22 '19 at 08:36
or i can use jenkins run schedule snapshot of volume – Harsh Manvar Feb 22 '19 at 08:37
in the first point above, i was referring to run CronJob in kubernetes – P Ekambaram Feb 22 '19 at 08:38
ohhh ok thankyou so much reply ...so as per your suggestion cronjob take backup anad upload it to s3? – Harsh Manvar Feb 22 '19 at 08:40
1

you need to develop a shell script to run mysqldump and tar it and push it to s2 storage. run the shell script from the container that you are going to use in CronJob pod – P Ekambaram Feb 22 '19 at 08:43
Thankyou so much for reply got it – Harsh Manvar Feb 22 '19 at 08:50

1 Answers1