ADMINISTERING


Detecting replication delays within a cluster

When a database on one server in a cluster is overdue to be replicated to another server, entries are created in the server log. A group of cluster currency statistics are also available to help proactively spot delays in database replication.

Procedure

Replication delays of four or more hours are reported to the server log. To find these entries, search the log for the string ReplCurrency. Here is an example of aReplCurrency log entry:

[1240:0004-124C] ReplCurrency Source="discussion.nsf", Dest=CN=Server2/O=Renovations (Q:3) discussion.nsf, UpdateToRepl2="07/25/2018 03:12:04 AM", LastRepl="07/24/2018 08:03:28 PM", TimeDiff= 300 min, TimeDiff2=728 min


A repeated ReplCurrency alert for a database can indicate database corruption or a replication problem. In this case, take the following steps to troubleshoot:
Note: It's possible to see a ReplCurrency log entry for a database when a new replica is created if the replication currency check runs before the new replica has fully replicated with all the other cluster replicas. Once the initial replication is complete, the log entries stop occurring.

Several statistics are available to report delays in database replication. Enter the following command at the console of a server in the cluster to see the statistics:

show stat replica.cluster.currency.*

A set of currency statistics reports the time frames within which databases last replicated with each other server in the cluster. Statistics are grouped by server.

For example, the following output shows that all 98 replicas the server has in common with the server Mail2/Renovations replicated within one minute:

[00134C:000008-00000000000004AC]   Replica.Cluster.Currency.Mail2/Renovations.Outside8Hours = 0[00134C:000008-00000000000004AC] Replica.Cluster.Currency.Mail2/Renovations.Uninitialized = 0[00134C:000008-00000000000004AC] Replica.Cluster.Currency.Mail2/Renovations.Within15Min = 0[00134C:000008-00000000000004AC] Replica.Cluster.Currency.Mail2/Renovations.Within1Hour = 0[00134C:000008-00000000000004AC] Replica.Cluster.Currency.Mail2/Renovations.Within1Min = 98[00134C:000008-00000000000004AC] Replica.Cluster.Currency.Mail2/Renovations.Within4Hours = 0[00134C:000008-00000000000004AC] Replica.Cluster.Currency.Mail2/Renovations.Within5Min = 0[00134C:000008-00000000000004AC] Replica.Cluster.Currency.Mail2/Renovations.Within8Hours = 0