Upgrade Embeded MYSQL 5.7 to MYSQL 8.0

Owned by Manisha Khilaare (Deactivated)
Last updated: Apr 19, 2023
2 min read

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.

The Embedded MySQL is only Supported for Windows OS.

Operating System - Windows 10

Pre-requisites

  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 user to upgrade to ZE 7.17 or above versions.

  4. Must upgrade the embedded MySQL before upgrade 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 shall take downtime as per their policy for the production environment.

  4. Stop the services on Windows.
    As Zephyr, ES & 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\

CAUTION - Do not remove any Target folders in C:\Program Files\Zephyr\mysql\ before copying above folders. There are some important Config files in the target folders.

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

a. Check the MySQL version using the below command

mysql --version

b. Generally, MySQL 8.0.31 requires an MSVCP140.dll and MSVCP140_1.dll as a pre-requisite.

i. If the above .dll file exists, then it show the new MySQL version as 8.0.31

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

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 below order

11. Start the Database service

Start ES Service.

12. Follow the upgrade process of zephyr to upgrade to v7.17.