We just recently did the following with great success so far:
- 2 Centos7 servers setup with MariaDB 10.4 Community
- 1 Virtualbox VM on NFS storage
- 1 LXD container on CEPH storage
- Goal was to not rely on same server/storage for both SLURMDBD services
- SLURMDBD service configured on both pointing to the local DB
- LXD container is primary DB replicated to the VM
- Maxscale (running on the active/passive head nodes of HPC) provides
single point for slurmctld connections. Keepalived maintains active Maxscale
with virtual IP.
- MariaDB replication will catch up the primary if there was a failover.
- You need to create the user@host entries on your DB for both of your
slurmctld IPs
Hope this helps!
Chad Cropper
On 7/21/20, 12:05 PM, "slurm-users on behalf of Brian Andrus"
<slurm-users-boun...@lists.schedmd.com on behalf of toomuc...@gmail.com> wrote:
CAUTION: External email. Do not click links or open attachments unless you
recognize the sender and know the content is safe.
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
________________________________
*** The information contained in this communication may be confidential, is
intended only for the use of the recipient(s) named above, and may be legally
privileged. If the reader of this message is not the intended recipient, you
are hereby notified that any dissemination, distribution, or copying of this
communication, or any of its contents, is strictly prohibited. If you have
received this communication in error, please return it to the sender
immediately and delete the original message and any copies of it. If you have
any questions concerning this message, please contact the sender. ***
