Chapter 7. Database Replication

Revision History
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 “Startup” 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
Examples
Limitations - SI Replication
Replication Architecture
Implementing Replication and Recovery
Application Architecture
System Requirements
Cutover
Instance Freeze
TLS/SSL Replication
Network Link between Systems
Choosing between BEFORE_IMAGE and NOBEFORE_IMAGE journaling
Database Repair
Procedures
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
Checking Server Health
Changing the Log File
Enabling/Disabling Detailed Logging
Reporting the Current Backlog of Journal Records
Rolling Back the Database After System Failures