SQL Server HA Environment / dSources

  • 0
  • 1
  • Question
  • Updated 2 weeks 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

  • 100 Points 100 badge 2x thumb

Posted 2 weeks ago

  • 0
  • 1
Photo of Neal Stack

Neal Stack, Employee

  • 2,902 Points 2k badge 2x thumb
Official Response
Hello,

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:
https://docs.delphix.com/docs/delphix-administration/sql-server-environments-and-data-sources/managing-sql-server-environments/adding-a-sql-server-source-environment
or
https://docs.delphix.com/docs/quick-start-guides/quick-start-guide-for-sql-server-microsoft-sql-server-on-windows#QuickStartGuideforSQLServer(MicrosoftSQLServeronWindows)-SourceEnvironmentRequirements