MariaDB and backup, Snapshot?

Hi all,

I’ve just installed MariaDB, and wonder if this database is backed up by Snapshot ?
If not, can it be backed up by HA somehow ?

What I know yes it will

1 Like

Last time I have restored HA from a full snapshot the MariaDB database was also restored completely.

1 Like

Hold on, MariaDB (as most other dbms) writes to its files in random order.

(Little bit in the middle, little bit in the end, oh look there’s space in the file in the middle let’s put some data there and so on).

How does snapshots ensure integrity and consistency of a backup snapshot? … lvm?