Upgrading Volt Foundry to version 10.0.7.0 or later
Upgrade Volt Foundry from versions 10.0.0.0 through 10.0.6.x to version 10.0.7.0 or later
Prerequisites
Volt Foundry from versions 10.0.0.0 through 10.0.6.x
Upgrade Steps
To upgrade Volt Foundry from versions 10.0.0.0 through 10.0.6.x to version 10.0.7.0 or later, follow below steps:
- Stop Volt Foundry server.
- 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 - Stop MySQL 8.0 server.
- Upgrade the MySQL server to 8.4
- 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)
- 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; - To upgrade Volt Foundry server, refer to Volt Foundry 10.0.7.0 or later upgrade instructions
Upgrade Volt Foundry versions earlier than 9.5.22.0 directly to version 10.0.7.0 or later
Prerequisites
Volt Foundry earlier than version 9.5.22.0
Upgrade Steps
To upgrade Volt Foundry earlier than 9.5.22.0 directly to version 10.0.7.0 or later, follow below steps:
- Stop Foundry server.
- 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 - Stop MySQL 8.0 server.
- Upgrade the MySQL server to 8.4
- 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)
- Alter the character set and collation for Foundry schemas
(<prefix>admindb<suffix>, <prefix>idconfigdb<suffix>, <prefix>kpnsdb<suffix>, <prefix>mfaccountsdb<suffix>,<prefix>mfconsoledb<suffix>, <prefix>mfreportsdb<suffix>)with following command:
ALTER DATABASE < DATABASE_NAME > CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
- Alter the character set and collation of Identity schema tables
SET FOREIGN_KEY_CHECKS = 0;
ALTER TABLE <idconfig schema name>.app_config CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
ALTER TABLE <idconfig schema name>.acs_namespace CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
ALTER TABLE <idconfig schema name>.auth_provider CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
ALTER TABLE <idconfig schema name>.auth_app_credentials CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
SET FOREIGN_KEY_CHECKS = 1;
- Alter the character set and collation of Console schema tables
SET FOREIGN_KEY_CHECKS = 0;
ALTER TABLE <mfconsoledb schema name>.projects CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
ALTER TABLE <mfconsoledb schema name>.workspaces CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
SET FOREIGN_KEY_CHECKS = 1;
- To upgrade Volt Foundry server, refer to Volt Foundry 10.0.7.0 or later upgrade instructions