Skip to content

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 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
  • R18 — mariadb_recovery: what happens, blast radius and precautions
  • R15 — after kolla-ansible stop, MariaDB needs mariadb_recovery
  • Fact sheet E §9 — the two playbooks: the backup runs only on the first mariadb host and requires enable_mariabackup: yes (default no); 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