With Jamf Pro 10.6.0, Jamf changed the default storage engine from MyISAM to InnoDB.
Jamf also released a tool to convert the tables with the release of 10.7.0.
However, as the Jamf supplied tools are not available currently available as a standalone download for those of us that do manual installations & as we host our datajar.mobi instances on Kubernetes… we went the manual route.
Below is how we performed these conversions.
We updated our JSS from 8.73 – 9.22 back in January, we thought all was well until we needed to deploy some large packages.
This lead to our network guys not being to happy as Mac clients were downloading a 200MB installer across our MPLS irregardless of the distribution points assigned in our network segments.
After a few calls with JAMF support we discovered that the issue was due to the v8-v9 upgrade not updating a MySQL table, below is the how to check if your affected & what to do to fix.
I’ve been trying to restore my JSS 8.73 to a test server in preparation to test upgrading to 9.2x, but during the restore i was getting the error “ERROR 2006 (HY000) at line 1692: MySQL server has gone away” as shown below. Continue reading
When creating test JSS instances, I often stumble over this issue where the “Change MySQL Settings…” option is greyed out.