FinanceServersMigrationPlan
From Newroco Tech Docs
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.
