Re: [Perfparse-users] Using PerfParse with data base replication

[Ben C. <Be...@cl...>]

Hi Ricardo,

I am happy you may be a fan.  Let me see if I can answer you in line:

Ricardo David Martins wrote:

> Hi,
> 
> i've been making some tests on Nagios and I now understand that Nagios doesn't
> log all external data to data base and neither keeps a history log on
> a data base.

Correct.  I believe Nagios uses text based log files, which it parses to 
find state change information.  Which is incredibly slow.  It stores no 
history of performance data in any way.  PP does both using a structure 
in a RDBMS system: MySQL.

> For this matter i came to understand that the only option for me is to
> use PerfParse. Knowing this i have came across with some questions.
> 
> Will PP have at all time needed logging information of Nagios checks in a MySQL
> data base?

PP reads a formatted log file defined in nagios.cfg: 'serviceperf.log'. 
  This is currently parsed once every n minutes and the information 
stored in the DBMS.  This keeps a mirror of the current and all past 
output produced by the plugins.  It also parses the performance data 
into a binary table used to draw graphs.

This is stored for an unlimited variable time period, from one day to 
the life time of the server being monitored.  Depending on the disk 
space and performance of your MySQL server.

In the future our lead developer is working on ways of parsing without a 
delay into the DBMS and into other user definable data storage systems.

> Will PP's MySQL requirements comply to MySQL replication procedures
> requirements?

If you are discussing using a shadow MySQL server to replicate off a 
primary source:  Yes this is safe.

We don't use MySQL temporary tables or local SQL commands which can 
cause replication to stop.  Although unfortunately we use 100% InnoDB so 
the MySQL replication command 'CATCH UP' (?) will not work.  But there 
are other methods.

If there are any other issued regarding MySQL replication, let me know 
and I will research these.

> If this is so, i will be a PerfParser fan. I am trying to make a
> redundant fail over architecture of nagios on a production
> environment. For this solution i need mysql replication procedures.

If there is anything missing, please remember that we are not at version 
1.0.0 and this will not occur until users are happy with a base product. 
  So please join the party and let us know what we can do for you.

Regards,

Ben Clewett.



> 
> Many thanks
> 
> --
> Ricardo David Martins
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by BEA Weblogic Workshop
> FREE Java Enterprise J2EE developer tools!
> Get your free copy of BEA WebLogic Workshop 8.1 today.
> http://ads.osdn.com/?ad_id=5047&alloc_id=10808&op=click
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
>