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.
*
