To protect from HW failure, and to have more free hands when upgrading underlying OS, we use virtualization with "live migration"/HA and MariaDB server as a VM.
VM is easy to backup, restore as a snapshot, clone for possible tests, etc.
In the past, I deployed (customer-requirement) one site using a Galera cluster, but the high availability solution introduced a new level of configuration complexity, which was IMO not helping to the total system availability.
cheers
josef
On 22. 01. 24 18:23, Daniel L'Hommedieu wrote:
...database reliability in your SLURM environment...