Nagios with MySql backend
Posted: Thu Apr 11, 2013 2:45 pm
Hello,
I used to use Nagios heavily on our network of 300 users at 90 locations. I gave up on it because of the difficulty involved in maintaining the data files for all the locations. Now we have grown up and have 5000 users and 650 locations. I need to have a Nagios like program. We currently keep a seperate database that has all of the data that Nagios would ever need for monitoring.
My thought is to have some type of job (Think DTS jobs from M$ SQL) that can pull the data over into a MySql backend. These databases are updated on a daily and sometimes hourly basis and from numerous sources. Trying to keep up with all these updates manually would not make sense. A daily import job would make sense.
Can Nagios Core even run from a Sql backend, or do I need to find a way to pull the data and write it to the text files?
I used to use Nagios heavily on our network of 300 users at 90 locations. I gave up on it because of the difficulty involved in maintaining the data files for all the locations. Now we have grown up and have 5000 users and 650 locations. I need to have a Nagios like program. We currently keep a seperate database that has all of the data that Nagios would ever need for monitoring.
My thought is to have some type of job (Think DTS jobs from M$ SQL) that can pull the data over into a MySql backend. These databases are updated on a daily and sometimes hourly basis and from numerous sources. Trying to keep up with all these updates manually would not make sense. A daily import job would make sense.
Can Nagios Core even run from a Sql backend, or do I need to find a way to pull the data and write it to the text files?