RE: [Nagios-devel] MSQL Tables and log files mis-match in data types,
Posted: Tue Apr 02, 2002 10:16 pm
On Wed, 27 Mar 2002, Mark Gillett wrote:
> Thanks for the pointer on the future Ethan, I am not sure how many of the
> Netsaint/Nagios users out here are using the database support, but it seems
> to be a reasonable number. Would you envisage us adding database support as
> a 'patch' or might you consider providing an API against which we could
> implement any other 'storage service' that we might want to play with.
>
> I guess that the alternative might be for someone
to provide a simple
> SQL-->Files bridge (mmmm sounds a bit like mSQL v 0.1) for those who still
> want/need db support.
>
> Personally I am playing with the database as the files get a little clunky
> when writing other analysis code and or interfaces to monitoring/management
> systems other than Nagios
. With the db tables some of these operations
> are much faster (to code and to perform), especially when log-file rotation
> (archiving) is enabled.
>
> Where can the community add most value here ?
>
> Mark
>
I think the config files are files for what Nagios needs from it - an
initilization. A DB -to- config generator could be built very easily
allowing you to maintain you configs in the DB yet use Nagios.
On the log aspects, I tend to favor an option of DB with a single column
table for each entry in addition to the flat files and archive methods.
DB does provide a certain flexibility in generating and sorting for
reporting purposes.
-sg
This post was automatically imported from historical nagios-devel mailing list archives
Original poster: sghosh@sghosh.org
> Thanks for the pointer on the future Ethan, I am not sure how many of the
> Netsaint/Nagios users out here are using the database support, but it seems
> to be a reasonable number. Would you envisage us adding database support as
> a 'patch' or might you consider providing an API against which we could
> implement any other 'storage service' that we might want to play with.
>
> I guess that the alternative might be for someone
to provide a simple> SQL-->Files bridge (mmmm sounds a bit like mSQL v 0.1) for those who still
> want/need db support.
>
> Personally I am playing with the database as the files get a little clunky
> when writing other analysis code and or interfaces to monitoring/management
> systems other than Nagios
. With the db tables some of these operations> are much faster (to code and to perform), especially when log-file rotation
> (archiving) is enabled.
>
> Where can the community add most value here ?
>
> Mark
>
I think the config files are files for what Nagios needs from it - an
initilization. A DB -to- config generator could be built very easily
allowing you to maintain you configs in the DB yet use Nagios.
On the log aspects, I tend to favor an option of DB with a single column
table for each entry in addition to the flat files and archive methods.
DB does provide a certain flexibility in generating and sorting for
reporting purposes.
-sg
This post was automatically imported from historical nagios-devel mailing list archives
Original poster: sghosh@sghosh.org