[slurm-users] Slurm MySQL database configuration

[Brian Andrus]

You need a single database connection string that both slurmdbd daemons 
point to.

To have high availability, you should do that with the db configurations 
(HA, replication, etc), which makes sense, as you want the database to 
be HA.

The slurm backup configuration is to protect from your slurm daemons 
going down.

Brian Andrus

On 7/21/2020 7:44 AM, Peter Mayes wrote:
> Hi,
>
> My first post to the list, so apologies if this is a FAQ,
>
> My configuration has two nodes allocated for Slurm masters, with a
> highly-available NFS server mounting a filesystem across the two nodes.
>
> I need advice on the best configuration.
>
> I naively thought of having a single MariaDB database located in the NFS
> server, with slurmctld, slurmdbd and mariadb running on both slurm
> nodes, with only one slurmdbd/mariadb actively touching the database at
> any one time.
>
> slurm.conf
> ----------
> SlurmctldHost=slurm1(a.b.c.1)
> SlurmctldHost=slurm2(a.b.c.2)
>
> AccountingStorageHost=slurm1
> AccountingStorageBackupHost=slurm2
>
> slurmdbd.conf
> -------------
>
> DbdHost=slurm1
> DbdBackupHost=slurm2
>
> StorageHost=localhost
>
> But MariaDB doesn't seem to like (possibly understandably) two mysql
> daemons accessing a single database instance from two servers.
>
> What would be the best way to configure this setup?
>
> Thanks in advance
>
> -- Peter