FinanceServersMigrationPlan: Difference between revisions
From Newroco Tech Docs
Jump to navigationJump to search
| Line 5: | Line 5: | ||
* Install all packages required | * Install all packages required | ||
* Take full DB dumps from the old VMs | * Take full DB dumps from the old VMs | ||
* update all DB functions to use domain names when accessing remote DBs instead of IPs. Former IPs and what they should become: | |||
<pre> | |||
10.0.10.48 finance.thehumanjourney.net | |||
10.0.10.23 timesheets.thehumanjourney.net | |||
10.0.10.42 hrdb.thehumanjourney.net | |||
10.0.10.63 tenders.thehumanjourney.net | |||
10.0.10.130 archives-db.thehumanjourney.net | |||
192.168.98.24 mapdata.thehumanjourney.net | |||
</pre> | |||
* Restore dumps to new 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: | * Edit /etc/hosts and add names and IPs to all VMs involved so they can be addressed by DNS rather than IPs: | ||
<pre> | <pre> | ||
10.0.10.49 finance.thehumanjourney.net | 10.0.10.49 finance.thehumanjourney.net | ||
192.168.98.51 timesheets.thehumanjourney.net | |||
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 | ||
| Line 17: | Line 27: | ||
* Open port 5432 on the firewall (IP restricted) for timesheets to access finance | * 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 | * Open port 5432 on the firewall (IP restricted) for HRDB to access timesheets | ||
* Open port 5432 on the firewall (IP restricted) for tenders to access mapdata | |||
* Test "pull time sheets" script on PMDB interface - this will test both ways finance - timesheets connection | * 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 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 | * Test making changes to projects on PMDB interface - this will test finance RabbitMQ sending messages to archives | ||
* Test making changes to an episode on Tenders interface and see if the changes were transmitted to mapdata into tenders table on oasites DB | * Test making changes to an episode on Tenders interface and see if the changes were transmitted to mapdata into tenders table on oasites DB | ||
* Test sending e-mails from timesheets and from finance | |||
== Steps during down time== | == Steps during down time== | ||
Revision as of 12:10, 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
- update all DB functions to use domain names when accessing remote DBs instead of IPs. Former IPs and what they should become:
10.0.10.48 finance.thehumanjourney.net 10.0.10.23 timesheets.thehumanjourney.net 10.0.10.42 hrdb.thehumanjourney.net 10.0.10.63 tenders.thehumanjourney.net 10.0.10.130 archives-db.thehumanjourney.net 192.168.98.24 mapdata.thehumanjourney.net
- 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 192.168.98.51 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 192.168.98.24 mapdata.thehumanjourney.net
- 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
- Open port 5432 on the firewall (IP restricted) for tenders to access mapdata
- 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
- Test making changes to an episode on Tenders interface and see if the changes were transmitted to mapdata into tenders table on oasites DB
- Test sending e-mails from timesheets and from finance
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.
