Backup strategy

[teawithfruit]

I didn't found anything about backup and restore in the deployment files.
How do you provide backup and restore in this mariadb cluster?

[solsson]

We have a script that dumps to regular backed up file storage, basically using
kubectl --namespace=mysql exec $POD -- mysqldump $MYSQLAUTH --skip-dump-date --databases "$dbname"
with $dbname from kubectl exec mysql $MYSQLAUTH -B -N -e 'show databases'.

I guess there are lots of more sophisticated approaches. We also have application level backups of the stuff that matters in mariadb, so this is good enough for us. But it'll be interesting what you find.