Re: [Nagios-devel] Announce: new DB-based Configuration System (beta)

[Ben C. <Be...@cl...>]

Dear Ian,

You request some feedback.  I have looked at the schema and I was just 
wondering whether you might want to consider adding a PRIMARY KEY to all 
tables, as well as some FOREIGN KEY definitions to join the tables together?

Although the schemas will work perfectly without these, this will help 
the DBMS forming good JOINs where requested, speeding up queries.  This 
will also introduce referential integrity.  Which will stop corruption 
(miss-linked information and missing linked information) being entered 
into the system either as user error or a programatical error.

I use these ideas as standard on all work I do, in the context of OSS 
projects and my paid-work, and find this can make an enormous difference 
in the long run.

Regards, Ben Clewett.

Ian Holsman wrote:

> On Wed, 16 Jun 2004 11:55:12 +0200, Andreas Ericsson <ae...@op...> wrote:
> 
>>Ian Holsman wrote:
>>
>>>-----BEGIN PGP SIGNED MESSAGE-----
>>>Hash: SHA1
>>>
>>>This requires a patched up version of nagios 1.2 which can read it's
>>>configuration from a MySQL db.
>>
>>Have you managed to get it in 3NF, and if so, can you supply either a
>>logical chart or the physical schematics?
>>
> 
> it is mostly in 3NF
> the schema is available here:
> http://svn.webperf.org/WebSVN/listing.php?repname=Nagios&path=/trunk/schema/&rev=0&sc=1
> 
> the only 'add-on' which isn't really in nagios is the concept of
> applications and systems.
> a system is a collection of hostgroups.
> 
> an application is the description of a app (say a apache webserver, or
> a tomcat appserver) which runs on multiple hostgroups, but maybe on
> different ports, and with different people responsible for it.
> a 'VIP' refers to a load balancer group (usually how other things
> access your group of machines) and have a more strict set of check
> times/notifications
> 
> Regards
> Ian
> 
> ps.. feedback is welcome, and if there is enough interest I'll set up
> a mailing list (or we can just discuss it here if thats ok)
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by The 2004 JavaOne(SM) Conference
> Learn from the experts at JavaOne(SM), Sun's Worldwide Java Developer
> Conference, June 28 - July 1 at the Moscone Center in San Francisco, CA
> REGISTER AND SAVE! http://java.sun.com/javaone/sf Priority Code NWMGYKND
> _______________________________________________
> Nagios-devel mailing list
> Nag...@li...
> https://lists.sourceforge.net/lists/listinfo/nagios-devel
>