ASE Replicator processing

Figure 1-3 illustrates the transaction replication process with ASE Replicator.

Figure 1-3: ASE Replicator transaction replication process

  1. The Publisher component reads the primary database’s native Adaptive Server transaction log and builds transaction metadata and operation records that describe the primary transaction.

  2. The Publisher component writes the transaction metadata in the transaction log table and the transaction operation data in the shadow table (or tables) in the Distribution Database.

  3. The Distributor component reads the metadata in the transaction log table, determines the transaction to be applied to a replicate object, then executes the distribution procedure associated with the replicate object.

  4. Distribution procedures read the transaction operation data in the shadow tables, then apply the replicated transaction operations to the CIS proxy tables in the Distribution Database.

  5. CIS propagates the replicated transaction operations in the proxy tables to the replicate tables in the replicate database.

This process describes replication for transaction operations that change the data in tables. The stored procedure replication process is slightly different.

Instead of applying operations to a CIS proxy table, the distribution procedures for stored procedure replication issue remote procedure calls (RPCs) to the replicate database.