Installing the Jamf Pro Web App and MySQL on Different Servers

This section describes additional configuration requirements needed for using different servers for hosting the MySQL database and the Jamf Pro web app.

Installing the Jamf Pro web app and the MySQL database on different servers can improve performance for larger environments that require more resources. This scenario is possible for either clustered or non-clustered environments.

Requirements

When MySQL is installed on a different server than the Jamf Pro web app, MySQL must have proper privileges configured for the Jamf Pro web app to access the database. Certain MySQL queries must be run before you complete the procedure below. For instructions, see the "The database user is not granted proper privileges to the database" section in the Troubleshooting Database Connectivity from the Jamf Pro Server article.

  1. Install the Jamf Pro Server Tools command-line interface (CLI) on the MySQL server. When using the Jamf Pro installer on a single server, the CLI is automatically installed. However, when using two separate servers, you must manually download and install the CLI on the MySQL server. For instructions, see the "Installing the CLI" section of the The Jamf Pro Server Tools Command-Line Interface article.
  2. On the Jamf Pro web app server, verify the Jamf Pro web app settings by executing the following command:
    sudo jamf-pro server config list
  3. On the MySQL server, verify the database settings by executing the following command:
    sudo jamf-pro database config list

    For more information, see "Step 4: Verifying Settings" in the Creating the Jamf Pro Database Using the Jamf Pro Server Tools Command-Line Interface article.

  4. Establish the connection between Jamf Pro and MySQL by updating the Jamf Pro server config to point to the MySQL server instead of <localhost> by executing the following command:
    sudo jamf-pro server config set --database-host <FQDN OR IP ADDRESS>