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
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
mariadbhost and requiresenable_mariabackup: yes(defaultno); 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