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.
Below are more details on the issue, and the 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.
When creating test JSS instances, I often stumble over this issue where the “Change MySQL Settings…” option is greyed out
This often leads to me having to contact JAMF Support for a refresher. Well hopefully this post will remind me!