NWU VV Architecture Maintenance Upgrade

Project Description

The request was initiated by Mari Prinsloo

The access Alignment project is underway (due date is Oct 2015). To implement the functionality has a high risk on the VV infrastructure, and involves the roll out of VV on the other campuses. The infrastructure has to be reviewed.

Documents

No documents at this time.

Project Progress

100%

Project Timing

  • Start
    Jun 01 2015
  • End
    Feb 29 2016

06/01/2015 02/29/2016

100%

Overall Project Completion

  • 20%
  • 60%

100%

  • 40%
  • 80%

1. Phase 1 - Analysis and Gaps Complete 100% Tasks 0 / 0

100%
Description

This phase encapsulates the joint efforts by BSS and OI to analyze the current architecture and identify the potentials areas that need to be addressed / improved.

Based on the feedback of this phase a pathway for upgrades will be identified and the required priorities will also be assigned to each area in accordance with the value add it has to the business of NWU

2. Phase 2 - NWU Vending / SAS DB Environment Upgrade Complete 100% Tasks 8 / 8

100%
Description

The analysis phase identified the existing SQL Database environment for NWU Vending / SAS as a key strategic area to upgrade. The environment has been running on outdated hardware and technology for a while.

On top of this the decision was made that we would like to do away with the clustered environment to simplify the architecture as a whole and remove the complexity of supporting this environment on both the BSS and OI side.

The following path / work tasks were identified:

  • Creation of a new SQL DB VM environment in the existing ESXi Cluster which will include a number of assumed upgrades (better storage technology, improved memory, improved processing, improved storage capacity)
  • Configuration of newly created environment to match that of the current PROD environment
  • Configuration of reporting services to match that of the current PROD environment
  • Configuration of all DNS entries, firewall exception, hostnames, integrations and other systems that form part of the NWU / VV SAS eco-system
  • Database clean-up (users, retired DB jobs etc.)
  • End-to-end testing of the new environment to ensure all the functionality currently available is working
  • Swopover from old environment to new environment
  • TLC and monitoring of new environment

 

8 of 8 completedTasks

  • Creation of new SQL DB VM environment in existing ESXi Cluster
  • Configuration of new environment to match PROD
  • Configuration of reporting services to match PROD
  • External configurations of new environment
  • Database clean-up
  • End-to-end and UAT testing
  • Live swopover to new environment
  • TLC and monitoring

Project Discussion 7 Responses to NWU VV Architecture Maintenance Upgrade

  1. @ Yvette. Project Completed. Upgrade was successful.

    April 15, 2016 at 2:49 pm
    KARL VAN DER MERWE
  2. 13 March 2016
    06:00 Restore of DB to new environment + DNS Swap
    07:00 Reactivation of all services
    07:15 Sanity testing of all services
    08:00 Confirmation of swap success
    08:15 – 10:00 possible Rollback if problems occurred.

    March 11, 2016 at 3:43 pm
    KARL VAN DER MERWE
  3. Preparations and testing completed. Scheduled to go live on Sunday. The upgrade starts at 06:00AM and will finish at 10:00AM

    March 11, 2016 at 3:42 pm
    KARL VAN DER MERWE
  4. Server and DB configs ready for testing. Waiting for final release on TEST to be completed befoe app server can be pointed to new server fro full end to end testing. Project still aims to be completed end of the month.

    February 12, 2016 at 4:02 pm
    KARL VAN DER MERWE
  5. @Yvette Weens hoe landing van registrasie werk het ons datums oorvloei. Nuwe datums kuif dus aan na 2016/02/29. Ek het die projek ook so opdateer, ons werk dan verder aan die projek sodra die eerste week van registrasie agter die rug is. Dankie

    January 21, 2016 at 12:22 pm
    KARL VAN DER MERWE
  6. @Yvette please add Karl van der Merwe to this project. He’ll obviously be involved and it would be great if he can update accordingly.

    December 18, 2015 at 8:41 am
    JEAN RAATH
  7. The scope and implementation complexities encountered as part of the NWU SAS Alignment project has forced us to push out the upgrade implementation to later this year. It was initially proposed to be handled in parallel with the alignment project but that was simply not possible.

    The remaining tasks of Phase 2 are currently underway and we will provide feedback once we reach the next logical point in the process

    October 23, 2015 at 2:42 pm
    JEAN RAATH

Leave a Reply