Question for Upgrade to V10 - Check MySQL8 Upgrade Compatibility

book

Article ID: 191912

calendar_today

Updated On:

Products

CA API Gateway API SECURITY CA API Gateway Precision API Monitoring Module for API Gateway (Layer 7) CA API Gateway Enterprise Service Manager (Layer 7) STARTER PACK-7 CA Microgateway

Issue/Introduction

While following the step " Check for MySQL 8 Upgrade Compatibility"  in the following documentation
https://techdocsbroadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/layer7-api-management/api-gateway/10-0/install-configure-upgrade/upgrade-the-gateway/upgrade-an-appliance-gateway/prep-for-expedited-upgrade.html#concept.dita_5e719789-7bc5-4bde-a832-dd1569b51ab5_check8 no "fatal errors"are seen however there are many Warnings 

Questions:
1. Is this a problem that we should solve also before we do the upgrade?
2. Do you have a script which could convert from utf8mb3 to utf8mb4?
3. Do we need to change this or will it automatically be corrected when we migrate to the new MySQL8 Gateway Database?

Cause

As per the log the warning are for following check-point:

Usage of utf8mb3 charset
  Warning: The following objects use the utf8mb3 character set. It is
    recommended to convert them to use utf8mb4 instead, for improved Unicode
    support.
  More information:
    https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8mb3.html

  bipro_db - schema's default character set: utf8
  lost+found - schema's default character set: utf8
  mysql - schema's default character set: utf8
  ssg - schema's default character set: utf8
 .

Environment

Release : 9.4

Component : API GATEWAY

Resolution

Answering the questions
1. Is this a problem that we should solve also before we do the upgrade?

- not required, gateway works with utf8mb3 without any issue
2. Do you have a script which could convert from utf8mb3 to utf8mb4?

- As of now, gateway schema is not compatible with utf8mb4 due to table column size restrictions

3. Do we need to change this or will it automatically be corrected when we migrate to the new MySQL8 Gateway Database?

- In case of software gateway, please follow the instructions given in https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/layer7-api-management/api-gateway/10-0/install-configure-upgrade/upgrade-the-gateway/upgrade-a-software-gateway/install-upgrade-files-for-rhel-centos-suse.html