Checking Database Replication Status

This section describes how to check the replication status for a primary cluster:

• Checking the State of the Replica Forests
• Checking the Journal Frames Received from the Primary
• Checking the Update Lag on the Primary

Checking the State of the Replica Forests

Follow these steps to check the state of each replica forest on the replica cluster:

1. On the replica cluster bootstrap host, navigate to the replica database under Databases in the left menu tree.

2. Select the Status tab. The Database Status page appears.

3. Scroll to the Forest Status table area of the page, and check each forest's State column:

Checking the Journal Frames Received from the Primary

Follow these steps to check the current journal frames received by each replica forest from the primary:

1. On the replica cluster bootstrap host, navigate to the replica database under Databases in the left menu tree.

2. Select Database Replication. The Summary tab with the Foreign Master For Database [database] summary page appears.

3. Check these columns in the second table:

   Column	Description
   Foreign Precise Time	The point in time that the foreign primary forest asserted itself as a primary. If local-disk failover is not configured on the primary, then this is the time that the forest was created, last cleared, last rolled back, or some other relevant time. For example, if the foreign primary has local-disk failover configured, then, in addition to the previously mentioned events, this time could be the time of the last failover.
   Foreign FSN (Frame Sequence Number)	The ID of the last journal frame received from the foreign primary. This ID is simply the current count of journal frames.

Checking the Update Lag on the Primary

As described in Replication Lag, the replica cluster sends an acknowledgement to the primary cluster whenever a replicated journal frame has been received and stored. The Lag Limit that you set in your primary cluster configuration specifies that transactions on the primary will be stalled if the primary does not receive an acknowledgement from the replica within the number of seconds specified by the Lag Limit. If the Pending Lag value exceeds the Lag Limit, then new transactions that access the primary database are stalled.

If the XDQP timeout value set for the replica cluster is exceeded, then the replica cluster is assumed to have failed. In this event, the primary cluster detaches from the replica, and transactions continue normally on the primary. When the replica cluster becomes available again, then database replication resumes, and the replica database resynchronizes with the primary database.

You can check for lagging updates at the bottom of the database status page. For example, to check the database replication status of the Documents database, follow these steps:

1. On the primary cluster bootstrap host, navigate to the primary database under Databases in the left menu tree.

2. Select Database Replication. The Summary tab with the Foreign Replicas For Database [database] summary page appears.

3. Compare the Pending Lag to the Lag Limit in the last two columns of the second table. The following table describes these columns:

   Column	Description
   Master Forest (Primary)	The name of the primary forest.
   Replica Forest	The name of the replica forest.
   Pending Frames	The number of unreplicated journal frames.
   Pending Bytes	The number of unreplicated bytes.
   Pending Lag	The number of seconds since the last journal frame was replicated.
   Lag Limit	The current lag limit in seconds set for this database. For details on the lag limit, see Replication Lag.
   Queue Size	The number of unreplicated journal frames waiting to be sent. This value is related to the database replication queue size configuration, which must be between 1 and 1000.
   Send GBytes	The total amount of replication data (in gigabytes) that has been sent from the primary database to the replica cluster.
   Send Time	The elapsed time in ISO 8601 duration format spent sending replication data. Example: PT0S = Period Time 0 Seconds.
   Send Rate	The amount of replication data (in MB per second) being sent by the primary database to the foreign replica cluster. Also known as the Database Replication Send Rate metric.
   Send Load	The time (in seconds) it takes the primary database to send replication data to the foreign replica cluster. This value represents the processing overhead of sending replication data. Also known as the Database Replication Send Load metric.
   Suspended	Whether or not database replication has been suspended: true: suspended; false: not suspended.