Second hack of nagios 2 + db

[Ben]

About 2500 hosts and 5600 services. Because of the materialized views, it 
shouldn't matter how large the environment is - as long as the database 
can handle refreshing the views every so often, UI display should be 
almost instant, at least for the overview data.

On Tue, 7 Dec 2004, Marc Powell wrote:

> I too am interested in this. What's your test installation like? How
> many hosts/services?
> 
> Thanks,
> 
> marc
> 
> > -----Original Message-----
> > From: nagios-devel-admin at lists.sourceforge.net [mailto:nagios-devel-
> > admin at lists.sourceforge.net] On Behalf Of Ben
> > Sent: Tuesday, December 07, 2004 3:21 PM
> > To: Matthew Kent
> > Cc: nagios-devel at lists.sourceforge.net
> > Subject: Re: [Nagios-devel] Second hack of nagios 2 + db
> > 
> > Cool, nice to know it's gonna help somebody besides me. :)
> > 
> > Let me know what you do with the bulk insertion/updates.... nagios
> startup
> > times suffer pretty badly the way things are.
> > 
> > On Tue, 7 Dec 2004, Matthew Kent wrote:
> > 
> > > On Tue, 2004-12-07 at 19:27, Ben wrote:
> > > > In case anybody was working with my previous neb database hack,
> you
> > might
> > > > find this one a little more fleshed out. I've added support for
> > hostgroups
> > > > in the UI, as well as current service status, both by service and
> by
> > > > hostgroup. I have yet to get to historical reports, but that's
> next on
> > the
> > > > plate. As it is, I'm already using this interface over the stock
> > nagios UI
> > > > on a daily basis.
> > > >
> > > > The hostgroup support requires a recent copy of nagios-HEAD to
> work.
> > > >
> > >
> > > Oh great, I was just looking at your first version last night, very
> cool
> > > stuff. I love the simplicity of how it interacts with postgres, I
> really
> > > need to learn more about it at some point. Don't get much experience
> at
> > > work as we run a lot of mysql.
> > >
> > > And on that note I'm going to take a stab at implementing your
> current
> > > work and schema with mysql 4.1. It has some features that should let
> me
> > > simplify the logic from previous releases. I'm also interested in
> > > working on some bulk insertion/updates to keep the load down on
> higher
> > > volume setups.
> > >
> > > - Matthew Kent
> > >
> > >
> > >
> > > -------------------------------------------------------
> > > SF email is sponsored by - The IT Product Guide
> > > Read honest & candid reviews on hundreds of IT Products from real
> users.
> > > Discover which products truly live up to the hype. Start reading
> now.
> > > http://productguide.itmanagersjournal.com/
> > > _______________________________________________
> > > Nagios-devel mailing list
> > > Nagios-devel at lists.sourceforge.net
> > > https://lists.sourceforge.net/lists/listinfo/nagios-devel
> > >
> > 
> > 
> > 
> > 
> > -------------------------------------------------------
> > SF email is sponsored by - The IT Product Guide
> > Read honest & candid reviews on hundreds of IT Products from real
> users.
> > Discover which products truly live up to the hype. Start reading now.
> > http://productguide.itmanagersjournal.com/
> > _______________________________________________
> > Nagios-devel mailing list
> > Nagios-devel at lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/nagios-devel
> 
> 




-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now. 
http://productguide.itmanagersjournal.com/