Skip to main content
Question

Jamf Pro Database Performance Enhancement

  • February 9, 2021
  • 4 replies
  • 22 views

Forum|alt.badge.img+13

I just saw that Jamf Pro 10.27 is out and has this waning: "Jamf Pro 10.27 includes a database performance enhancement which requires MySQL 5.7.8 or later." Does anyone know exactly what the performance enhancement is? I am running MariaDB and want to make sure it is supported. Thanks.

4 replies

bethjohnson
Forum|alt.badge.img+10
  • Jamf Heroes
  • February 12, 2021

I can't answer the question about the performance enhancements, but I can say that I tried the 10.27 upgrade on our test JSS running latest the available MariaDB (10.1) for Ubuntu 18.04 LTS, and the post-upgrade initialization of the JSS failed at updating database schemas.

There's a feature request that's been open since 2013 for MariaDB support, in case you haven't already upvoted. https://www.jamf.com/jamf-nation/feature-requests/1412/mariadb-support


Forum|alt.badge.img+8
  • Valued Contributor
  • March 4, 2021

I know this is kinda late but my 2 cents:

I tested 10.7.0b2 with MariaDB 10.4... it had some weird issues, but I didn't get to test much.
We decided to hold off on upgrading to 10.27 in production mainly because of Self Service UI changes.

I would highly recommend testing thoroughly.


Forum|alt.badge.img+9
  • Valued Contributor
  • March 5, 2021

Jamf will never support another database, no matter how long we wait, no matter how many times we ask.


donmontalvo
Forum|alt.badge.img+36
  • Hall of Fame
  • April 5, 2021

@barnesaw that's unfortunate, a few years ago we had some breakout sessions with Jamf's Dev team, for an effort to provide compatibility with MS SQL (etc.).

#sigh