SQL Server HA Environment / dSources

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
Good Day ,

Scenario: I have a SQL Server AG setup  , replicated databases to Secondary Node and those database on Primary must be ingested into Delphix Engine. 

Quick One: Which IP / DNS Name must i register to Delphix Engine?
 AG Listener ?

Definitely Primary Node Server name wont be ideal .

Photo of Zingisa Lolwana

Zingisa Lolwana

  • 110 Points 100 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Photo of Neal Stack

Neal Stack, Employee

  • 3,422 Points 3k badge 2x thumb
Official Response

You can use databases on Windows Server Failover Clusters (WSFC) as data sources. Add the environment as described below, based on which WSFC feature the source databases use:

  • Failover Cluster Instances
    Add the environment as a standalone source using the cluster name or address.
  • AlwaysOn Availability Groups
    Add the environment as a cluster source using the cluster name or address.

If using a Failover Cluster or AlwaysOn data source, the cluster configuration must also meet the following requirements:

  • The fully qualified Cluster Name (part of the cluster's Core Resources) must be known to the DNS server used by the Delphix Engine
  • The validated sync environment must be able to resolve the Cluster Name using the Cluster IP address (perform a reverse DNS lookup)

More details here:
Photo of Zingisa Lolwana

Zingisa Lolwana

  • 110 Points 100 badge 2x thumb
Good Day ,

I only managed to add WSFC Cluster DNS Name , source and standalone and only non-AG databases are visible.

I assumed i can do WSFC IP Address / DNS Name , source and cluster. The system complains : Exception calling "GetHostEntry" with "1" argument(s): "No such host is known" .

I can ping my WSFC Ip address and do a nslookup.