db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Matrigali <mikem_...@sbcglobal.net>
Subject Re: Asychronous Replication
Date Tue, 10 Apr 2007 20:15:10 GMT

Chabot, Jerry wrote:
> I'm considering options for asynchronous replication. A low cost option 
> is to freeze the source and target databases,
> synchronize the files using rsync (one way) and unfreeze the databases. 
> Freezing is acceptable given the expected
> usage.
> My concern is existing clients of the target database may see stale 
> data. Is there a need to flag the target clients that
> the files have changed?
> Does anyone see any technical issues with this approach?
It won't work.  From the limited description I am assuming you are 
hoping to allow both the source and target to remain open but inactive
during the process.

The state of an open database is maintained by it's in memory cache, 
data files and log files.  If you just copy over data and log from
source to target and then unfreeze the target you have clobbered the
association of the target's in memory cache and the data/log files.

If freezing the target could include shutting down all connections, then
a cheap solution would be to use derby approved backup mechanism to
backup the data files and the logs to the target and then connect to
the backup at the target using a normal connection - which if the 
database had been closed before would allow normal booting of the 
database which would apply the log and bring up a consistent db.  This 
will of course
overwrite everything that was at target.

> -Jerry
> ------------------------------------------------------------------------
> *
> The information contained in this email message and its attachments
> is intended only for the private and confidential use of the
> recipient(s) named above, unless the sender expressly agrees
> otherwise.
> Transmission of email over the Internet is not a secure
> communications medium. If you are requesting or have requested the
> transmittal of personal data, as defined in applicable privacy laws
> by means of email or in an attachment to email, you must select a
> more secure alternate means of transmittal that supports your
> obligations to protect such personal data.
> If the reader of this message is not the intended recipient and/or
> you have received this email in error, you must take no action
> based on the information in this email and you are hereby notified
> that any dissemination, misuse or copying or disclosure of this
> communication is strictly prohibited. If you have received this
> communication in error, please notify us immediately by email and
> delete the original message.
> *

View raw message