/
Environments

Environments

Owned by Cameron Ahana
Last updated: Jun 16, 2021

Web/Application Servers (RHEL 6)

RegionServerProxyUserURL
test

its97

web70tenuredhttps://www.test.hawaii.edu/tenure
trainingits97web70tenuretrngdhttps://www.training.hawaii.edu/tenure
productionits22web30, 31, 32, 33, 34tenured

https://www.hawaii.edu/system/tenure or

https://tenure.hawaii.edu/

  • 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
RegionServerUserSchema
devmdb74tenure_userjdbc: mysql://mdb74.pvt.hawaii.edu:3306/ tenuredev
cimdb74tenure_userjdbc: mysql://mdb74.pvt.hawaii.edu:3306/ tenureci
test

mdb74 

tenure_userjdbc: mysql://mdb74.pvt.hawaii.edu:3306/ tenuretst
trainingmdb74 tenure_userjdbc: mysql://mdb74.pvt.hawaii.edu:3306/ tenuretrn
productionmdb40 tenure_userjdbc:mysql://mdb40.pvt.hawaii.edu:3306/tenure

HR Datamart (Oracle)

RegionServerUserschemaTables/Views
testhrdwdbtstfppapphrdwtst
  • edadba.psempl
  • edadba.psethnicity
  • edadba.hr_ps_report_tbl
prodhrdwdbprdfppappuhhrdw
  • edadba.psempl
  • edadba.psethnicity
  • edadba.hr_ps_report_tbl

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.