It will introduce some latency, but if you can't move your app off this server why not move you database to a server that gives you space to work? Your db does /not/ have to be on the same box as your app these days ;).

On the otherhand, think of creative solutions around it - is your db size limited to 100mb, or is that your quota? Low volume sites can get by with sqlite, which is simply a local file in your home directory.

That said, I've never thought about how to manage distributed dbs. Assuming there is a single, centralized app using them, the problem is actually a pretty simple one since you really only have to maintain state knowledge at a single point. The trouble comes in when you want to start doing fancy relational things with the data, since you are in effect breaking the link among related tables that containing them in the same db provides.

A brute force solution would have you keeping only a single table (or part of a single table) on each db (provided they don't need more than 100mb each). This would render the "relational" part of the RDBMS mostly ineffective, unless you included small look up tables on each of these single table dbs (or had a single db for each look up table). In the end, trying to make things relational would force you to reimplement a lot of this functionality in your app (poorly).

In reply to Re: Virtual/distributed database with DBI by perlfan
in thread Virtual/distributed database with DBI by dsheroh

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.