[slurm-users] Several slurmdbds against one mysql server?

[Ole Holm Nielsen]

On 29-04-2023 11:44, Angel de Vicente wrote:
> Hello,
> 
> I'm setting Slurm in a number of machines and (at least for the moment)
> we don't plan to let users submit across machines, so the initial plan
> was to install Slurm+slurmdbd+mysql in every machine.
> 
> But in order to get stats for all the machines and to simplify things a
> bit, I'm planning now to have only on mysql server running in a separate
> machine and to collect all job data there.
> 
> What would make more sense?
>    + 1) to install only one slurmdbd+mysql and configure all slurmctlds to
>    communicate with the single slurmdbd, or
>    + 2) to have a slurmdbd in every machine and only one mysql to which all
>    slurmdbds connect?
> 
> Right now I have 2) working, but I wonder if there are pros/cons that I
> have not considered yet for option 1)

Maybe you want to use Slurm federated clusters with a single database, 
see https://slurm.schedmd.com/federation.html
There is a presentation at https://slurm.schedmd.com/SC17/FederationSC17.pdf

I hoe this helps.

/Ole