[Mulgara-general] Spanning multiple disks

[Life is hard, and then you die]

On Mon, Jun 30, 2008 at 10:07:27AM -0500, Paul Gearon wrote:
> On Mon, Jun 30, 2008 at 9:47 AM, Chuck Borromeo <cborromeo3 at yahoo.com> wrote:
> > Hello,
> >  Can Mulgara support spanning its data directories (xaStatementStore, xaStringPool, etc.) across multiple disks?  I am concerned that having all my data on one disk will result in my queries becoming I/O bound.  If it can support this, is there a suggested methodology for splitting up the directories across multiple disks?  I am using the Mulgara 2.0 alpha release.
> 
> Unfortunately, no, and you're right.... it does create an I/O problem.
> 
> We were planning on doing this (it's really just a matter of
> configuration), but put it off since we are in the process of building
> a new filesystem structure.  If there is real call for it, then I'm
> sure I can convince my boss to let me have the time for it, as it
> should only take a couple of days to get it done.

Actually you don't need to do anything in mulgara for this: just
use symlinks to point the directories and/or files to the different
locations.

So I think the question really just is: what is the best way to split
things up? I guessing a first good split would be put the xsStringPool
and xaStatementStore directories on different disks. After that, it
probably depends a bit on your operations and data.


  Cheers,

  Ronald