Server upgrade for MySQL

Owned by Daniel (Deactivated)
Last updated: Jan 23, 2018 by Kevin Pham (Deactivated)
1 min read

This section applies specifically to the Zephyr Enterprise Server. The information below is generally used to ensure that system administrators can update their Zephyr Enterprise Server instance for MySQL. 


Below are instructions on the steps needed to upgrade a Zephyr Enterprise Server installation of 4.8 to the latest 5.0.



Prerequisites for Zephyr 5.0 Installation

  1. Database ready with remote access permission
  2. Upgrader


Zephyr 5.0 Installation

  1. Take a full back up of the existing Zephyr Enterprise Server instance using the information at Backup & Restore.
  2. Run the 5.0 Upgrader Utility in check mode to verify the backup is ready to be upgraded. If any errors appear during this process, please reach out to Zephyr Support before proceeding.
  3. Uninstall Zephyr Enterprise Server 4.8
    1. IMPORTANT: All configurations and settings will be lost during uninstallation. Create a backup of these settings before uninstalling in case they are needed for review in later steps.
  4. Install Zephyr Enterprise Server 5.0 (14587)
    1. See our installation guide if you need help here
  5. Stop the Zephyr Enterprise Server application server before running the upgrade process on the database
  6. Run the 5.0 Upgrader Utility in Upgrade mode. Use the same backup you checked in step 2 above.
    1. Use the formatd below to run the utility and point the utility to where your MySQL server and my.ini/my.cnf file are located

      1. Windows

        <Upgrader>.exe -VzMySQLPath='C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe' -VzMySQLCnfFilePath='C:\Program Files\MySQL\MySQL Server 5.6\<your_ini_file>'

      2. Linux

        <Upgrader>.sh -VzMySQLPath='/usr/bin/mysql' -VzMySQLCnfFilePath='/etc/mysql/<your_cnf_file>'
  7. Once upgrade is complete, start all application nodes and verify the upgrade completion by logging into the instance and checking data