Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (nike.apache.org: local policy)
Date: Fri, 16 May 2008 11:03:05 +0530
From: Narayanan <V.Narayanan@Sun.COM>
Subject: Re: Replicating Derby Database Files
In-reply-to: <44ed9df20805151132p1c8aeedbg6641b012b7968927@mail.gmail.com>
Sender: V.Narayanan@Sun.COM
To: Derby Discussion <derby-user@db.apache.org>
Message-id: <482D1C91.9070009@sun.com>
MIME-version: 1.0
Content-type: text/plain; format=flowed; charset=ISO-8859-1
Content-transfer-encoding: 7BIT
References: <44ed9df20805150919s30c6f4a5k855ba32936edfad3@mail.gmail.com>
 <482C6F6D.1000008@sun.com>
 <44ed9df20805151132p1c8aeedbg6641b012b7968927@mail.gmail.com>
User-Agent: Thunderbird 2.0.0.14 (X11/20080505)

Sai Pullabhotla wrote:
> Rick,
>
> Thanks for the reply. I briefly looked at the 10.4. documentation and
> it seems that the replication is designed for Derby running as a
> network server. Is this true?
>   
No it is not true. You can run replication in the embedded mode also.
> Our application runs Derby in embedded mode and our customers are
> wanting to replicate the application on a regular basis (as and when
> any file/data changes) to the HA systems. What would be our options
> here to keep the Derby database up-to-date on the HA system?
>   
I am worried about what you mean by up to date here. You see replication 
in derby is
asynchronous, we only promise transaction consistency. You can read some 
more on replication
in derby here

http://wiki.apache.org/db-derby/ReplicationWriteup

You can replicate an existing embedded database following the steps 
listed here. You will find
the combination of the documentation in derby and this wiki 
comprehensive, feel free to raise
any doubts you have.

Narayanan
> Thanks and Regards,
> Sai Pullabhotla
>
> On Thu, May 15, 2008 at 12:14 PM, Rick Hillegas
> <Richard.Hillegas@sun.com> wrote:
>   
>> Hi Sai,
>>
>> Single-node master/slave replication with manual failover was added to Derby
>> in version 10.4. You should not try to manually copy a Derby database which
>> is in use.
>>
>> Hope this helps,
>> -Rick
>>
>> Sai Pullabhotla wrote:
>>     
>>> Hello,
>>>
>>> We have a need to replicate Derby Database from the production system
>>> to the High Availability system. The software we use monitors for any
>>> file changes on the production system and replicates the changed files
>>> to the High Availability system. My question is -
>>>
>>> Is it safe to copy the Derby data files to another system while the
>>> database is in use on the source system? Will the database on the
>>> destination still be usable if we do this?
>>>
>>> Thanks & Regards,
>>>
>>> --
>>> Sai Pullabhotla
>>> www.jMethods.com
>>>
>>>       
>>     
>
>
>
>