Skip to content

Chapter7.Database Replication

Chapter7.Database Replication

Table of Contents

Introduction
LMS Group

Database Transaction Number

Journal Sequence Number

Stream Sequence Number

Instance Bound Global Directories

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

Stopping the Receiver Filter

Freezing an Instance

Checking Server Health

Changing the Log File

Enabling/Disabling Detailed Logging

Reporting the Current Backlog of Journal Records

Processing Lost Transactions File

Starting the Receiver Server

Starting the Update Process

Stopping the Receiver Server and/or the Update Process

Checking Server Health

Changing the Log File

Enabling/Disabling Detailed Logging

Reporting the Current Backlog of Journal Records

Rolling Back a Replicated Database