Web/Application Servers (RHEL 6)
...
- context - /system/tenure
- shell/sudo access granted to: cahana, em21, duckart, amek, cisd (Jenkins)
Database Servers (MySQL)
The database should still be reachable during hot backups.
Backup info
- mdb74 - cold backup. start 3am, ends ~4:30am
- mdb40 - hot backups. start 3am, ends ~5:40am
| Region | Server | User | Schema |
|---|---|---|---|
| dev | mdb74 | tenure_user | jdbc: mysql://mdb74.pvt.hawaii.edu:3306/ tenuredev |
| ci | mdb74 | tenure_user | jdbc: mysql://mdb74.pvt.hawaii.edu:3306/ tenureci |
| test | mdb74 | tenure_user | jdbc: mysql://mdb74.pvt.hawaii.edu:3306/ tenuretst |
| training | mdb74 | tenure_user | jdbc: mysql://mdb74.pvt.hawaii.edu:3306/ tenuretrn |
| production | mdb40 | tenure_user | jdbc:mysql://mdb40.pvt.hawaii.edu:3306/tenure |
...
| Region | Server | User | schema | Tables/Views |
|---|---|---|---|---|
| test | hrdwdbtst | fppapp | hrdwtst |
|
| prod | hrdwdbprd | fppapp | uhhrdw |
|
Nightly load happens at 1am and monthly load of history tables happens at 1:30am at the end of the month. But the mart is up during the load. Backup is nightly at 2am. It's down for this for about 8min.