We do the same as Josef - we run the database on a VM (single VM, MariaDB) and leave it up to (in our case) VMWare to ensure its availability.
Tina
On 25/01/2024 11:34, Josef Dvoracek wrote:
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...