Submit a ticketCall us

Welcome to the NEW Success Center. Search all resources (documentation, videos, training, knowledge base articles) or browse resources by product. If you are unable to find what you are looking for, please contact us at customersuccess@solarwinds.com

 

 

 

 

Home > Success Center > Database Performance Analyzer (DPA) > Configure failover for the DPA server

Configure failover for the DPA server

Recommended configuration

SolarWinds recommends hosting DPA in a virtualized infrastructure. Virtual hosting increases hardware fault tolerance and makes the DPA deployment less dependent on physical hardware.

Alternate configuration: Cluster failover

If you have a cluster environment, you can configure DPA for continuous monitoring during an outage or failover.

Requirements

  • Host the repository database in a SQL Server Active/Passive Cluster or Oracle Real Application Clusters (RAC).
  • Host the DPA server on the same cluster as the shared storage.
  • The cluster must be set up with shared storage, accessible to any node in the cluster, and a virtual IP/DNS alias for its clients.

The diagram below depicts a SQL Server Active/Passive Cluster housing the DPA repository:

fail1.jpg

To implement DPA in this configuration:

  1. Install DPA on the active node on shared storage. This creates the DPA service on the active node.
  2. Create an identical service on one or more secondary nodes.
  3. Configure the failover response. The cluster management should:
    1. Stop the service on the primary node.
    2. Failover the shared storage and virtual IP.
    3. Start the service on the secondary node.
  4. Configure the failback response to do the reverse.

With Oracle RAC, the above DPA software configuration can be used if the Cluster shares disks to house the DPA software. Since all nodes are active in an Oracle RAC configuration, you should configure DPA to use the 'Shared or Load Balanced'  connect string to the Repository.

 

Last modified
14:06, 14 Dec 2015

Tags

Classifications

Public