Hi, Thanks everyone who shared the information with me. Really appreciate it.
Thanks, Shaghuf Rahman On Sun, 16 Apr 2023 at 02:21, Daniel Letai <d...@letai.org.il> wrote: > 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 > > >
