Skip to main content
Delphix

Adding a Read-Scale Availability Group database to Delphix (KBA7150)

 

KBA

KBA# 7150

 

Issue

  • A Read-Scale Availability Group (Read-Scale AG) does not have or need a cluster context, therefore the environment must be added as standalone.
  • However, the Delphix engine does not discover AG databases configured in the Read-Scale AG if the environment has been added as standalone. 

Prerequisites

  • A Read-Scale Availability Group database.
  • General pre-requisites about adding a Windows source environment and linking a dSource.
  • CLI (SSH) access to create the database configuration.
  • If validate sync is used, backups must be taken on the same node as the source environment in the Delphix engine.

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies
Major Release All Sub Releases
6.0 6.0.0.0, 6.0.1.0, 6.0.1.1, 6.0.2.0, 6.0.2.1, 6.0.3.0, 6.0.3.1, 6.0.4.0, 6.0.4.1, 6.0.4.2, 6.0.5.0, 6.0.6.0, 6.0.6.1

5.3

5.3.0.0, 5.3.0.1, 5.3.0.2, 5.3.0.3, 5.3.1.0, 5.3.1.1, 5.3.1.2, 5.3.2.0, 5.3.3.0, 5.3.3.1, 5.3.4.0, 5.3.5.0 5.3.6.0, 5.3.7.0, 5.3.7.1, 5.3.8.0, 5.3.8.1, 5.3.9.0

5.2

5.2.2.0, 5.2.2.1, 5.2.3.0, 5.2.4.0, 5.2.5.0, 5.2.5.1, 5.2.6.0, 5.2.6.1

5.1

5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0, 5.1.4.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.1.7.0, 5.1.8.0, 5.1.8.1, 5.1.9.0, 5.1.10.0

5.0

5.0.1.0, 5.0.1.1, 5.0.2.0, 5.0.2.1, 5.0.2.2, 5.0.2.3, 5.0.3.0, 5.0.3.1, 5.0.4.0, 5.0.4.1 ,5.0.5.0, 5.0.5.1, 5.0.5.2, 5.0.5.3, 5.0.5.4

4.3

4.3.1.0, 4.3.2.0, 4.3.2.1, 4.3.3.0, 4.3.4.0, 4.3.4.1, 4.3.5.0

4.2

4.2.0.0, 4.2.0.3, 4.2.1.0, 4.2.1.1, 4.2.2.0, 4.2.2.1, 4.2.3.0, 4.2.4.0 , 4.2.5.0, 4.2.5.1

4.1

4.1.0.0, 4.1.2.0, 4.1.3.0, 4.1.3.1, 4.1.3.2, 4.1.4.0, 4.1.5.0, 4.1.6.0

Resolution

Once the environment has been added as standalone, you need to create the database configuration manually via the CLI.
There are three fields required:

  1. databaseName
  2. environmentUser
  3. repository

The TAB key can be used to auto-complete the fields:

ssh admin@delphix

delphix > sourceconfig create
delphix sourceconfig create *> set databaseName=McLaren
delphix sourceconfig create *> set environmentUser=source.delphix.com/domain\username
delphix sourceconfig create *> set repository=sandro9src.dcol1.delphix.com/SQL2017
delphix sourceconfig create *> ls
Properties
    type: MSSqlSIConfig (*)
    databaseName: McLaren (*)
    environmentUser: source.delphix.com/domain\username (*)
    linkingEnabled: true
    mirroringState: (unset)
    recoveryModel: (unset)
    repository: sandro9src.dcol1.delphix.com/SQL2017 (*)
delphix sourceconfig create *> commit
    `MSSQL_SINGLE_CONFIG-3
  • After creating the configuration, it is possible to navigate to Manage / Environments, select the source environment and then, on the Databases tab, click Add dSource next to the database name.
  • From there, the workflow to add the dSource is the same.
  • Check that the type is set to MSSqlSIConfig before committing.

 

 


Related Articles

The following articles may provide more information or related information to this article: