Configuring Database Failover

To edit the configuration on the ISR API and Archival deployments to include database failover:

1. Using a secure shell (SSH) client, log into the RSS or FACE host/s using a user name and password.
2. To add the secondary database IP address to the API configuration, edit the following file.

   /var/lib/tomcat/webapps/IsrApi/WEB-INF/web.xml

3. Using the arrow keys to navigate the file and edit the following line with the relevant IP addresses:

   <context-param>
       <param-name>connectionString</param-name>
       <param-value>jdbc:mysql://169.254.1.50,<secondary_host_IP>/ipcr_db</param-value>
       <description>MsSQLX connection URI</description>
     </context-param>

4. Save your changes to the file.
5. Restart the application server by performing the following:

   systemctl restart tomcat

6. If required, verify successful failover between the PRIMARY and SECONDARY servers.