Chapter 7. Database Replication

Revision History
Revision V6.3-007 01 February 2019
Revision V6.3-006 26 October 2018
Revision V6.3-005 03 July 2018
Revision V6.3-004 23 March 2018
Revision V6.3-003 12 December 2017
Revision V6.3-002 22 August 2017
  • In “Instance Freeze”, add that MUPIP REPLICATE -SOURCE -JNLPOOL -SHOW displays the load status of the custom errors file.

Revision V6.3-001 20 March 2017
Revision V6.2-002

Added examples and improved the instructions in “Procedures”.

Revision V6.2-001 27 February 2015

In Starting the Source Server”, added the NOJNLFILEONLY qualifier.

Revision V6.1-000/1 04 September 2014

In “Procedures”, corrected the downloadable scripts example (msr_proc2.tar.gz) for setting up an A→P replication configuration.

Revision V6.1-000 01 August 2014
Revision V6.0-003/1 19 February 2014
Revision V6.0-003 27 January 2014
Revision V6.0-001/1 22 March 1013

Improved the formatting of all command syntaxes and corrected the description of the -helper qualifier.

Revision V6.0-001 27 February 2013
Revision V6.0-000/1 21 November 2012
Revision V6.0-000 19 October 2012
Revision V5.5-000/10 28 September 2012

In “Starting the Receiver Server ”, improved the description of -UPDATERESYNC.

Revision V5.5-000/9 14 August 2012

Improved the description of the replication WAS_ON state and added the “Recovering from the replication WAS_ON state ” section.

Revision V5.5-000/6 19 July 2012

Removed excessive spacing around SVG diagrams in screen and print pdfs.

Revision V5.5-000/5 17 July 2012

Updated for V5.5-000.

Revision V5.5-000/4 6 June 2012

Removed -LOG as an option for -STATSLOG.

Revision V5.5-000/3 2 May 2012
Revision V5.5-000/1 5 March 2012

Improved the description of the -instsecondary qualifier. Added the “Stopping a Source Server” section and the “Shutting down an instance” procedure.

Revision V5.5-000 27 February 2012

In Starting the Source Server”, added information about using external filters for pre-V5.5-000 versions.

Revision 4 13 January 2012

In Starting the Source Server”, added an example of a replication filter.

Revision 2 2 December 2011 Corrected the usage of the term propagating instance, improved the description of -stopsourcefilter, and changed -nopropagatingprimary to -propagatingprimary.
Revision 1 10 November 2011

In the “Procedures” section, changed "Restore the replication instance file" to "Recreate the replication instance file".

Revision V5.4-002B 24 October 2011 Conversion to documentation revision history reflecting GT.M releases with revision history for each chapter.

Table of Contents

Introduction
Database Transaction Number
Journal Sequence Number
Stream Sequence Number
Using Multiple Instances in the same Process
Examples
Limitations - SI Replication
Replication Architecture
Implementing Replication and Recovery
Application Architecture
System Requirements
Switchover
Instance Freeze
TLS/SSL Replication
Network Link between Systems
Choosing between BEFORE_IMAGE and NOBEFORE_IMAGE journaling
Database Repair
Procedures
Download Replication Examples
Setting up an A→B replication configuration with empty databases
Setting up an A→B→C replication configuration with empty databases
Setting up an A→P replication configuration with empty databases
Replicating Instance Starts from Backup of Originating Instance (A→B and A→P )
Switchover possibilities in an A→B replication configuration
Switchover possibilities in a B←A→P replication configuration
Switchover possibilities in a B←A→P→Q replication configuration
Changing the global directory in an A→B replication configuration
Rolling Software Upgrade
Shutting down an instance
Creating a new Replication Instance File
Setting up a secured TLS replication connection
Schema Change Filters
Recovering from the replication WAS_ON state
Rollback data from crashed (idle) regions
Setting up a new replicating instance of an originating instance (A→B, P→Q, or A→P)
Replacing the replication instance file of a replicating instance (A→B and P→Q)
Replacing the replication instance file of a replicating instance (A→P)
Setting up a new replicating instance from a backup of the originating instance (A→P)
Setting up an A→P configuration for the first time if P is an existing instance (having its own set of updates)
Commands and Qualifiers
Turning Replication On/Off
Creating the Replication Instance File
Displaying/Changing the attributes of Replication Instance File and Journal Pool
Starting the Source Server
Shutting down the Source Server
Activating a Passive Source Server
Deactivating an Active Source Server
Stopping the Source Filter
Checking Server Health
Changing the Log File
Enabling/Disabling Detailed Logging
Stopping a Source Server
Reporting the Current Backlog of Journal Records
Processing Lost Transactions File
Starting the Receiver Server
Starting the Update Process
Stopping the Update Process and/or the Receiver Server
Checking Server Health
Changing the Log File
Enabling/Disabling Detailed Logging
Reporting the Current Backlog of Journal Records
Rolling Back a Replicated Database