[slurm-users] Advice for merging accounting data

[Brian Andrus]

If you want everything good, you will want to dump/import before 
starting to use the new database.

If they are the same versions of mysql/mariadb, I would merely rsync the 
database folders over and then start the db.

One potential gotcha is the jobid starting over/being different. Make 
sure you set that in the slurm.conf to continue the numbering from where 
you left off so there are no entries in accounting that get replaced.

Brian Andrus

On 7/8/2020 3:15 AM, Simon Kainz wrote:
> Hello,
>
> we have a long-running slurm cluster, accounting into slurmdbd/mysql
> backend on the cluster master.
>
> We recently installed a new system, now with a dedicated, separate
> logging host, also with mysql backend.
>
> How could i, preferably without losing accounting data, move the logging
> information from the old system into the new one?
>
> Just changing the logging config on the old system, adding the old
> system via sacctmgr and then dumping/importing the relevant tables into
> the new host?
>
> Are there any pitfalls to this idea?
>
> Thank you in advance,
>
> Simon.
>