Split the NDO like the archive- and status-files

[Bjoern Richter]

Hi Hendrik,

thats nice, at least I'm not the only one whos thinking about this as a
good idea.

I don't think that a new *.sql file would be the complete solution for
this. Because the tabels with the HEAP-Engine would be lost if the
Nagios-Server goes down. That's why I mentioned earlier a backup of the
status-data in the (INNODB-PART) of the NDO.
I realy think that the NDO should be splitted up into 2 seperate DBs.
This could also be the soltion for the restart problems of Nagios with
NDO-DB greater than 5 GB.

best reguards

Bjoern Richter


> Hi Björn,
> 
> Bjoern Richter schrieb:
> > Hi @all,
> > 
> > i have an idea for the NDO-DB. Why not splitting the NDO in two parts,
> > like the old archive- and status-files. One part of the NDO
> > (INNODB-PART) is for the archive-data and a 5min backup of the
> > status-data and the other part of the NDO (HEAP-PART) is for the actual
> > status data.
> 
> interesting idea but not the newest one.
> 
> I guess some guys from the nagios-portal.org forum 
> (http://www.nagios-portal.org/wbb/index.php?page=Thread&threadID=8518)
> are actually testing the heap stuff and were crazy about the improved 
> performance.
> 
> The only missing thing: The exactly patch of the *.sql file which only 
> puts the "live" tables into the heap.
> 
> Regards,
> Hendrik

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Nagios-devel mailing list
Nagios-devel at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-devel