How to perform database replication failover.
- You must be an Address Manager administrator to perform database replication failover.
- To perform a failover, the Primary database must be online. If the Primary server is offline, the Primary database is not available, so you cannot log in to the Address Manager web interface on the Standby servers.
If the Primary server is not online, use the reset replication Administration Console command on the Standby server or servers. For more information, refer to Resetting database replication.
To perform a database replication failover:
- Select the Administration tab. Tabs remember the page on which you last worked, so select the Administration tab again to ensure you are working on the Administration page.
- Under Data Management, click Database Management. The Database Management page opens.
- Click Database Replication.The Database Replication page opens.
- Click Database Replication and select Failover. The Switch Primary Database to Standby page opens.
Under Select New Primary Server, select the new Primary
server from the New Primary Server drop-down menu.
The drop-down menu displays the IP address and latency of the Standby servers.
- Click Continue. The Database Replication Failover Confirmation page opens.
If the latency of the Standby server is not 0, the Current latency for the target primary server field appears and displays the latency of the Standby server that will become the new Primary server. The database replication failover occurs once the latency of the Standby server reduces to 0. If the latency does not reduce to 0 or the failover needs to be initiated immediately, click Force to ignore the latency value and perform the failover immediately.
Once the latency reduces to 0 or the Force button is clicked, the database replication failover initiates and the database replication status changes to "Failover is in progress".Note: Once a failover is in progress, navigating to the Database Replication page redirects you to the Failover progress page.