Converting the Database to InnoDB

Technical Articles
Solution
Application
Content Type
Technical Documentation
Utilities & Services
ft:locale
en-US
  1. Start the conversion process by executing the following command:
    jamf-pro database convert-to-innodb
    Note:

    For Linux servers, sudo privileges will be needed. For Windows, the jamf-pro commands must be run from the directory where the executable is stored. Reference Step 4 for instructions on navigating to the correct directory.

  2. When prompted, enter Y to confirm the following prerequisites:

    • The database is running locally

    • Sufficient free disk space and system memory are available

    • The database has been backed up

    • The Tomcat server is stopped on all nodes

    • The InnoDB Buffer Pool Size setting has been configured and that the MySQL service has been restarted

  3. After the prerequisites are confirmed, a pre-conversion process occurs and perform the following actions:

    • Repair and optimize the database

    • Verify the database settings

After the pre-conversion process is complete, all database tables will be converted from MyISAM to InnoDB. This process may take some time.

A message stating that the conversion is complete will be displayed when the process has finished. At this point it is recommended to create a new database backup (see Step 7 above) prior to starting Tomcat again on the server.