Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

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