-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathTODO.txt
101 lines (52 loc) · 2.48 KB
/
TODO.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
TODO for PostgreSQL Secure Monitoring:
Put extra non monitoring specific modules into their own CPAN distribution:
* Config::FindFile
* Log::Log4perl::EasyCatch
* MooseX::DBI
* MooseX::ListAttributes
* Test::PostgreSQL::Starter
More Checks
SQL to STDOUT (or file?) output.
until this, use a dump:
* Start test DB:
* install code, e.g. via:
bin/posemo_install.pl --create_database --create_superuser --superuser=posemo_admin --port=15432 --installation_user=freude --create_user --user=posemo
* pg_dump -s -p 15432 monitoring
* install it
Or install new
* bin/posemo_install.pl --host=$MY_DB_HOST --create_schema --schema=posemo --create_superuser --create_user --superuser=posemo_admin --user=posemo --installation_user=temp --installation_passwd=temp
TODO: Check this: (warning is fixed, but check why $in_host is undef)
ERROR: Perl warning: Use of uninitialized value $in_host in concatenation (.) or string at bin/../lib/PostgreSQL/SecureMonitoring/Run.pm line 520.
ERROR: Perl warning: Use of uninitialized value $in_host in split at bin/../lib/PostgreSQL/SecureMonitoring/Run.pm line 521.
ERROR: Perl warning: Use of uninitialized value $in_host in concatenation (.) or string at bin/../lib/PostgreSQL/SecureMonitoring/Run.pm line 530.
Slave(?):
INFO : Critical values: 0 0 0 0 25.5998 55.8631! in check Cache Hit Ratio for host XXX
INFO : Warning values: 0 0 0 0 25.5998 55.8631 in check Cache Hit Ratio for host XXX
=> by default don't have a critical/warning level for CacheHitRatio?
Performance:
* Add Daemon mode (no startup time, keep all connections open)
* => time based daeomon done; maybe change daemon library;
* => REST-API?
* Add parallel mode: Run Checks on multiple servers parallel.
Frontend connectors / output modules:
Write PostgreSQL output module
* writes everything as JSON?
* or real relational data model?
* JSON seems reasonable.
* Usually there will be no search for single values
* Filter/search only by time
* ??? do some precalculated basic aggregation over hours/days/… ???
* Read and display written data with Graphana?
Check_MK:
* clean up check_mk output module
* integrate python part (T)
Others:
* talk with devs of / write output module for, e.g. ...
* Zabbix
* Icinga
* Prometheus (https://prometheus.io)
* Sensu (https://sensu.io)
* Riemann (http://riemann.io)
Make Version 1.0 ;)
* => pg announce!
Build pg extension?