Database operations¶
Impact Recovery
The command lines of the MariaDB backup (mariadb_backup) and of the Galera cluster recovery (mariadb_recovery). What
the two playbooks do is described in the sections listed under Related.
Warning
mariadb_recovery stops every MariaDB node, even healthy ones, and bootstraps from the highest seqno: a full DB
outage (R18). The stop and the seqno comparison run only when
mariadb_recover_inventory_name is not set; with -e mariadb_recover_inventory_name=<host> the playbook bootstraps
from that host directly (roles/mariadb/tasks/recover_cluster.yml:18-99). The precautions of R18 are "Only when the
cluster is fully down; identify the node with the highest seqno manually first".
kolla-ansible -i multinode mariadb_backup # full (default) or --incremental
kolla-ansible -i multinode mariadb_recovery # ONLY when the whole Galera cluster is down
CODE mariadb_backup runs mariadb_backup.yml with kolla_action=backup and mariadb_backup_type set by
--full (default) or --incremental; mariadb_recovery runs mariadb_recovery.yml with kolla_action=deploy and
mariadb_recover: true (tools/kolla-ansible:180-183, :437-445; mariadb_backup.yml:2-7;
mariadb_recovery.yml:2-9). In 2023.1 the backup runs on the first host of each MariaDB shard group
(mariadb_backup_host, roles/mariadb/defaults/main.yml:123; one shard, hence the first mariadb host, unless
mariadb_shard_id is set per host, group_vars/all.yml:395-398), in a mariabackup container started from the
image of the running MariaDB container (roles/mariadb/tasks/backup.yml:2-35).
Related¶
- R18 —
mariadb_recovery: what happens, blast radius and precautions - R15 — after
kolla-ansible stop, MariaDB needsmariadb_recovery - Fact sheet E
§9
— the two playbooks: the backup runs only on the first host of the shard group and requires
enable_mariabackup: yes(defaultno,group_vars/all.yml:709;mariadb_backup.yml:5-7); otherwise every task is skipped silently - Fact sheet B §1.3 — the rows "backup" and "recovery" of the task flow, and the recovery steps in order
- Fact sheet B §1.8 — items 4 to 7 and 9: the fail-fast guards, and what recovery and backup do
- Pre-execution checklist — step 8 lists a MariaDB backup as rollback material
- MariaDB/Galera — the component page: fact sheet, tag, risks, service card