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.
https://gitlab.com/greg.wickham/sminer
The schema used in PostgreSQL is more conducive to faster adhoc queries than
using “sacct”.
YMMV
-greg
From: slurm-users <slurm-users-boun...@lists.schedmd.com> on behalf of Michael
Gutteridge <michael.gutteri...@gmail.com>
Date: Thursday, 3 August 2023 at 1:02 am
To: Slurm User Community List <slurm-users@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
<sansho...@gmail.com<mailto:sansho...@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
