Cluster Support

This appendix describes how to turn off two-phase commit, which is necessary for Ingres Replicator to work properly in a clustered environment.

-TPC Flag—Control Use of Two-phase Commit

Ingres Replicator cannot propagate replications in an cluster environment in the same way that it does in noncluster environments. By default, Replicator Server uses two-phase commit, which is not supported at sites running Ingres Cluster Solution.

Replicator Server has a flag, -TPC, that allows all installations (including Ingres Cluster Solution) to control whether Replicator Server uses two-phase commit.

The -TPC flag can have the following values:

• -TPC0

  Does not use two-phase commit.

• -TPC1

  (Default) Uses two phase commit.

Important! The lack of two-phase commit increases the possibility of loss of data integrity in uncompleted transactions.