|
My go to solution is setting up Galera cluster using 2 slurmdbd
servers (each pointing to it's local db) and a 3rd quorum server.
It's fairly easy to setup and doesn't rely on block level
duplication, HA semantics or shared storage.
Just my 2 cents
On 14/04/2023 14:18, Tina Friedrich
wrote:
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
|
