It seems to me that you could increase the robustness of the system if your program could take responsibility for keeping track of recent transactions and the processing involved to ensure multiple asynchronous requests and the related subrequest processing is handled correctly.

How about using a BerkelyDB to store those transactions in a btree (or something simpler if you use integer keys) and use some more tablespace for a scratchpad?

BerkelyDB is not an RDBMS but is a fast, powerful, persistent store. Mysql happens to use it too. It can save you from file open/close and synchronization problems too. Your program could run as a daemon or possibly even a called on demand program which saves its state in that scratchpad. You could schedule it to wake up periodically for sanity checks.

it may be more than you need but you also might consider Alzabo::ObjectCache::Sync::BerkeleyDB. This synchronizes multiple processes' use of a single object store and can also use a file instead of a BerkeleyDB.

In reply to Re: Persisten sequential transaction id generator by mattr
in thread Persistent sequential transaction id generator by mitd

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.