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.erics...@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@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
