Hi, We do have a "built-in" mechanism for database backups in OpenStack-Ansible, which is based on the maria-backup implemented by the python script, which is run as a systemd-timer. You can enable that by setting galera_mariadb_backups_enabled: true in your user-variables. It does support creation of both full and incremental backups, as well as performing backup lifecycle management. Some variables that control backup periodicity as well as retention properties through role variables: https://opendev.org/openstack/openstack-ansible-galera_server/src/commit/ebd... вт, 13 янв. 2026 г. в 18:59, keshav bareja <keshav.bareja@gmail.com>:
Hi Team
We have recently upgraded to the Openstack-ansible Epoxy [2025.1] release. In this release Galera mariadb is upgraded to MariaDB 11.4.8. We have a daily DB backup crontab setup for the backup and before the Epoxy release we were using the below command to take the backup and now it doesn't work anymore.
mysqldump --opt --all-databases > "openstack_$(date +'%Y-%m-%d_%H-%M-%S').sql"
Can you please recommend the way to take the Galera DB backup now?
I can see the command mariadb-dump, can we use the options below?
mariadb-dump \ --all-databases \ --single-transaction \ --quick \ --skip-lock-tables \ --skip-add-locks \ --routines \ --events \ --triggers \
"openstack_$(date +'%Y-%m-%d_%H-%M-%S').sql"
Regards Keshav