View Source

Tool Upgrade Documentation

Objective: Upgrade the existing tools and technologies to the latest versions and configure them appropriately.

Activities Performed:

Database Backup:
- Duration: 2 hours
- Description: Backup of the current database to ensure no data loss during the upgrade process.
Uninstallation of Previous Versions:
- Java 1.8
- MySQL 5.7
- Redis
- WildFly 11
- Duration: 40 minutes
- Tools Uninstalled:
Installation of New Versions:
- JDK 17
- MySQL 8.0
- Redis 5
- WildFly 30
- Duration: 1 hour 15 minutes
  - Paths for all Tools
    Wildfly30 – E:\uat_new\wildfly-30.0.0.Final\wildfly-30.0.0.Final
    Redis5 – C:\Program Files\Redis
    Java17 – C:\Program Files\Java\jdk-17.0.3.1
    MySQL8 – F:\MYSQL8\MySQL\MySQL Server 8.0
Database Schema Configuration changes:
1. Duration: 2 hours
2. Description:

Before tacking the backup we have made changes in db schema to make compatible with MySQL 8.0. Changes are mentioned here:

While restoring latest backup need to replace NO_AUTO_CREATE_USER in db routines
Keep sql_mode in my.ini config file (MySQL 8)

sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

3. As part of testing done below datatype change (MySQL 8)

alter table db_iemr.t_phy_anthropometry modify BMI decimal(7,3);

4. Reserved keywords would be changed to MySQL supported columns.
ex: system, value etc.(identified in Pr_Practioner sp)

DB Objects	Upgradation Issues
Tables	5(trigger related tables)	Dump files created with an earlier version of mysqldump must be modified manually to remove instances of NO_AUTO_CREATE_USER.
Views	No Issues
Procedures	All Procedures	Dump files created with an earlier version of mysqldump must be modified manually to remove instances of NO_AUTO_CREATE_USER. Reserved keywords whould be changed toMysql supported columns. ex: system,value etc.(identified in Pr_Practioner sp)
Triggers	All Triggers	Dump files created with an earlier version of mysqldump must be modified manually to remove instances of NO_AUTO_CREATE_USER.
Functions	No Issues
Events	All Events	/!50003 SET @saved_sql_mode = @@sql_mode / ;; /!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' / ;

Database Restoration:
- Duration: 2 hours
- Description: Restored the database from the backup created earlier.
Creation of Database Users:
- Description: Created necessary database users with required privileges for operational needs.
Configuration of WildFly:
- Description: Set up WildFly paths for Java and MySQL to ensure proper integration and functionality.
Creation of Shortcuts:
- Description: Created necessary shortcuts on the desktop for quick access to the newly installed tools.

Summary of Time Spent:

Database Backup: 2 hours
Uninstallation: 45 minutes
Installation: 1 hour
Database Restoration: 2 hours
Configuration and Setup: 2 hours
Total Time: 7 Hours 45 Minutes

Next Steps:

Verification:

Ensure all tools are functioning as expected.
Verify database integrity and user access.

Testing:

Conduct thorough testing of the upgraded tools and configurations.
Confirm that all integrations and functionalities are operational.

Documentation:

Installation guide added