[slurm-users] Slurmdbd High Availability

[Tina Friedrich]

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.

Tina

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 : 192.168.123.12(slurmctld)
>> server2: 192.168.123.13(Slurmctld)
>> server3: 192.168.123.14(Slurmdbd) which is pointing to both Server1 
>> and Server2.
>> database: MySQL
>>
>> I have 1 more server named as server 4: 192.168.123.15 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
>>