FinanceServersMigrationPlan: Difference between revisions
From Newroco Tech Docs
Jump to navigationJump to search
Line 12: | Line 12: | ||
10.0.10.43 hrdb.thehumanjourney.net | 10.0.10.43 hrdb.thehumanjourney.net | ||
10.0.10.180 tenders.thehumanjourney.net | 10.0.10.180 tenders.thehumanjourney.net | ||
10.0.10.130 archives-db.thehumanjourney.net | |||
</pre> | </pre> | ||
* Move timesheets into SSN | |||
* Open port 5432 on the firewall (IP restricted) for timesheets to access finance | |||
* Open port 5432 on the firewall (IP restricted) for HRDB to access timesheets | |||
* Update /etc/hosts on all VMs with the new IP address for timesheets | |||
* Test "pull time sheets" script on PMDB interface - this will test both ways finance - timesheets connection | |||
* Test making changes to staff on PMDB interface - this will test HRDB connection to timesheets, admin, finance and also RabbitMQ sending messages from Finance to tenders and archives | |||
* Test making changes to projects on PMDB interface - this will test finance RabbitMQ sending messages to archives | |||
== Steps during down time== | == Steps during down time== |
Revision as of 11:56, 18 May 2017
Overview
Steps before down time
- Create the VMs according to their needs
- Install all packages required
- Take full DB dumps from the old VMs
- Restore dumps to new VMs
- Edit /etc/hosts and add names and IPs to all VMs involved so they can be addressed by DNS rather than IPs:
10.0.10.49 finance.thehumanjourney.net 10.0.10.24 timesheets.thehumanjourney.net 10.0.10.43 hrdb.thehumanjourney.net 10.0.10.180 tenders.thehumanjourney.net 10.0.10.130 archives-db.thehumanjourney.net
- Move timesheets into SSN
- Open port 5432 on the firewall (IP restricted) for timesheets to access finance
- Open port 5432 on the firewall (IP restricted) for HRDB to access timesheets
- Update /etc/hosts on all VMs with the new IP address for timesheets
- Test "pull time sheets" script on PMDB interface - this will test both ways finance - timesheets connection
- Test making changes to staff on PMDB interface - this will test HRDB connection to timesheets, admin, finance and also RabbitMQ sending messages from Finance to tenders and archives
- Test making changes to projects on PMDB interface - this will test finance RabbitMQ sending messages to archives
Steps during down time
Steps after down time
- Test all interfaces work well
- Test special functions that might no longer work
- Make staff changes in HRDB and check if the change was propagated to TRS, Finance, Admin DB on Finance VM, Tenders, Archives
- Make project changes on Finance and see if the change was propagated to Archives - this checks if RabbitMQ worked well
- Monitor any support tickets related to any of these services and first find a cause in the migration done.