Upgrade Embedded MYSQL 5.7 to MYSQL 8.0

Notice

We recommend the upgrade to MySQL 8.0 be done under the guidance of the Support team.

Background

As of Zephyr Enterprise (ZE) 7.17 release, we officially replaced MySQL 5.7.x with MySQL 8.0.x

Currently, we don’t support the upgrades of Embedded MySQL through ZE Installer. It needs to be done manually before you upgrade to ZE 7.17 or above versions.

Note

The Embedded MySQL is only supported for Windows OS.

Operating System - Windows 10

Prerequisites

  1. This is for users who use embedded MySQL for their production environment.

  2. MySQL 5.6.x connection should be working properly with ZE (before the upgrade).

  3. Requirement or need of a user to upgrade to ZE 7.17 or above versions.

  4. Must upgrade the embedded MySQL before upgrading ZE to v7.17.

Upgrade Steps

A user must follow the steps before upgrading:

  1. Take a backup of the ZEPHYR Installation folder.

  2. Take Database backup of ITCC and DVERSION.

  3. Client will take downtime as per their policy for the production environment.

  4. Stop the services on Windows.

    As Zephyr, ES and DB are installed as services on Windows, you must stop them in the following sequence:

    1. Stop Zephyr service

    2. Stop Elasticsearch service

    3. Stop Database service

  5. Download MySQL v8.0.31 in ZIP format from the official MySQL website https://downloads.mysql.com/archives/get/p/23/file/mysql-8.0.31-winx64.zip

  6. Unzip the MySQL v8.0.31 ZIP file in any of your chosen directories

  7. COPY the below sub-folders one by one, from unzipped MySQL 8.0.31 folder

    1. bin/

    2. docs/

    3. include/

    4. lib/

    5. Share/

  8. PASTE the sub-folders one by one under <ZEPHYR-Installation-Directory>\mysql\

    For example, C:\Program Files\Zephyr\mysql\

    Warning

    Don't remove any Target folders in C:\Program Files\Zephyr\mysql\ before copying above folders. There are important Config files in the target folders.

  9. Go to MySQL bin directory C:\Program Files\Zephyr\mysql\bin\

    1. Check the MySQL version using the below command

      mysql --version

    2. Generally, MySQL 8.0.31 requires an MSVCP140.dll and MSVCP140_1.dll as a prerequisite

      1. If the above .dll file exists, then it shows the new MySQL version as 8.0.31

      2. If the above .dll file does not exists, then it might show the below error

        3629383998.png
        ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '<yourpassword>';
ALTER USER 'root'@'::1' IDENTIFIED WITH mysql_native_password BY '<yourpassword>';
ALTER USER 'root'@'127.0.0.1' IDENTIFIED WITH mysql_native_password BY '<yourpassword>';

  10. Start all stopped services in the order:

    • Start the Database service

    • Start ES service

  11. Follow the upgrade process of Zephyr to upgrade to v7.17.

In this section:
© 2024
Publication date: