[slurm-users] Slurmdbd High Availability

Tina Friedrich tina.friedrich at it.ox.ac.uk
Fri Apr 14 11:18:42 UTC 2023

Or run your database server on something like VMWare ESXi (which is what 
we do). Instant HA and I don't even need multiple servers for it :)

I don't mean to be flippant, and I realise it's not addressing the mysql 
HA question (but that got answered). However, a lot of us will have some 
sort of failure-and-load-balancing VM estate anyway, or not? Using that 
does - at least in my mind - solve the same problem (just via a slightly 
different route).

Other than that I'd agree that HA solutions - of the pacemaker & 
mirrored block devices sort - tend to make things less reliable instead 
of more.


On 13/04/2023 16:03, Brian Andrus wrote:
> I think you mean both slurmctld servers are pointing the one slurmdbd 
> server.
> Ole is right about the usefulness of HA, especially on slurmdbd, as 
> slurm will cache the writes to the database if it is down.
> To do what you want, you need to look at configuring your database to be 
> HA. That is a different topic and would be dictated by what database 
> setup you are using. Understand the the backend database is a tool used 
> by slurm and not part of slurm. So any HA in that are needs to be done 
> by the database.
> Once that is done, merely have 2 separate slurmdbd servers, each 
> pointing at the HA database. One would be primary and the other a 
> failover (AccountingStorageBackupHost). Although, technically, they 
> would both be able to be active at the same time.
> Brian Andrus
> On 4/13/2023 2:49 AM, Shaghuf Rahman wrote:
>> Hi,
>> I am setting up Slurmdb in my system and I need some inputs
>> My current setup is like
>> server1 :
>> server2:
>> server3: which is pointing to both Server1 
>> and Server2.
>> database: MySQL
>> I have 1 more server named as server 4: which I need to 
>> make it as a secondary database server. I want to configure this 
>> server4 which will sync the database and make it either Active-Active 
>> slurmdbd or Active-Passive.
>> Could anyone please help me with the *steps* how to configure and also 
>> how am i going to *sync* my *database* on both the servers simultaneously.
>> Thanks & Regards,
>> Shaghuf Rahman

More information about the slurm-users mailing list