Many databases provide advanced database replication technologies such as DB2 High Availability Disaster Recovery (HADR), Oracle Real Application Clusters (RAC), and Microsoft Cluster Server (MSCS). The failover functionality provided by the drivers does not require any of these technologies, but can work with them to provide comprehensive failover protection. Use the following guidelines for primary and alternate servers to ensure that failover works correctly in your environment:
Alternate servers should mirror data on the primary server or be part of a configuration where multiple database nodes share the same physical data.
If using failover with DB2 HADR, the primary server must be the primary server configured in your HADR system and any alternate server must be a standby server configured in your HADR system.
If using failover with an Oracle RAC, the primary server must be a primary node and any alternate server must be a secondary node.
If using failover with MSCS, which determines the alternate server for failover instead of the driver, any alternate server specified must be the same as the primary server. For example: