Announce: new DB-based Configuration System (beta)

[Ian Holsman]

yep.. sounds like a good idea Ben.
most of the R-I currently is done via Class::DBI in the perl wrappers,
but it never hurts to do add it at the DB level.


On Thu, 17 Jun 2004 08:53:17 +0100, Ben Clewett <ben at clewett.org.uk> wrote:
> 
> 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 at op5.se> 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
> > Nagios-devel at lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/nagios-devel
> >
> 
> -------------------------------------------------------
> 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
> Nagios-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-devel
>


-------------------------------------------------------
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