kolla-ansible mariadb 백업/복구

DB full dump

1. deploy 서버에 접속
   $ source ~/kolla-ansible/bin/activate
2. kolla-ansible 명령을 수행하여 full dump 수행
   $ kolla-ansible -i /etc/kolla/openstack-hosts.yml mariadb_backup

실행 결과

Backup MariaDB databases : ansible-playbook -i /etc/kolla/openstack-hosts.yml -e @/etc/kolla/globals.yml -e @/etc/kolla/passwords.yml -e CONFIG_DIR=/etc/kolla -e kolla_action=backup -e mariadb_backup_type=full /home/deploy/kolla-ansible.victoria/share/kolla-ansible/ansible/mariadb_backup.yml
[WARNING]: Skipping unexpected key (deploy) in group (deploy_node), only "vars", "children" and "hosts" are valid
[WARNING]: Skipping unexpected key (ctrl01) in group (ctrl_nodes), only "vars", "children" and "hosts" are valid
[WARNING]: Skipping unexpected key (ctrl02) in group (ctrl_nodes), only "vars", "children" and "hosts" are valid
[WARNING]: Skipping unexpected key (ctrl03) in group (ctrl_nodes), only "vars", "children" and "hosts" are valid
[WARNING]: Skipping unexpected key (comp01) in group (comp_nodes), only "vars", "children" and "hosts" are valid
[WARNING]: Skipping unexpected key (comp02) in group (comp_nodes), only "vars", "children" and "hosts" are valid
[WARNING]: Invalid characters were found in group names but not replaced, use -vvvv to see details
PLAY [Backup MariaDB] ***
TASK [Gathering Facts] ***
ok: [ctrl01]
ok: [ctrl02]
ok: [ctrl03]
TASK [mariadb : include_tasks] ***
included: /home/deploy/kolla-ansible.victoria/share/kolla-ansible/ansible/roles/mariadb/tasks/backup.yml for ctrl01, ctrl02, ctrl03
TASK [mariadb : Taking full database backup via Mariabackup] **
skipping: [ctrl02]
skipping: [ctrl03]
[WARNING]: The value False (type bool) in a string field was converted to 'False' (type string). If this does not look like what you expect, quote
the entire value to ensure it does not change.
changed: [ctrl01]

PLAY RECAP ***ctrl01 : ok=3 changed=1 unreachable=0 failed=0 skipped=0 rescued=0 ignored=0
ctrl02 : ok=2 changed=0 unreachable=0 failed=0 skipped=1 rescued=0 ignored=0
ctrl03 : ok=2 changed=0 unreachable=0 failed=0 skipped=1 rescued=0 ignored=0

// >> ctrl01에 changed=1 이면 성공

백업된 파일 확인 방법

1. 오픈스택 컨트롤러노드 1호기에 ssh 접속
2. 아래 경로에 파일이 있는지 확인
   cd /var/lib/docker/volumes/mariadb_backup/_data

[예시]
root@ctrl01:/var/lib/docker/volumes/mariadb_backup/_data# ls -lah
total 603M
drwxr-xr-x 2 42434 42434 4.0K Sep 1 19:12 .
drwx-----x 3 root root 4.0K Sep 1 19:10 ..
-rw-r--r-- 1 42434 42434 11 Sep 1 19:12 last_full_date
-rw-r--r-- 1 42434 42434 603M Sep 1 19:12 mysqlbackup-01-09-2023-1693563012.qp.xbc.xbs.gz

 

복구 방법

1. 아래 링크에 내용을 참고
   https://docs.openstack.org/kolla-ansible/latest/admin/mariadb-backup-and-restore.html