[slurm-users] [EXTERNAL] Re: slurmdbd database usage

Greg Wickham greg.wickham at kaust.edu.sa
Thu Aug 3 00:20:11 UTC 2023

Yup – Slurm is specifically tied to MySQL/MariaDB.

To get around this I wrote an C++ application that will extract job records from Slurm using “sacct” and write them into a PostgreSQL database.


The schema used in PostgreSQL is more conducive to faster adhoc queries than using “sacct”.



From: slurm-users <slurm-users-bounces at lists.schedmd.com> on behalf of Michael Gutteridge <michael.gutteridge at gmail.com>
Date: Thursday, 3 August 2023 at 1:02 am
To: Slurm User Community List <slurm-users at lists.schedmd.com>
Subject: [EXTERNAL] Re: [slurm-users] slurmdbd database usage

Pretty sure that dog won't hunt.  There's not _just_ the tables, but I believe there's a bunch of queries and other database magic in slurmdbd that is specific to MySQL/MariaDB.

 - Michael

On Wed, Aug 2, 2023 at 2:33 PM Sandor <sanshobo2 at gmail.com<mailto:sanshobo2 at gmail.com>> wrote:
I am looking to track accounting and job data. Slurm requires the use of MySQL or MariaDB. Has anyone created the needed tables within PostGreSQL then had slurmdbd write to it? Any problems?

Thank you in advance!
Sandor Felho
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.schedmd.com/pipermail/slurm-users/attachments/20230803/68792d4b/attachment-0001.htm>

More information about the slurm-users mailing list