Converting the MySQL Database Storage Engine from MyISAM to InnoDB Using the Jamf Pro Server Tools Command-Line Interface

Technical Articles
Solution
Application
Content Type
Technical Documentation
Utilities & Services
ft:locale
en-US
This article describes how to convert the MySQL database storage engine from MyISAM to InnoDB using the Jamf Pro Server Tools command-line interface (CLI). The Jamf Pro database must be converted to InnoDB prior to upgrading to Jamf Pro 10.10.0.
Note:

The InnoDB conversion process may considerably increase the size of your MySQL database. Before converting the database, it is recommended that you have at least as much free disk space as the current database size, as well as adequate RAM (memory) for the server, as InnoDB will require some memory-intensive operations. If adequate system resources are not available on the server, either memory or storage, do not continue this process until resources have been addressed.

Converting the MySQL storage engine to InnoDB involves the following steps:

  1. Ensuring You Have the Latest Version of the Jamf Pro Server Tools CLI

  2. Confirming Database Information

  3. Configuring the Jamf Pro Server Tools CLI

  4. Configuring InnoDB Settings

  5. Stopping Apache Tomcat

  6. Backing Up the Database

  7. Converting to InnoDB