Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-4196

Document initiation of replication from cleanly shut down database

    XMLWordPrintableJSON

    Details

    • Urgency:
      Urgent

      Description

      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)

        Attachments

        1. rrefattribstartslave.html
          6 kB
          Camilla Haase
        2. DERBY-4196-2.diff
          0.6 kB
          Camilla Haase
        3. DERBY-4196.zip
          5 kB
          Camilla Haase
        4. DERBY-4196.diff
          4 kB
          Camilla Haase

          Issue Links

            Activity

              People

              • Assignee:
                chaase3 Camilla Haase
                Reporter:
                knutanders Knut Anders Hatlen
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: