Storing performance data in MySQL


#1

Hi,

Hi,

We are using Fedora Core6 system. We have installed Nagios2.8 with the official plugins nagios-plugins-1.4.11. We have installed mysql-server packages using yum. Also we insalled ndoutils-1.4b7 for connecting nagios with MySQL database. All the related tables of nagios are stored in MySQL database.

Output from MySQL:

mysql> select * from nagios_services;
±-----------±------------±------------±---------------±------------------±----------------±------------------------±-------------------------±-------------------------------±--------------------------±----------------------------------±---------------------------±---------------------------±---------------±---------------±-------------------±-------------------------±----------------------±------------------±------------------±-------------------±-------------------±-------------------±-------------------±------------±-----------------±-----------------±------------------±------------±-----------------------±---------------------±--------------------------±--------------------------±---------------------------±-------------------±--------------------±-------------------------±-------------------------±--------------------±-----------------------±----------------------±----------------------±--------------------------±-----------------------------±----------------------±--------------------±---------------------------±------±----------±-----------±-----------±---------------+
| service_id | instance_id | config_type | host_object_id | service_object_id | display_name | check_command_object_id | check_command_args | eventhandler_command_object_id | eventhandler_command_args | notification_timeperiod_object_id | check_timeperiod_object_id | failure_prediction_options | check_interval | retry_interval | max_check_attempts | first_notification_delay | notification_interval | notify_on_warning | notify_on_unknown | notify_on_critical | notify_on_recovery | notify_on_flapping | notify_on_downtime | stalk_on_ok | stalk_on_warning | stalk_on_unknown | stalk_on_critical | is_volatile | flap_detection_enabled | flap_detection_on_ok | flap_detection_on_warning | flap_detection_on_unknown | flap_detection_on_critical | low_flap_threshold | high_flap_threshold | process_performance_data | freshness_checks_enabled | freshness_threshold | passive_checks_enabled | event_handler_enabled | active_checks_enabled | retain_status_information | retain_nonstatus_information | notifications_enabled | obsess_over_service | failure_prediction_enabled | notes | notes_url | action_url | icon_image | icon_image_alt |
±-----------±------------±------------±---------------±------------------±----------------±------------------------±-------------------------±-------------------------------±--------------------------±----------------------------------±---------------------------±---------------------------±---------------±---------------±-------------------±-------------------------±----------------------±------------------±------------------±-------------------±-------------------±-------------------±-------------------±------------±-----------------±-----------------±------------------±------------±-----------------------±---------------------±--------------------------±--------------------------±---------------------------±-------------------±--------------------±-------------------------±-------------------------±--------------------±-----------------------±----------------------±----------------------±--------------------------±-----------------------------±----------------------±--------------------±---------------------------±------±----------±-----------±-----------±---------------+
| 1 | 1 | 1 | 1 | 5 | Current Load | 19 | 5.0,4.0,3.0!10.0,6.0,4.0 | 0 | | 2 | 2 | | 5 | 1 | 4 | 0 | 60 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | | | | | |
| 2 | 1 | 1 | 1 | 6 | Current Users | 21 | 20!50 | 0 | | 2 | 2 | | 5 | 1 | 4 | 0 | 60 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | | | | | |
| 3 | 1 | 1 | 1 | 7 | PING | 23 | 100.0,20%!500.0,60% | 0 | | 2 | 2 | | 5 | 1 | 4 | 0 | 60 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | | | | | |
| 4 | 1 | 1 | 1 | 8 | Root Partition | 18 | 20%!10%!/ | 0 | | 2 | 2 | | 5 | 1 | 4 | 0 | 60 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | | | | | |
| 5 | 1 | 1 | 1 | 9 | Total Processes | 20 | 250!400!RSZDT | 0 | | 2 | 2 | | 5 | 1 | 4 | 0 | 60 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | | | | | |
| 6 | 1 | 1 | 3 | 10 | Current Users | 21 | 20!50 | 0 | | 0 | 0 | | 5 | 1 | 10 | 0 | 960 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | | | | | |
| 7 | 1 | 1 | 3 | 11 | PING | 23 | 100.0,20%!500.0,60% | 0 | | 0 | 0 | | 5 | 1 | 10 | 0 | 960 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | | | | | |
| 8 | 1 | 1 | 3 | 12 | Total Processes | 20 | 250!400!RSZDT | 0 | | 0 | 0 | | 5 | 1 | 10 | 0 | 960 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | | | | | |
±-----------±------------±------------±---------------±------------------±----------------±------------------------±-------------------------±-------------------------------±--------------------------±----------------------------------±---------------------------±---------------------------±---------------±---------------±-------------------±-------------------------±----------------------±------------------±------------------±-------------------±-------------------±-------------------±-------------------±------------±-----------------±-----------------±------------------±------------±-----------------------±---------------------±--------------------------±--------------------------±---------------------------±-------------------±--------------------±-------------------------±-------------------------±--------------------±-----------------------±----------------------±----------------------±--------------------------±-----------------------------±----------------------±--------------------±---------------------------±------±----------±-----------±-----------±---------------+
8 rows in set (0.00 sec)

Only the details in cfg files are stored in database.

How to store performance data/monitored data from nagios to MySQL?

Kindly help us to solve this problem.