We are looking at writing our own replacement for Oracle Enterprise Manager.

We want to have a daemon that will run a series of checks against a series of databases on a server. We are thinking of having the checks that are to be run as external perl scripts (so they can be easily modified). The idea being that the controlling Daemon calls the perl scripts for the checks to be run. Each of these scripts performs it's check and writes the results to xml files which are then uploaded by the parent daemon to a central repository.

The idea would look something like this: Start Main Daemon Get Checks and frequency from central database

Does all this sound feasible? How would I go about spinning off these checks from the main daemon? Would I fork processes off the main daemon and connect to the database each time?

Process would look something like:
  Start Controlling Daemon
  Get checks and frequency from central database.
  Wake up and perform any checks that are due.
  Get callback to upload xml file to central repository.

Thanks in advance,
Jason

In reply to Architecture of a Database Monitor by darkman0101

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.