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