Was this helpful?
Replicator Concepts
To create a successful replication scheme, it is important to understand concepts and terms used in Replicator.
Key Ingres Replicator concepts are as follows:
Collision
A collision is an event that occurs when more than one user updates the same replicated row in different databases. Ingres Replicator can preserve the history of changes made to each replicated row. If the same rows in two databases do not match in the last transaction, Ingres Replicator detects a collision.
For more information, see Collision Design on page 6.
Consistent Distributed Data Set (CDDS)
A CDDS defines what data is replicated and where it resides.
The CDDS is the unit of organization in Ingres Replicator. Various processes, such as collision and error handling, are specified at the CDDS level.
For more information, see Consistent Distributed Data Set (CDDS).
CDDS Target Type
A target type defines which database within a CDDS is allowed to alter the data and how Ingres Replicator acts on each database within the CDDS.
The target types are:
Full peer—generates changes to be replicated, accepts replicated changes and can detect collisions
Protected read-only—accepts replicated changes and can detect collisions
Unprotected read-only—accepts replicated changes but cannot detect collisions
A CDDS has a target type defined in every database that is contained in the CDDS. You must define target types for each CDDS. For more information, see CDDS Target Types.
Data Propagation Path
A data propagation path defines what route the data takes to reach target databases within a CDDS.
For more information, see Data Propagation Paths in the CDDS.
Replicated transaction key (replication key)
To identify information specific to Ingres Replicator during processing of a replicated row, the system generates a key for each such row.
The key consists of:
A database number that identifies the replicated database that manipulated the row
The ID of the DBMS Server transaction that manipulated the row
The sequence number within the transaction
For more information, see Change Recorder.
Other concepts...
The section Replicator Components defines these concepts:
Change Recorder
distribution threads
Replicator Server
The section Replicator Processing Tables defines these concepts:
base table
shadow table
archive table
input queue
distribution queue
Last modified date: 01/30/2023