Database Replication
   Next

Database Replication

Guide on how to perform Database replication with XmlBlaster

Michele Laghi

$Revision

Abstract

The following is the documentation of the replication done with xmlBlaster. It will explain the concept and design, monitoring and configuration. It is not a detailed programming guide.

There are several formats of this documentation:

Table of Contents

1. Introduction
2. Design
Terminology and Concepts
The Master/Slave Approach
The Steps in replication
One of the brilliant ideas: The use of Slave Proxies
Relations between ReplManagerPlugin, ReplSlave, DbWatcher and DbWriter
How the relations are created and maintained
The DbResources
Tables
Views
Sequences
Functions
Initial Update (Starting or restarting a Replication)
The Workflow on the initial update
Manual filebased transfer of initial update data
Normal Operations
Synchronous Part: PL-SQL Code
Publishing of replication data
Distribution of replication data
Storage of replicas
3. Monitoring
MX4J Monitoring for Replication
Configuring The MX4JAdaptor
The Replication List Page
The Initial Update Page
The Details Page
Customizing the Monitoring
Further monitoring alternatives
4. Configuration
MOM Configuration
Configuration of Source (Master)
Configuration of Sinks (Slaves)
How to configure Mapping
5. Messages
Data Messages
Initial Update
Administrative Messages
REQUEST_UPDATE
REPL_REQUEST_CANCEL_UPDATE
REPL_REQUEST_RECREATE_TRIGGERS
STATEMENT
INITIAL_UPDATE_START_BATCH
INITIAL_UPDATE_COLLECT
A. Attachments
Alphabetical List of Configuration Parameters

List of Figures

2.1. Replication With XmlBlaster
2.2. Replication Steps
2.3. Relationships between entities
2.4. Initial Update
2.5. Initial Update with manual file transfer
2.6. File structure of Initial Update with manual file transfer
2.7. Sequence Diagram for insert actions
3.1. Replication List Page
3.2. Initial Update Page (simple)
3.3. Initial Update Page (cascaded)
3.4. Details Page

List of Tables

2.1. The Items table
2.2. The Tables Table
2.3. The Longs_Table Table
2.4. Description of major functions
2.5. Content for table. properties
3.1. The Items table
5.1. Attributes of Initial Dump message
5.2. Message Attributes for REQUEST_UPDATE administrative messages
5.3. Message Attributes for REPL_REQUEST_CANCEL_UPDATE administrative messages
5.4. Message Attributes for STATEMENT administrative messages
A.1. Properties used for the replication
   Next
   Chapter 1. Introduction