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/ebd7fd89988ac38e7e5b3e08a758fdd24efd3518/defaults/main.yml#L341-L360

вт, 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