[slurm-users] slurmdbd database usage

[Sandor]

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

[Michael Gutteridge]

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

[Christopher Samuel]

On 8/2/23 2:30 pm, Sandor 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?

From memory (and confirmed by git) support for Postgres was removed
from Slurm way back in 2013 before the 14.03 release (the first one
using dates as version numbers).

All the best,
Chris
--
Chris Samuel : http://www.csamuel.org/ : Berkeley, CA, USA

[Greg Wickham]

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