Table of Contents Previous Next


6 Multi-Master Replication Operation : 6.12 Optimizing Performance

The publication server configuration options are set in the publication server configuration file. See Section 10.4.1 for a detailed explanation of how to set the configuration options in this file.
The uniquenessConflictDetection option determines if uniqueness conflict needs to be detected at data load time or should be deferred to when data is applied against a target master node. Possible values are EAGER and LAZY. Set it to EAGER if there is a high probability of duplicate inserts across master nodes.
When the number of master nodes is greater than two, then the conflict detection is always performed in EAGER mode. (A LAZY mode setting is ignored.) This is primarily required to avoid removing the already replicated conflicted changes from a target node, which otherwise is an expensive option.
The default value is LAZY when the number of master nodes is two.
The skipConflictDetection option controls whether or not to skip conflict detection during synchronization replication. The default is false and should be changed only when the probability of data conflict across master nodes is zero. For example if each master node operates on an independent set of data then turning on this option improves the replication time.
In a multi-master replication system, if a deadlock is detected on a target master node, the deadlockRetryCount option controls the number of times the publication server attempts to retry application of the changes in the current replication cycle after waiting for the number of milliseconds specified by deadlockWaitTime. Set deadlockRetryCount to 0 to turn off this option in which case the failed changes are attempted in the next replication cycle.
The deadlockWaitTime option is used with the deadlockRetryCount option to set the wait time in milliseconds before the publication server attempts to retry application of the changes on the target master node.

6 Multi-Master Replication Operation : 6.12 Optimizing Performance

Table of Contents Previous Next