First, check what the performance hit is to read the config info from the db everytime you need it. If you have a low-volume sight, or you are hitting the db to serve the page anyway, you may not notice the overhead.

Another solution is to keep the timestamp in your config hash and then decide to refresh from the db every "n" minutes regardless. Then the performance his occurs on a small fraction of the requests.

You could (through stored procedures or your maint page), write the config info to the file system. Then either every request, or comparing timestamps on the file and the hash, refresh as needed.

Or set the apache children to die after "n" requests and when they initalize they can get the current config, etc.

In reply to Re: Synchronizing variables (in mod_perl) across Apache instances? by voyager
in thread Synchronizing variables (in mod_perl) across Apache instances? by risacher

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.