Task #1668
closed
StatisticalManager DB: monitoring via nagios
Added by Roberto Cirillo over 9 years ago.
Updated over 8 years ago.
Assignee:
_InfraScience Systems Engineer
Category:
System Application
Infrastructure:
Production
Description
The statisticalManager db should be monitored by nagios. it is a postgres db hosted on
db5.p.d4science.research-infrastructures.eu
Files
- Tracker changed from Support to Task
- Priority changed from Normal to High
- Assignee changed from Tommaso Piccioli to _InfraScience Systems Engineer
There are four databases on that server but only dataSpace seems to be in use:
aquamapsorgupdated | utente | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
dataSpace | gcube | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | postgres=CTc/postgres+
| | | | | =c/postgres
testdb | gcube | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
timeseries | gcube | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
Is it correct?
- Status changed from New to In Progress
- % Done changed from 0 to 80
- Status changed from In Progress to Feedback
The ganglia and nagios checks are in place. Please let me know about the various databases status.
Wrote a routine that queries the IS and looks for database declarations in ServiceProfiles.
Checks are done by same dbName, same host (both checking hostname and resolved Ip).
The report in attachment shows also matching dbName but different host.
It seems to me that "dataspace" and "testdb" are used in production environments, while "aquamapsorgupdated" and "timeseries" are probably copied from development instances but are not used.
I skipped checking "postgres", "template0" and "template1".
- Status changed from Feedback to Closed
OK, I've put under nagios all the existing databases.
- % Done changed from 80 to 100
Also available in: Atom
PDF
Updated by 
Updated by 
Updated by 
Updated by Fabio Sinibaldi 
