Hi,
> > We noticed that availability/trend reports generated with Thurk via > Livestatus broker module contains strange values that do not reflect the > reality. > Strange, because Thruk calculates reports from log messages. Are all of > your reports wrong or just some? I need to do more tests to answer more precisely, but the problem seems to be for the hosts data, service reports seems ok. I'll let you know our results. > > * What about the Livestatus sqlite database in one year, in > > a big monitoring architecture ? big database, slow queries ? > There's an index on the timestamp, so the performance shouldn't degrade > significantly even if you have lots of data. Of course there should be a > routine that deletes messages that are older than a configurable deadline, > but i hadn't the time to implement it yet. But if you delete logs, you lose historical data for reports generation, it's a bit sensitive (then we fall into the same problems encountered with NDO) > > * What about using Livestatus on top of Simple log, or > > perhaps storing the logs in a couchdb/mongodb database > > instead of a sqlite or any relationnal database ? > Why not, but i think sqlite is no bottleneck and the advantages of other > db backends would be too marginal to justify the extra code. Right. In fact, it's more a problem of keeping logs in a smart, centralized, and secure way, than a problem of performances ;) * Standard log files or couchdb/mongodb are easily manageable * Relationnal databases are more complex and not best suited for this purpose imho. Just my opinion ;) Laurent ------------------------------------------------------------------------------ Learn how Oracle Real Application Clusters (RAC) One Node allows customers to consolidate database storage, standardize their database environment, and, should the need arise, upgrade to a full multi-node Oracle RAC database without downtime or disruption http://p.sf.net/sfu/oracle-sfdevnl _______________________________________________ Shinken-devel mailing list Shinken-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/shinken-devel
