Adding AlwaysOn Pseudo-Clients Using the Commvault CLI

Last post 12-06-2017, 6:57 PM by jahn. 1 replies.
Sort Posts: Previous Next
  • Adding AlwaysOn Pseudo-Clients Using the Commvault CLI
    Posted: 12-06-2017, 4:24 AM

    Hello,

    We want to make an automated AlwaysOn cluster creation in Commvault. We have that configured for Windows SQL clusters using pseudo-client create xml template. I couldn't find any information regarding Always On clusters. Maybe someone from the community has implemented automatic build in their environment and could share the xml template?

    Thanks!

  • Re: Adding AlwaysOn Pseudo-Clients Using the Commvault CLI
    Posted: 12-06-2017, 6:57 PM

    Its 3 steps process and you need to know your primary replica.

     

    Retrieve info from primary replica first by using GetReplica:

     

    GetReplica.xml

    <App_GetAvailabilityGroupReplicasReq availabilityGroup="AvailabilityG1">

                    <sqlClient clientName="ida18"/>

                    <instanceEntity clientName="ida18" instanceName="IDA18"/>

    </App_GetAvailabilityGroupReplicasReq>

     

    Retrieve info about availability group by specifying primary replica

     

    GetAvalibility group:

     

    AvailabilityGroup.xml

    <App_GetAvailabilityGroupsReq>

                    <sqlClient clientName="ida18"/>

                    <instanceEntity clientName="ida18" instanceName="IDA18"/>

    </App_GetAvailabilityGroupsReq>

     

    Create availability group with all collected in in 2 previous runs info:

     

    qoperation execute -af C:\temp\createAGClient.xml

     

    createAGClient.xml

    <App_CreatePseudoClientRequest>

                    <clientInfo clientType="MSSQL_AG">

                                    <mssqlagClientProperties>

                                                    <SQLServerInstance clientName="ida18" instanceName="IDA18"/>

                                                    <availabilityGroup backupPreference="2" name="AvailabilityG1" primaryReplicaServerName="IDA18" uniqueId="36E7C0CB-8FA9-4C75-8E09-86896EBD3702">

                                                                    <SQLAvailabilityGroupListenerList availabilityGroupListenerName="ida18_19_Ag1"/>

                                                    </availabilityGroup>

                                                    <SQLAvailabilityReplicasList>

                                                                    <SQLAvailabilityReplicasList availabilityMode="1" backupPriority="71" connectionState="1" failoverMode="1" name="IDA18" role="1"/>

                                                                    <SQLAvailabilityReplicasList availabilityMode="1" backupPriority="50" connectionState="1" failoverMode="1" name="IDA19" role="2"/>

                                                    </SQLAvailabilityReplicasList>

                                    </mssqlagClientProperties>

                    </clientInfo>

                    <entity clientName="testag1"/>

    </App_CreatePseudoClientRequest>

     

     

    http://forum.commvault.com/forums/thread/55223.aspx 
The content of the forums, threads and posts reflects the thoughts and opinions of each author, and does not represent the thoughts, opinions, plans or strategies of Commvault Systems, Inc. ("Commvault") and Commvault undertakes no obligation to update, correct or modify any statements made in this forum. Any and all third party links, statements, comments, or feedback posted to, or otherwise provided by this forum, thread or post are not affiliated with, nor endorsed by, Commvault.
Commvault, Commvault and logo, the “CV” logo, Commvault Systems, Solving Forward, SIM, Singular Information Management, Simpana, Commvault Galaxy, Unified Data Management, QiNetix, Quick Recovery, QR, CommNet, GridStor, Vault Tracker, InnerVault, QuickSnap, QSnap, Recovery Director, CommServe, CommCell, SnapProtect, ROMS, and CommValue, are trademarks or registered trademarks of Commvault Systems, Inc. All other third party brands, products, service names, trademarks, or registered service marks are the property of and used to identify the products or services of their respective owners. All specifications are subject to change without notice.
Close
Copyright © 2017 Commvault | All Rights Reserved. | Legal | Privacy Policy