Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@jackrabbit.apache.org
Received-SPF: neutral (athena.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.co.uk;
  h=Received:X-Yahoo-SMTP:X-YMail-OSG:X-Yahoo-Newman-Property:From:To:Subject:Date:Message-ID:MIME-Version:Content-Type:X-Mailer:Thread-Index:Content-Language:x-cr-hashedpuzzle:x-cr-puzzleid;
  b=XGZoZ8eP4KYGQ5+D5IuwUYiaAZveTgrexu2Bg3Z/Pg89PsLuAoo8bWk31msYXuW395sj8TI9TcUsV231sTKfi1x1ZBJ/cROlml5NlMsM0IDftUE9fMUv1HmDXFdXhLke/behvxUFRJle7yn2fRi3fQu5M4BvfQWac+CBXJc+nuM=
  ;
From: "Shaun Barriball" <sbarriba@yahoo.co.uk>
To: <users@jackrabbit.apache.org>
Subject: Migrating a 15GB blob store to DataStore backed deployment
Date: Wed, 15 Jul 2009 09:57:20 +0100
Message-ID: <008f01ca052a$438f4ab0$caade010$@co.uk>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0090_01CA0532.A553B2B0"
Thread-Index: AcoFKkHvRFlb2lqTT/+ahePf7XzqYA==
Content-Language: en-gb

------=_NextPart_000_0090_01CA0532.A553B2B0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi all,

We have a 15GB legacy JackRabbit repository currently putting Blobs in the
database (MySql). This is causing the usual pain around a) bloated database
backups, b) huge amounts of temporary files created due to Blob caching, c)
lots of db IO and d) lots of lock contention (due to the IO).

We therefore want to migrate this to a DataStore backed installation.

 
http://wiki.apache.org/jackrabbit/DataStore mentions that:

"Migration: currently there is no special mechanism to migrate data from a
blob store to a data store. The only known way to convert is to export the
data, and re-import into a new repository."

 
.however a 15GB xml file is infeasible to import using "importxml" due to
the memory requirements e.g. it seems to parse the XML in memory.

 
I'd appreciate any bright ideas on how to achieve the migration?

 
Thanks,

Shaun

 
------=_NextPart_000_0090_01CA0532.A553B2B0--