Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 21746 invoked from network); 14 Jul 2009 14:16:29 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 14 Jul 2009 14:16:29 -0000 Received: (qmail 43914 invoked by uid 500); 14 Jul 2009 14:16:39 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 43861 invoked by uid 500); 14 Jul 2009 14:16:39 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 43853 invoked by uid 99); 14 Jul 2009 14:16:39 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 14 Jul 2009 14:16:39 +0000 X-ASF-Spam-Status: No, hits=-1998.8 required=10.0 tests=ALL_TRUSTED,FS_REPLICA X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 14 Jul 2009 14:16:36 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id CBFCE234C045 for ; Tue, 14 Jul 2009 07:16:14 -0700 (PDT) Message-ID: <1522861195.1247580974831.JavaMail.jira@brutus> Date: Tue, 14 Jul 2009 07:16:14 -0700 (PDT) From: "Kim Haase (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Commented: (DERBY-4196) Document initiation of replication from cleanly shut down database In-Reply-To: <141096071.1241007570351.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-4196?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12730863#action_12730863 ] Kim Haase commented on DERBY-4196: ---------------------------------- Thanks very much, Knut! While I was in the middle of merging the patch to the branch, I did a final check and realized that the documentation of the startSlave attribute has another reference to freezing the database, so I'll need to do another patch after this one. Sorry, I should have checked more thoroughly before. Committed patch DERBY-4196.diff to documentation trunk at revision 793902. Merged to 10.5 doc branch at revision 793905. A second patch will follow. > Document initiation of replication from cleanly shut down database > ------------------------------------------------------------------ > > Key: DERBY-4196 > URL: https://issues.apache.org/jira/browse/DERBY-4196 > Project: Derby > Issue Type: Improvement > Components: Documentation, Replication > Affects Versions: 10.4.1.3 > Reporter: Knut Anders Hatlen > Assignee: Kim Haase > Priority: Minor > Attachments: DERBY-4196.diff, DERBY-4196.zip > > > The admin guide describes how to start replication. > http://db.apache.org/derby/docs/dev/adminguide/cadminreplicstartrun.html > It describes two steps that must be performed before the database is copied from the master to the slave: > 1. Boot the database on the master system > 2. Freeze the database (CALL SYSCS_UTIL.SYSCS_FREEZE_DATABASE()) > Those two steps could be replaced with a single step: > 1-2) Make sure the database on the master system is shut down cleanly > This works because then there is no recovery to be performed when the database later is booted in master mode, and neither the log nor the database will be modified during boot, so the master database will stay completely in sync with the slave. > Advantages with the alternative procedure are: > - no need to keep a process running with the database booted and frozen while copying the database from the master system to the slave system > - uncommitted transactions that are active at the time of the copying won't cause any problems (DERBY-3896) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.