Upgrading Quantum Fabric Manually
Additional steps for Fabric upgrade to V9 GA and later
The Identity provider and user information which resides in the Identity schema should be moved to the Workspace schema. Perform the following steps to execute a successful data migration from Identity to Workspace:
- Perform a backup of your schemas.
- Upgrade the Identity schema to Quantum Fabric V9 or later.
- Upgrade the Workspace schema to version 899.00 by setting the
flyway.target
parameter in theflyway.conf
to the target version. For example, setflyway.target=899.00
while executing flyway scripts. The Workspace schema must be at v899.00 for the data migration step to be completed successfully. Once the data migration step has been completed, the schema upgrade resumes to Quantum Fabric V9 or later. - Execute a command line jar which takes a config.yml file as the input.
Sample config.yml file
workspace: database: url: jdbc:mariadb://10.10.24.147:3309/<prefix>mfconsoledb<suffix> username: testUser password: testPassword //master_key corresponds to the value of WAAS_ENCRYPTION_KEY present in workspace.properties file workspace.war master_key: 7309478f-2d02-4ce6-bb29-d1ad2b376502 auth: database: driver: org.mariadb.jdbc.Driver //jdbc url url: jdbc:mariadb://10.10.24.147:3309/<prefix>idconfigdb<suffix> username: testUser password: testPassword //master_key corresponds to the value of master_key property present in authservice.key file in authService.war master_key: 14d59362-5c03-4ff8-a6cd-8a4ecceb6cfb master_key_alg: aes master_key_size: 128 migration: batch_size: 5000 hibernate: dialect: org.hibernate.dialect.MySQLDialect
Database specific inputs as follows:
Database Type | JDBC URL format | Database Driver | Hibernate dialect |
---|---|---|---|
MySQL |
jdbc:mysql://<host>: <port>/<schema_name> |
com.mysql.cj.jdbc.Driver | org.hibernate.dialect. MySQLDialect |
MariaDB | jdbc:mariadb ://<host>: <port>/<schema_name> | org.mariadb.jdbc.Driver | org.hibernate.dialect. MySQLDialect |
Oracle DB | jdbc:oracle:thin:@<host>: <port>/<serviceName> | oracle.jdbc.driver.OracleDriver | org.hibernate.dialect. Oracle10gDialect |
MS SQL Server | jdbc:sqlserver:mbaastest18.konylabs.net: <port>;databasename=<schema_name> | com.microsoft.sqlserver.jdbc. SQLServerDriver | org.hibernate.dialect. SQLServerDialect |
- Begin the data migration from the identity schema to the workspace schema by executing the following command:
java -jar <Data migration jar location>/authDataMigration.jar migrate -e onprem -c <Data migration config file location>/config.yml
- Check the status of data migration by executing the following command:
java -jar <Data migration jar location>/authDataMigration.jar check-status -e onprem -c <Data migration config file location>/config.yml
- Resume the Console schema upgrade to the latest version by commenting the flyway.target parameter or leaving it blank in the flyway.conf file while executing the flyway scripts.