How do I perform an auxiliary database switchover?

Purpose
CAUTION 

CAUTION

Data Loss

Performing an auxiliary database switchover may result in an data-collection interruption of up to 30 minutes.

Ensure that you perform the switchover directly after the completion of the most recent copy-cluster operation, as described in the procedure.

Perform this procedure to switch the primary and standby roles of a geo-redundant auxiliary database.

Steps
 

Log in to a station that has access to the NSP system.


Open a console window.


A copy-cluster operation is invoked every 30 minutes to replicate the recent data from the primary to the standby auxiliary database cluster.

You must identify the status of the most recent copy-cluser operation in order to determine when to perform the switchover.

Issue the following RESTCONF API call:

Note: In order to issue a RESTCONF API call, you require a token; see the My First NSP API Client tutorial on the Network Developer Portal for information.

GET https://address/RESTCONF/data/auxdb:/auxdb-agent

where address is the NSP advertised address

The auxiliary database cluster status is displayed; a copy-cluster operation is in progress when the status is RUNNING, and is complete when the status is SUCCESS.


Review the status information; if a copy-cluster operation is in progress, return to Step 3; otherwise, identify the most recent copy-cluster completion time.

Note: To minimize data loss during a switchover, you must perform the switchover as soon as possible after the completion of a copy-cluster operation.


Plan to perform the auxiliary database switchover as soon as possible after the completion of a copy-cluster operation.


At the time planned in Step 5, perform the switchover by issuing the following RESTCONF API call:

POST https://address/RESTCONF/data/auxdb:/clusters/cluster=cluster_ID/activate

where

address is the NSP advertised address

cluster_ID is the target-cluster value in the Step 3 command output

The roles reverse; the former standby cluster assumes the primary role.


Close the console window.

End of steps