nagios future?

[Andreas Ericsson]

Michael Friedrich wrote:
> 
> 
> Andreas Ericsson wrote the following on 09.06.2009 19:03:
>>
>> Well, it'll be ambiguous even if one char is stripped from it, so just
>> cutting the name at 30 chars might be worthwhile if we're on oracle.
> 
> Don't forget the table_prefix - current default is "nagios_" but I don't 
> know if this will change (I think it's a rather useless prefix unless 
> you have more different "collectors").

Merlin has no table prefix. We feel that if you're managing the network
monitoring server, you have the right to demand a separate database for
it of the DBA's. table-prefixes are quite handy for things such as forums
and blogs which are sometimes hosted by home-users on free hosting sites
where each user gets full access to one database but has no possibility
to create more. I find it extremely unlikely that Nagios+Merlin will ever
be installed in an environment where that is the case.

> Naturally it's better taking "telling names" for tables, variables, and 
> so on. But everyone who has to program the source will hate it, so 
> shorter names with table description are more useful imho.
> 
>> Well, unless I'm mistaken IDO will have the same database layout as NDO,
>> so it will still suck for performance, and writing good queries for it
>> will still be a major headache. When the storage model of the algorithm
>> algorithm is broken, tweaking it doesn't really help. Only a rewrite
>> can save you then.
>
> Yep I know what you are saying and if anyone over here would allow me to 
> do it I would.

Well, Merlin *is* a rewrite. It doesn't reuse any code at all from NDOUtils
and it does scale a *lot* better. It replaces NDOUtils for all GUI-related
activities we do at op5, and the database related parts of the GUI code
that was previously so arcane it was impossible to debug is now rather
straight-forward.

> Looking at the ongoing process of kicking the NDO and using something 
> new doesn't really fit to my plans. But anyway currently Icinga fits the 
> most for our concerns because there are no ressources available to 
> create a new NDO or similar (I'd be happy only having this project and 
> nothing else like coding DNS tools ;-)

How can Icinga fit your needs when the underlying model is broken?
Sorry, but I just don't get it.

>>
>> It would be neat to see Merlin adapted to Oracle though, so if you're
>> interested in working on that we'd sure help as much as we can.
> I will share my knowledge meanwhile in Icinga GIT (when DB schema is 
> defined, and the code can be merged and optimized) for testing. So far 
> it is all the same with libdbi. A first howto on the libdbi driver for 
> Oracle can be found here - kind of tricky:
> 
> https://dev.icinga.org/issues/show/108
> 

Looks simple enough. Perhaps it'd be worthwhile to test the experimental
Oracle support in Kohana as well to see if we can get Merlin+Ninja up
and running fairly quickly. Assuming PHP has Oracle support (which it
does), I really don't see any issues with that here.

> Some code optimzations for IDO have already been applied by Hendrik 
> (driver loaded successfully, fixed segfaulting and so on) so the 
> debugging is getting easier.
> 
> And even if I have to modify the libdbi itsself for the usage of 
> parameter bindings (which is heavily used for Oracle e.g.) Merlin could 
> also profit from that...
> 

I'd prefer if Merlin can use a driver-agnostic layer. Otherwise one would
have to add support for multiple drivers in Merlin.

There's also the fact that we lack an oracle database to test against,
so whoever adds oracle support to Merlin and Ninja will have to be
someone else than me.

-- 
Andreas Ericsson                   andreas.ericsson at op5.se
OP5 AB                             www.op5.se
Tel: +46 8-230225                  Fax: +46 8-230231

Considering the successes of the wars on alcohol, poverty, drugs and
terror, I think we should give some serious thought to declaring war
on peace.

------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null