Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 10 Current »

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)

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.



  • No labels