db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Oskar Zinger <oska...@yahoo.com>
Subject Derby Replication - Freeze DB or Shutdown - Best Practice?
Date Wed, 23 Jan 2013 02:39:51 GMT
I'm using Derby Replication in my product and trying to figure out what is the best approach
for "stopping" the database before starting replication (before copying the database from
Master to Slave).

I'm currently using "shutdown" approach... as described in the following Derby 10.8 documentation
(it says to make sure the database is shutdown cleanly):

If you look at the Derby replication write-up - it tells you to "freeze the DB" using command
"call SYSCS_UTIL.SYSCS_FREEZE_DATABASE(), here is the write-up I'm referring to:

These two seem to be conflicting... and therefore the question: what is the best practice
to "stopping the db" before the start of replication?

Also, when you think about it, when you shutdown the DB before copying the database and starting
replication, what if there is a thread running in JVM that will reboot the database before
you get a chance to copy the database, and when you finally start replication - then the databases
will be again out of sync. This did not actually happen to me in practice, but I think theoretically
it is possible. So does it mean freeze is better? And then do I need to unfreeze it?

Oskar Zinger
View raw message