Skip to content

Upgrading Volt Foundry to version 9.5.22.0 or later

Upgrade Volt Foundry from versions earlier than 9.5.22.0 to version 9.5.22.0 or later

Prerequisites

Volt Foundry versions earlier than 9.5.22.0

Upgrade Steps

To upgrade Volt Foundry from versions earlier than 9.5.22.0 to Volt Foundry version 9.5.22.0 or later, follow below steps:

  1. Stop Volt Foundry server.
  2. Backup Foundry data from MySQL 8.0 server which includes the schemas <prefix> admindb<suffix> <prefix> idconfigdb<suffix> <prefix> kpnsdb <suffix> <prefix> mfaccountsdb <suffix> <prefix>mfconsoledb<suffix> <prefix> mfreportsdb <suffix> and other schemas created during runtime
  3. Stop MySQL 8.0 server.
  4. Upgrade the MySQL server to 8.4
  5. Update the my.cnf or my.ini file of MySQL 8.4 by adding following changes under [client], [mysql] and [mysqld] section and restart the MySQL server.
    1  Ensure that you modify the my.cnf or my.ini with the following parameters:
        [client]
        default-character-set = utf8mb4
        [mysql]
        default-character-set = utf8mb4
        [mysqld]
        character-set-server=utf8mb4
        collation-server="utf8mb4_0900_ai_ci"

    2  Next, restart the MySQL service and run the following query to verify the details:

        mysql> SHOW VARIABLES LIKE 'collation_%';
        +----------------------+--------------------+
        | Variable_name        | Value              |
        +----------------------+--------------------+
        | collation_connection | utf8mb4_0900_ai_ci |
        | collation_database   | utf8mb4_0900_ai_ci |
        | collation_server     | utf8mb4_0900_ai_ci |
        +----------------------+--------------------+
        3 rows in set (0.00 sec)

        mysql> show variables like 'character%';
        +--------------------------+---------------------------------------------------------+
        | Variable_name            | Value                                                   |
        +--------------------------+---------------------------------------------------------+
        | character_set_client     | utf8mb4                                                 |
        | character_set_connection | utf8mb4                                                 |
        | character_set_database   | utf8mb4                                                 |
        | character_set_filesystem | binary                                                  |
        | character_set_results    | utf8mb4                                                 |
        | character_set_server     | utf8mb4                                                 |
        | character_set_system     | utf8mb3                                                 |
        | character_sets_dir       | C:\Program Files\MySQL\MySQL Server 8.0\share\charsets\ |
        +--------------------------+---------------------------------------------------------+
        8 rows in set (0.00 sec)
  1. Alter the character set and collation for Foundry schemas `(admindb, idconfigdb, kpnsdb, mfaccountsdb, mfconsoledb, mfreportsdb)` with following command:
    ALTER DATABASE < DATABASE_NAME > CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
  2. To upgrade Volt Foundry server, refer to Volt Foundry 9.5.22.0 or later upgrade instructions.