[slurm-users] Slurm MySQL database configuration

[Chad Cropper]

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 at 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-bounces at lists.schedmd.com on behalf of toomuchit at 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. ***