public virtual FailoverGroupUpdateOperation Update(FailoverGroupUpdate parameters, bool waitForCompletion = true, CancellationToken cancellationToken = default)
{
if (parameters == null)
{
throw new ArgumentNullException(nameof(parameters));
}
using var scope = _clientDiagnostics.CreateScope("FailoverGroup.Update");
scope.Start();
try
{
var response = _failoverGroupsRestClient.Update(Id.SubscriptionId, Id.ResourceGroupName, Id.Parent.Name, Id.Name, parameters, cancellationToken);
var operation = new FailoverGroupUpdateOperation(this, _clientDiagnostics, Pipeline, _failoverGroupsRestClient.CreateUpdateRequest(Id.SubscriptionId, Id.ResourceGroupName, Id.Parent.Name, Id.Name, parameters).Request, response);
if (waitForCompletion)
{
operation.WaitForCompletion(cancellationToken);
}
return(operation);
}
catch (Exception e)
{
scope.Failed(e);
throw;
}
}
/// <summary>
/// Updates a failover group.
/// </summary>
/// <param name='operations'>
/// The operations group for this extension method.
/// </param>
/// <param name='resourceGroupName'>
/// The name of the resource group that contains the resource. You can obtain
/// this value from the Azure Resource Manager API or the portal.
/// </param>
/// <param name='serverName'>
/// The name of the server containing the failover group.
/// </param>
/// <param name='failoverGroupName'>
/// The name of the failover group.
/// </param>
/// <param name='parameters'>
/// The failover group parameters.
/// </param>
/// <param name='cancellationToken'>
/// The cancellation token.
/// </param>
public static async Task <FailoverGroup> BeginUpdateAsync(this IFailoverGroupsOperations operations, string resourceGroupName, string serverName, string failoverGroupName, FailoverGroupUpdate parameters, CancellationToken cancellationToken = default(CancellationToken))
{
using (var _result = await operations.BeginUpdateWithHttpMessagesAsync(resourceGroupName, serverName, failoverGroupName, parameters, null, cancellationToken).ConfigureAwait(false))
{
return(_result.Body);
}
}
/// <summary>
/// Updates a failover group.
/// </summary>
/// <param name='operations'>
/// The operations group for this extension method.
/// </param>
/// <param name='resourceGroupName'>
/// The name of the resource group that contains the resource. You can obtain
/// this value from the Azure Resource Manager API or the portal.
/// </param>
/// <param name='serverName'>
/// The name of the server containing the failover group.
/// </param>
/// <param name='failoverGroupName'>
/// The name of the failover group.
/// </param>
/// <param name='parameters'>
/// The failover group parameters.
/// </param>
public static FailoverGroup BeginUpdate(this IFailoverGroupsOperations operations, string resourceGroupName, string serverName, string failoverGroupName, FailoverGroupUpdate parameters)
{
return(operations.BeginUpdateAsync(resourceGroupName, serverName, failoverGroupName, parameters).GetAwaiter().GetResult());
}
public void TestCrudFailoverGroup()
{
using (SqlManagementTestContext context = new SqlManagementTestContext(this))
{
ResourceGroup resourceGroup = context.CreateResourceGroup();
SqlManagementClient sqlClient = context.GetClient <SqlManagementClient>();
// Create primary and partner servers
//
var sourceServer = context.CreateServer(resourceGroup);
var targetServer = context.CreateServer(resourceGroup, location: TestEnvironmentUtilities.DefaultSecondaryLocationId);
// Create a failover group
//
string failoverGroupName = SqlManagementTestUtilities.GenerateName();
var fgInput = new FailoverGroup()
{
ReadOnlyEndpoint = new FailoverGroupReadOnlyEndpoint()
{
FailoverPolicy = ReadOnlyEndpointFailoverPolicy.Disabled,
},
ReadWriteEndpoint = new FailoverGroupReadWriteEndpoint()
{
FailoverPolicy = ReadWriteEndpointFailoverPolicy.Manual,
},
PartnerServers = new List <PartnerInfo>()
{
new PartnerInfo()
{
Id = targetServer.Id
},
},
Databases = new List <string>(),
};
var failoverGroup = sqlClient.FailoverGroups.CreateOrUpdate(resourceGroup.Name, sourceServer.Name, failoverGroupName, fgInput);
SqlManagementTestUtilities.ValidateFailoverGroup(fgInput, failoverGroup, failoverGroupName);
var failoverGroupOnPartner = sqlClient.FailoverGroups.Get(resourceGroup.Name, targetServer.Name, failoverGroupName);
Assert.NotNull(failoverGroupOnPartner);
// Update a few settings
//
var fgPatchInput = new FailoverGroupUpdate
{
ReadOnlyEndpoint = new FailoverGroupReadOnlyEndpoint
{
FailoverPolicy = ReadOnlyEndpointFailoverPolicy.Enabled
},
ReadWriteEndpoint = new FailoverGroupReadWriteEndpoint
{
FailoverPolicy = ReadWriteEndpointFailoverPolicy.Automatic,
FailoverWithDataLossGracePeriodMinutes = 120
},
Tags = new Dictionary <string, string> {
{ "tag1", "value1" }
}
};
var failoverGroupUpdated2 = sqlClient.FailoverGroups.Update(resourceGroup.Name, sourceServer.Name, failoverGroupName, fgPatchInput);
// Set expectations and verify update
//
fgInput.ReadWriteEndpoint = fgPatchInput.ReadWriteEndpoint;
fgInput.ReadOnlyEndpoint = fgPatchInput.ReadOnlyEndpoint;
fgInput.Tags = fgPatchInput.Tags;
SqlManagementTestUtilities.ValidateFailoverGroup(fgInput, failoverGroupUpdated2, failoverGroupName);
// Create a database in the primary server
//
string databaseName = "testdb";
var dbInput = new Database()
{
Location = sourceServer.Location
};
Database database = sqlClient.Databases.CreateOrUpdate(resourceGroup.Name, sourceServer.Name, databaseName, dbInput);
Assert.NotNull(database);
// Update failover group to add database and change read-write endpoint's failover policy.
//
var fgUpdateInput = new FailoverGroup()
{
ReadOnlyEndpoint = new FailoverGroupReadOnlyEndpoint()
{
FailoverPolicy = ReadOnlyEndpointFailoverPolicy.Disabled,
},
ReadWriteEndpoint = new FailoverGroupReadWriteEndpoint()
{
FailoverPolicy = ReadWriteEndpointFailoverPolicy.Manual,
},
PartnerServers = new List <PartnerInfo>()
{
new PartnerInfo()
{
Id = targetServer.Id
},
},
Databases = new List <string>()
{
database.Id,
},
};
failoverGroup = sqlClient.FailoverGroups.CreateOrUpdate(resourceGroup.Name, sourceServer.Name, failoverGroupName, fgUpdateInput);
SqlManagementTestUtilities.ValidateFailoverGroup(fgUpdateInput, failoverGroup, failoverGroupName);
// List failover groups on the secondary server and verify
//
var failoverGroupsOnSecondary = sqlClient.FailoverGroups.ListByServer(resourceGroup.Name, targetServer.Name);
Assert.NotNull(failoverGroupsOnSecondary);
Assert.Equal(1, failoverGroupsOnSecondary.Count());
var primaryDatabase = sqlClient.Databases.Get(resourceGroup.Name, sourceServer.Name, databaseName);
// A brief wait may be needed until the secondary database is fully created
Database secondaryDatabase = new Database();
SqlManagementTestUtilities.ExecuteWithRetry(() =>
{
secondaryDatabase = sqlClient.Databases.Get(resourceGroup.Name, targetServer.Name, databaseName);
},
TimeSpan.FromMinutes(2), TimeSpan.FromSeconds(5),
(CloudException e) =>
{
return(e.Response.StatusCode == HttpStatusCode.NotFound);
});
Assert.NotNull(primaryDatabase.FailoverGroupId);
Assert.NotNull(secondaryDatabase.FailoverGroupId);
// Failover failover group
//
failoverGroup = sqlClient.FailoverGroups.Failover(resourceGroup.Name, targetServer.Name, failoverGroupName);
// Get failover group on the new secondary server and verify its replication role
//
var failoverGroupOnSecondary = sqlClient.FailoverGroups.Get(resourceGroup.Name, sourceServer.Name, failoverGroupName);
Assert.Equal(FailoverGroupReplicationRole.Secondary, failoverGroupOnSecondary.ReplicationRole);
Assert.Equal(FailoverGroupReplicationRole.Primary, failoverGroupOnSecondary.PartnerServers.First().ReplicationRole);
// Delete failover group and verify that databases are removed from the failover group
//
sqlClient.FailoverGroups.Delete(resourceGroup.Name, targetServer.Name, failoverGroupName);
primaryDatabase = sqlClient.Databases.Get(resourceGroup.Name, targetServer.Name, databaseName);
secondaryDatabase = sqlClient.Databases.Get(resourceGroup.Name, sourceServer.Name, databaseName);
Assert.Null(primaryDatabase.FailoverGroupId);
Assert.Null(secondaryDatabase.FailoverGroupId);
Assert.Throws <Microsoft.Rest.Azure.CloudException>(() => sqlClient.FailoverGroups.Get(resourceGroup.Name, sourceServer.Name, failoverGroupName));
Assert.Throws <Microsoft.Rest.Azure.CloudException>(() => sqlClient.FailoverGroups.Get(resourceGroup.Name, targetServer.Name, failoverGroupName));
}
}
public virtual FailoverGroupsUpdateOperation StartUpdate(string resourceGroupName, string serverName, string failoverGroupName, FailoverGroupUpdate parameters, CancellationToken cancellationToken = default)
{
if (resourceGroupName == null)
{
throw new ArgumentNullException(nameof(resourceGroupName));
}
if (serverName == null)
{
throw new ArgumentNullException(nameof(serverName));
}
if (failoverGroupName == null)
{
throw new ArgumentNullException(nameof(failoverGroupName));
}
if (parameters == null)
{
throw new ArgumentNullException(nameof(parameters));
}
using var scope = _clientDiagnostics.CreateScope("FailoverGroupsOperations.StartUpdate");
scope.Start();
try
{
var originalResponse = RestClient.Update(resourceGroupName, serverName, failoverGroupName, parameters, cancellationToken);
return(new FailoverGroupsUpdateOperation(_clientDiagnostics, _pipeline, RestClient.CreateUpdateRequest(resourceGroupName, serverName, failoverGroupName, parameters).Request, originalResponse));
}
catch (Exception e)
{
scope.Failed(e);
throw;
}
}
public async virtual Task <FailoverGroupUpdateOperation> UpdateAsync(bool waitForCompletion, FailoverGroupUpdate parameters, CancellationToken cancellationToken = default)
{
if (parameters == null)
{
throw new ArgumentNullException(nameof(parameters));
}
using var scope = _failoverGroupClientDiagnostics.CreateScope("FailoverGroup.Update");
scope.Start();
try
{
var response = await _failoverGroupRestClient.UpdateAsync(Id.SubscriptionId, Id.ResourceGroupName, Id.Parent.Name, Id.Name, parameters, cancellationToken).ConfigureAwait(false);
var operation = new FailoverGroupUpdateOperation(ArmClient, _failoverGroupClientDiagnostics, Pipeline, _failoverGroupRestClient.CreateUpdateRequest(Id.SubscriptionId, Id.ResourceGroupName, Id.Parent.Name, Id.Name, parameters).Request, response);
if (waitForCompletion)
{
await operation.WaitForCompletionAsync(cancellationToken).ConfigureAwait(false);
}
return(operation);
}
catch (Exception e)
{
scope.Failed(e);
throw;
}
}
