Nagios with MySql backend

Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
Locked
bcdudley
Posts: 10
Joined: Thu Apr 11, 2013 1:17 pm

Nagios with MySql backend

Post by bcdudley »

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?
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: Nagios with MySql backend

Post by abrist »

This wheel has already been invented.
I think you should check out:

Historical data in sql: ndoutils
Configs in sql: nagiosql
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
bcdudley
Posts: 10
Joined: Thu Apr 11, 2013 1:17 pm

Re: Nagios with MySql backend

Post by bcdudley »

That is what I was hoping for. I will check it out. Thank you.
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: Nagios with MySql backend

Post by slansing »

Let us know how integration goes.
Locked