openstack/kolla-ansible.git/ansible/roles/mariadb/templates/backup.my.cnf.j2, branch stable/2026.1

Include CA for database TLS on MariaDB backup

2026-09-25T12:42:02+00:00

When database backend TLS was implemented [1], the CA was not set for Mariabackup configuration. [1] https://review.opendev.org/c/openstack/kolla-ansible/+/909912 Closes-bug: #2168443 Change-Id: I2d88af7c61bb609311a5f0a820a501d006f8e454 Signed-off-by: Seunghun Lee (cherry picked from commit 7c64ed9ff0509b4001d319f620d4bfe68ae9dfdb)

mariadb: Back up from the local database instance

2026-08-25T12:27:03+00:00

Mariabackup copies the data directory of mariadb_backup_host but connected through the load balancer, so backup_replica.sh could redirect it to another Galera member. The backup lock then applied to the wrong node, leaving the copied files unquiesced. Connect to api_interface_address and mariadb_port instead, and always use the local backup script. MariaDB 10.11.19 and 11.4.13 no longer tolerate the mismatch. mariadb_backup_target now has no effect, and full backups are named mysqlbackup-.qp.xbc.xbs.gz, as the restore docs describe. Closes-Bug: #2165011 Related-Bug: #2125124 Change-Id: I33ebd36c728ff50df8ebf13fc5af9882a0e71d23 Signed-off-by: Bartosz Bezak (cherry picked from commit f1f2702bbe812e285f0766a5787159ba92fdce8b)

Add new option to perform an on-demand backup of MariaDB

2018-11-22T09:20:59+00:00

blueprint database-backup-recovery Introduce a new option, mariadb_backup, which takes a backup of all databases hosted in MariaDB. Backups are performed using XtraBackup, the output of which is saved to a dedicated Docker volume on the target host (which defaults to the first node in the MariaDB cluster). It supports either full (the default) or incremental backups. Change-Id: Ied224c0d19b8734aa72092aaddd530155999dbc3